Using the database handle

[Mike(mickako)Blezien]

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