RE: perl mysql DBI::db question

[nickg]

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 dont like the below die statement, it should exit gracefully.
        $sql_check->execute or die "Can't connect to users table :
$dbh-errstr";
        my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array();
>>        $sql_check->finish;
        $dbh->disconnect;
        if($debug_state) {
                print "S: $t_user,$t_password,$t_prefs\n";
        }

nickg


-----Original Message-----
From: Shon Stephens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 10:08 AM
To: [EMAIL PROTECTED]
Subject: perl mysql DBI::db question


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 124, <GEN1> line 2."

i think a finish statement is what i need, but i don't know how to exec it
properly. here is the code loop that generates this message

       my $sql_check = $dbh->prepare("select user,password,prefs from users
where username='$LNAME'");
        # I dont like the below die statement, it should exit gracefully.
        $sql_check->execute or die "Can't connect to users table :
$dbh-errstr";
        my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array();
        $dbh->disconnect;
        if($debug_state) {
                print "S: $t_user,$t_password,$t_prefs\n";
        }

thanks,
shon



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php