Depending on what you are doing...
inside a stored procedure you can do this
//////////////
Insert Into Table (ColumnList) Values(Values)
Select @@Identity as NewID
/////////////
HTH
Clint
---------- Original Message ----------------------------------
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 15 May 2001 16:41:57 +0100
Can anyone please remind me how i get the value of a record
which was just inserted into a sql database. I know its called @@identidy.
I had a snippet but i cant find it,Thanks
KOla
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
