<cfquery>
SET NOCOUNT ON
INSERT INTO users (firstname)
VALUES ('george')
SELECT @@Identity AS userId
SET NOCOUNT OFF
</cfquery>
-joe
----- Original Message -----
From: Daniel Farmer <[EMAIL PROTECTED]>
Date: Mon, 26 Jul 2004 11:00:00 -0400
Subject: grabbing the id of an item just entered into DB
To: CF-Talk <[EMAIL PROTECTED]>
Hi gang.... I remember hearing something a while back where someone wanted
to grab the id of an item they just entered into the database.... all in one
sql statement.
Does anyone remember the sql for that?________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
