List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:December 5 2001 5:57pm
Subject:Re: $dbh->{'mysql_insertid'} returning 0
View as plain text  
Zitiere "Vaughan, Penny " <Penny.Vaughan@stripped>:

> I was using $dbh->{'mysql_insertid'} to return the auto_increment number
> with no problem until a recent server upgrade.  We moved everything to a
> new box, but had to re-install the mysql perl modules.  We're running
> mysql 3.22.25.  Now, I'm just getting 0 whether I use the database
> handle or the statement handle in my cgi.  No error messages are showing
> up so it thinks it's working.

This used to be a bug in previous versions of the module.
Are you using a current version?

If so, please send a simple test script that creates a
table, inserts some records and demonstrates the problem.
$dbh->{'mysql_insertid'} returning 0Penny  Vaughan4 Dec
  • Re: $dbh->{'mysql_insertid'} returning 0Nick Tonkin4 Dec
    • Re: $dbh->{'mysql_insertid'} returning 0Nick Tonkin5 Dec
  • Re: $dbh->{'mysql_insertid'} returning 0Jochen Wiedmann5 Dec
  • list of open DB handles?Bernd Prager10 Dec
    • Re: list of open DB handles?Jochen Wiedmann10 Dec
Re: $dbh->{'mysql_insertid'} returning 0Ruben Safir5 Dec
  • Re: $dbh->{'mysql_insertid'} returning 0sherzodR5 Dec
RE: $dbh->{'mysql_insertid'} returning 0Penny  Vaughan5 Dec
RE: $dbh->{'mysql_insertid'} returning 0Penny  Vaughan5 Dec
  • Re: $dbh->{'mysql_insertid'} returning 0Chuck O'Donnell5 Dec
RE: $dbh->{'mysql_insertid'} returning 0Penny  Vaughan5 Dec