Great - thanks!
-----Original Message-----
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: March 10, 2004 5:36 PM
To: 'Aaron '; '[EMAIL PROTECTED] '
Subject: RE: @@identity
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]
