of the fields you just inserted. Doing a max(id) isn't 100% sure w/out
transactional processing. But if you select on several fields that you
*know* are unique... or at least, take the top record while sorting by the
id field descending, that should be pretty safe. Only if you added two
fields back to back with identical data would that hiccup on you.
At 11:02 AM 3/11/2004, you wrote:
>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]
