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, -- 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] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
