R
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
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