Andy
-----Original Message-----
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 11:14 AM
To: CF-Talk
Subject: Re: Creating a unique ID from a Query Insert for use in an Update
> <cfquery>
> set nocount on
> Insert into trackusers(username,pwd)
> values(#username#,#pwd#);
> Select scope_identity() as myID
> Set nocount on
> </cfquery>
SET NOCOUNT OFF actually...
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
