Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
install_driver(mysql) failed Error
Hi, I am trying to connect to local mysql server through a perl script but getting following error install_driver(mysql) failed: Can't load '/usr/local/lib/.../mysql/mysql.so' for module DBD::mysql: ld.so.1: perl5.8.0: fatal: libmysqlclient.so.10: open failed: No such file or directory at... -
update multiple rows having diff condition in one go
Hello, I have to do update operation to the set of records e.g. update tablename set value=100 where id=1; update tablename set value=200 where id=2; update tablename set value=300 where id=3; update tablename set value=400 where id=4; I tried pasting all the statements in query browser but... -
data populating in only one cell
Hi All, I am trying to create a spreadsheet though PHP. Tough i am not using any specific library, i am formatting the data first and then writing it into file as text stream. The excel file is getting generated but the data is populating only once cell (left first row), but i want it to be in... -
backslash gets converted to forward slash
Hi All, I am trying to give a link in my html document to some document on LAN. Below is the example <a href="\\pathtoLAN\somedocument.zip">click</a> I found that on some PCs the backslash(\) gets converted to forward slash (/) and hence the link does not work properly. Can someone tell me...- Zoom1234
- Thread
- Replies: 3
- Forum: HTML, XHTML & CSS
-
What version is stored procedure implemented
Hi, From what version of MySQL is the stored procedure implemented? Can it be written / executed on MySQL version 4.1.22? Thanks in advance. -
How to use variables in stored procedure
Hi, I have written a following stored procedure CREATE OR REPLACE PROCEDURE SP_TEST DECLARE tablename VARCHAR2(50) ; id NUMBER ; column1 NUMBER ; column2 VARCHAR2(50) ; column3 DATE ; strencrypt VARCHAR2(50); dateencrypt DATE...- Zoom1234
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
how oracle stores the date
Hi, In what format does oracle store the date..(dd/mm/yyyy?). I want to create a table and update the date column to value '1st Jan 1881'. What data type should i define (date or timestamp). Thanks in advance.- Zoom1234
- Thread
- Replies: 8
- Forum: Oracle: All versions
-
Retrive and update records in bulk
Hi, I have a to fetch records from one mysql server and update it in another server. connect to database1 retrieve records from a table (ID is primary key) connect to database2 update the record in the table using ID Since there are large no of records (about 500000), I am wondering what is... -
Installing PHP, MySQL and Apache
Hi, I want to set up an environment on my windows machine for PHP, MySQL, Apache. Is there any bundled software that will install these three softwares together(so that it's easy to install). I came to know about 'wampserver' software on web. http://www.wampserver.com/en/ Has someone any idea... -
Latest modified records
Hi, I have a table for each keyfield i have multiple records. i Want to get the latest modified records for each keyfield. I am trying this select S.keyfield, S.status, PT.producttemplatename from SERVICE S, SERVICETEMPLATE ST, PRODUCTTEMPLATE PT where S.keyfield in (1234, 5678) and... -
Copy files between two servers
Hi, I want to write a Unix script (Bash), which will copy files across unix machines. The script will be having four parameters. Source machine, Target machine, source location and target location. How do i go about it. How can i connect to remote machine in my script? TIA- Zoom1234
- Thread
- Replies: 2
- Forum: UNIX Scripting
-
Oracle DBD error
Hi, I am getting folowing error when trying to execute sql query from my perl script. ERROR :install_driver(Oracle) failed: Can't load '/path/lib/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0: open failed: No such file or directory at... -
Regex help
Hi, I have following strings string1: //ap21cnedc22/retail/main/eCommerce/Development/Release1_updated_Content/shop/production/WORKAREA/Application_Development string2... -
How to catch multiple occurence in single line
I have following data ABCXYCZ DEGCPYCJ I want every character after C, to be pushed into an array. But when i write, my @arr = () ; open file while ( <FH> ) { if ( $_ =~ /C(.)/ ) { push(@arr, $1) ; } } it only recognize first occurence of C in single line and does not consider... -
Regex Help
Hi, $group = "A,B,C,D" ; $str = "A,D" ; I want to see if $group contains letters A and D. How is it possible without splitting $str? TIA -
Help reqd in Formatting
Hi, I am getting record as follows foreach $file ( ) { ..//some regex ..//$dir = $1 ; #this can be repeated in foreach loop ..//$file for $dir ..//$owner for $file ..//associated files for $file } I want output like this Dir Name FileName1 Owner1 Associated file1... -
$sth->rows always return zero
Hi, I am using following code $sql = "select * from." ; $snth = $db->prepare($sql); my $rcn = $snth->execute(); my $rows = $snth->rows ; print $rows ; Even if the query fetches rows and displays it, $rows variable is always set to zero. What am i doing wrong here? -
RegEx Blues
Hi, Why if ( $str =~ /(.*)TEST/ ) { ... } if ( $str =~ /(.*)TEST1/ ) { ... } $cwd = $1 ; this doesn't work. But this works fine if ( $str =~ /(.*)TEST/ ) { ... $cwd = $1 ; } if ( $str =~ /(.*)TEST1/ ) { ... $cwd = $1 ; } -
Declaration of variable inside loop
HI, I want to know what impact (on memory etc) it does to declare variable inside loop instead of before loop. Case foreach (@testarr) { my $test = $_ ; # some code here } instead of my $test ; foreach (@testarr) { $test = $_ ; # some code here } -
Passing array to oracle SP
Hi, Can someone tell me how to pass an array as input paramter to oracle in perl? Thanks
