Re: Creating a unique ID from a Query Insert for use in an Update

[Steve Kahn]

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]

---