|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE:
identity
From: Aaron (agflemyahoo.ca)
Date: Wed Mar 10 2004 - 16:40:06 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Great - thanks!
-----Original Message-----
From: Victor Pendleton [mailto:VPendletonhoovers.com]
Sent: March 10, 2004 5:36 PM
To: 'Aaron '; 'mysqllists.mysql.com '
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: mysqllists.mysql.com
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/mysql?unsub=VPendletonhoovers.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]