Rough example. Assuming that you are using the same connection since
last_insert_id() is connection specific.

rset.open "INSERT INTO table1 values(someValue) "
rset.open "SELECT last_insert_id() as identity"
identity = rset.fields("identity")


-----Original Message-----
From: Aaron
To: [EMAIL PROTECTED]
Sent: 3/10/04 4:04 PM
Subject: @@identity

How can I select the last record that was inserted? An ASP/VB example
would
be great too!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to