i am using the older v1.19 DBI. i looked at that line and it should not
cause a problem. the values are stored, even after the handle is destroyed
or the connection closed. the error is complaining that i should destroy
statement handles or call finish. thanks for the respones.

----- Original 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 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 .14 you may need to call
the
finish() after you execute() your statement handle.

sql,database,mysql

On Wed, 27 Feb 2002 11:07:51 -0500, "Shon Stephens"
<[EMAIL PROTECTED]>   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 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";
>>        }

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


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

Reply via email to