add this:
$sth -> finish;
$dbh -> disconnect;
to the end
----- Original Message -----
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail List" <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 11:44 PM
Subject: DBI:mysql error message
> Hey everybody,
>
>
> This is my perl DBI script:
>
> #!/usr/bin/perl -w
>
> use DBI;
>
> $username = "myusername" ;
> $mypassword="mypassword" ;
>
> my $dbh = DBI->connect("DBI:mysql:table1:localhost", "$username",
> "$mypassword");
> die "Can't open DB\n" if (!defined $dbh);
>
> my $sth = $dbh->prepare("SELECT * FROM abcpro") or die "Can't prepare SQL
>Statement:" ;
>
>
> This is the crazy error message I'm getting:
>
> Issuing rollback() for database handle being DESTROY'd without explicit disconnect().
>
>
> Anyone out there who is not a newbie know wha is going wrong! Any help/suggestions
>will be much
> appreciated.
>
> Thanks a lot.
>
>
>
> =====
> #########################################
> Simon K. Chan
> <insert important-sounding title here>
>
> "Great spirits have always encountered violent opposition from mediocre minds."
>
> -Albert Einstein
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
>
> ---------------------------------------------------------------------
> 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 <mysql-unsubscribe-##L=##[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
