You might have better luck with this on the [EMAIL PROTECTED] list,
re: why this doesn't work. This works for me though:
$pk = $dbh->{mysql_insertid};
On Mon, 2004-06-14 at 21:42, Daniel Kasak wrote:
> Hi all.
>
> I'm writing an app in Perl / Gtk2, and I'm having trouble with DBI's
> last_insert_id() function.
> I have so far:
>
> > eval {
> > $sth->execute (@bind_values) || die $dbh->errstr;
> > };
> >
> > # If the above failed, there will be something in the special
> > variable $@
> > if ($@) {
> >
> > # Dialog explaining error...
> > my $dialog = &msgbox(
> > $prospects->get_widget("Prospects"),
> > "Error updating recordset!",
> > "Database Server says:\n" . $dbh->errstr,
> > 1
> > );
> >
> > $dialog->run;
> > $dialog->destroy;
> >
> > warn "Error updating recordset:[EMAIL PROTECTED]" . $@ .
> > "\n\n";
> >
> > return 0;
> >
> > }
> >
> >
> > $pk = $dbh->last_insert_id();
>
> The statement executes successfully, and the data is inserted. However
> the above line that fetches the last_insert_id value from MySQL always
> returns undef. The table has an auto_increment column. What's going on?
>
> Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
