three different forms, which do slightly different things (global last
identity, connection last identity, and database last identity, or something
like that). Check the docs.
Cheers,
barneyb
> -----Original Message-----
> From: Burns, John [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 11, 2004 10:03 AM
> 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]
