2. Do you have a field in TrackUsers that is set as the Identity field?
3. Try setting NoCount OFF
-----Original Message-----
From: Steve Kahn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 12:28 PM
To: CF-Talk
Subject: Re: Creating a unique ID from a Query Insert for use in an Update
Code didnt pass the ID, fields came up with <NULL> - what was missed?
<CFQUERY NAME="login">
SELECT *
FROM users
Where username = '#username#' and pwd = '#pwd#'
</cfquery>
<cfset passed="indexblog.cfm">
<cfset failed="failed.cfm">
<cfset login_datetime = createODBCDateTime(now())>
<cfoutput query="login">
<cfif login.logincount is not "0">
<cfquery name="qryName" >
SET nocount on
INSERT INTO trackusers (username,pwd)
VALUES('#username#','#pwd#')
SELECT @@identity as myID
SET nocount on
</cfquery>
<!--- set key --->
<cfset key = qryName.myID />
<!--- now do update --->
<cfquery >
UPDATE trackusers
SET Logindate=#login_datetime#, IP='#remote_addr#',
browser='#http_user_agent#', remote_host='#remote_host#',
remote_referer='#http_referer#'
WHERE userID = #key#
</cfquery>
<cflocation url="" addtoken="No">
<cfelse>
<cflocation url="" addtoken="No">
</cfif>
<cfif login.recordcount is "0">
<cflocation url="" addtoken="No">
<cfelse>
</cfif>
</cfoutput>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
