Hi Darren, I try sometimes LAST_INSERT_ID and it works perfect. The function
works correctly when you insert a record and in the same connection do the
select. It's necessary that you have to launch the select in the same
connection that you inserted the record. You can say the table where you
want to see the last id.
SELECT LAST_INSERT_ID() FROM TABLE;
I hope help you.
Fermín Latas
-----Mensaje original-----
De: Darren Hill [mailto:dhi...@ormac.com]
Enviado el: jueves, 09 de marzo de 2006 17:42
Para: dot...@lists.mysql.com
Asunto: SELECT LAST_INSERT_ID() not working
Importancia: Alta
Sorry all,
But this is huge. The SELECT LAST_INSERT_ID() has decided to stop working
and I'm stumped. Is this a bug in the new connector?
________________________________________
Darren Hill - dhi...@ormac.com
________________________________________
12 messages in com.mysql.lists.dotnetRE: SELECT LAST_INSERT_ID() not working