mySQL / Last inserted record ID

[Richard N.]

Hi,

I'm using mySQL and wanted to get the ID of the record that I have just
inserted in to the table (sentmessages). There is a function in mySQL that
appears to be able to perform this task but I am not having any luck in
getting it to work.

Anybody else tried, successfully or not, to use this ?

The function is called LAST_INSERT_ID() and I have tried to implement it as
follows :

strLastID = objConn.Execute("SELECT LAST_INSERT_ID() FROM sentmessages")


Thanks

Richard

 

[Richard N.]

SQL Server has @@IDENTITY
http://www.kamath.com/tutorials/tut007_identity.asp

But I don't know if mySQL supports that. Search the manual for IDENTITY. I
think there is some form of this, but I'm not sure what exactly it looks
like.

HTH.
Peter Foti

So does mySQL apparently ! Works great thanks.......

Richard