Re:mysql_insert_id and transactions

2001-12-03 Thread Heikki Tuuri
Hi! Ok, the problem the user had probably was calling the wrong Perl function. >From the MySQL manual: " insertid If you use the AUTO_INCREMENT feature of MySQL, the new auto-incremented values will be stored here. Example: $new_id = $sth->{insertid}; As an alternative, you can use $dbh->{'my

Re:mysql_insert_id and transactions

2001-12-03 Thread Jani Tolonen
Hi Jason and Heikki, Heikki Tuuri writes: > Jason, > > SELECT LAST_INSERT_ID() seemed to work from the mysql client. That is a > workaround. I forward this message to Sinisa and Venu, so that they can > check the Perl interface. > > >From the manual page of mysql_insert_id() I found the

Re:mysql_insert_id and transactions

2001-12-01 Thread Heikki Tuuri
Jason, SELECT LAST_INSERT_ID() seemed to work from the mysql client. That is a workaround. I forward this message to Sinisa and Venu, so that they can check the Perl interface. >From the manual page of mysql_insert_id() I found the following comment: " Charles Merriam: This may only work on mo