out, but you can also use a trigger if you're sticking to MS SQL. This is
my preferred way of dealing with this.
-----Original Message-----
From: Burns, John [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1:03 PM
To: CF-Talk
Subject: Reliable way to get ID of inserted record
I know this came up last week or so, but I believe the answer came for a
mySQL database. I need a way in MS SQL to get the last inserted record
via CF. I have a query inserting a row into the table with an
auto-increment ID. I need to insert that ID into a separate table in
another query so I first need to find out what ID it got assigned. I've
got it all wrapped in <cftransaction> but I'm not sure if max(id) is the
best way to get the ID, because if rows get deleted, won't SQL
automatically assign those values to new rows at some point, therefore
negating the max() idea?
John Burns
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
