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]
