Shon wrote
> i am trying to write a program in perl and am getting a mysql error from my
> module. here is the error:
>
> DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle
> (either destroy statement handles or call finish on them before
> disconnecting) at ./pop.pl line 12
Message -
From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
To: "Shon Stephens" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 11:32 AM
Subject: Re: perl mysql DBI::db question
Try moving your $dbh->disconnect call afte
On Wed, 27 Feb 2002 10:40:21 -0600, "nickg" <[EMAIL PROTECTED]> wrote:
>>
>>You need to tell the handler you are finished with your statement, this will
>>free resources, etc..
>>
>>http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish
>>
>>
>>$sql_check->finish;
EXTREMELY out-dated!
MySQL
You need to tell the handler you are finished with your statement, this will
free resources, etc..
http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish
$sql_check->finish;
my $sql_check = $dbh->prepare("select user,password,prefs from users
where username='$LNAME'");
# I do
Try moving your $dbh->disconnect call after it prints out the fetchrow_array()
my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array();
if($debug_state) {
print "S: $t_user,$t_password,$t_prefs\n";
}
$dbh->disconnect();
If your using an older version of DBI, like 1.13 or
