returning an inserted SQL record

[JoeyTMann]

Found my answer...

Select max(column) as ID
from table

[paross1]

You need to be real careful with this method, especially if you have a busy
site, as you may "grab" the wrong ID if another user happens to perform an
insert at the same time. One way that you can manage this is by using
CFTRANSACTION to include the insert and select within the same transaction.

Phil

[BigDMorris]

Actually, here's the right way to do it in SQL Server without requiring another
database read and the possibility of another user slipping in and giving you
the wrong ID. This is the official way of doing it. It took me years to find
this, but it works every time: <CFQUERY NAME='LastValue' etc.> SET Nocount
ON; INSERT INTO MyTable (blahblah) VALUES(blahblah); SELECT
@@IDENTITY AS LastID; SET Nocount OFF; </CFQUERY> <!--Identity:
#LastValue.LastID#--> Dave Morris