RE: FN-FORUM: asp/sql - the correct way to get the ID of the record you just added?

date posted 9th January 2007 11:27

Chris,

Make a call to SCOPE_IDENTITY() (rather than @@IDENTITY) after you do =
the INSERT. More info from Microsoft here:

http://msdn2.microsoft.com/en-us/library/ms190315.aspx

And a further explanation here:

http://codebetter.com/blogs/john.papa/archive/2006/04/07/142503.aspx

with examples.

Cheers,
Andrew.

--
_____________________________
Andrew Bibby
I.T. Solutions Ltd
http://www.itsolutions.uk.com


-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of =
[EMAIL REMOVED]
Sent: 09 January 2007 11:56
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: asp/sql - the correct way to get the ID of the record =
you just added?


This isnt something I'm doing now, but its something I've often wondered =
if I do the right way, I'm fairly sure I dont.

Imagine you have a membership database, a user signs up and you add =
their info to your table which automatically assigns an ID to the =
record. You then need to add records to a 'link' table to associate =
(for example) the user with a particular mailing list/s. To do that you =
need the ID of the record you just added for the user. =20

In the past I've just done a select statement to pull out the highest ID =
number based on the assumtion that the highest ID will be the last =
record added - however if, on the rare occasion this might happen, =
another user signs up at the same time that ID will be wrong.

Whats the correct way of doing it? is there one?

--=20
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html