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

[Peter Foti]

"Richard N." <richard@NOSPAMPLEASEbrandlink.co.uk> wrote in message
news:bn11n5$lk6$1@hercules.btinternet.com...

> 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")

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

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

[Richard N.]

<snip>

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

>
> SQL Server has @@IDENTITY
> [url]http://www.kamath.com/tutorials/tut007_identity.asp[/url]
>
> 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