Search results for query: *

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...

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...

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...

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...

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.

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...

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.

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...

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...

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...

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

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...

Hi, I have following strings string1: //ap21cnedc22/retail/main/eCommerce/Development/Release1_updated_Content/shop/production/WORKAREA/Application_Development string2...

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...

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

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...

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?

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 ; }

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 }

Hi, Can someone tell me how to pass an array as input paramter to oracle in perl? Thanks