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 :)
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(985)902-8484
MSN: [EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=