Sterin, Ilya (I.) wrote:
Run trace and see what's happening.
$dbh->trace(2);
Ilya
-----Original Message-----
From: Mike(mickako)Blezien [mailto:mickalo@;bellsouth.net]
Sent: Wednesday, October 30, 2002 4:03 PM
To: DBI List
Subject: Using the database handle
Hello,
I ran into a problem today while re-write some of our Perl scripts, utilizing the selectrow_array() and noticed if same database handle is used, it doesn't work properly... example
$dbh->connect(....) no problems connecting to database.
$sql = qq|select foo from table_a where id = 1|;
my($foo) = $dbh->selectrow_array($sql); # no errors
# $foo is returned correctly... no errrors query successful
some more coding......
# executing another query
$sql = qq|select foobar from table_b where id = 2|;
my($foobar) = $dbh->selectrow_array($sql)... no errors
# But the $foobar is not returned even tho it exist and this
# is a legal query... and no errors
is this due to calling it on the same database handle ($dbh)
thanks for any suggestion or help on this,
Thanks, will give that a shot and see what happens... thanks :) -- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
