Hi all.

I'm using DBI-1.42, Perl-5.8.4, MySQL-4.0.18 and DBD::MySQL-2.9003.
I'm trying to get the ID of the last inserted record.

I can use:

$dbh->{'mysql_insertid'}

and it returns the correct value, however if I change the above to:

$dbh->last_insert_id()

it doesn't work. It returns undef. I'd like to use last_insert_id() because I want to be able to use this bit of code to handle updates with different databases.

What's up?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

Reply via email to