yes...had some problems with that, but with this parameter combination:
$self->db->dbh->last_insert_id(undef, undef, 'tablename', 'id_name');
SQLite, MySQL 4.0 and PostgreSQL 8.1 all pass my tests.
I think SERIAL UNIQUE NOT NULL was also necessary for Pg, but not sure. | [reply] [d/l] |
Aye. Reading the DBI docs that Corion pointed me to were a great help. I ended up with the following as my call to last_insert_id:
my $LastID = $dbh->last_insert_id(undef, 'public', 'CUSTOMER_INFORMATION', 'ID');
| [reply] [d/l] |