Webmaster Forum / ColdFusion / Advanced Techniques / January 2006

Im not tracking the users in the same way, I'm using this:

<cflock TIMEOUT="15" SCOPE="APPLICATION" TYPE="EXCLUSIVE">
    <cfif NOT isDefined("Application.UsersInfo")>
          <cfset Application.UsersInfo = StructNew()>
    </cfif>
</cflock>

<cflock NAME="#CreateUUID()#" TIMEOUT="15" TYPE="EXCLUSIVE">
      <cfset user_cfid = #getauthuser()#>
      <cfset user_time = Now()>
</cflock>

<cflock SCOPE="APPLICATION" TYPE="EXCLUSIVE" TIMEOUT="15">
 <cfif NOT StructKeyExists(Application.UsersInfo, user_cfid)>
  <cfset temp = StructInsert(Application.UsersInfo, user_cfid, user_time)>
 </cfif>
</cflock>

<cflock SCOPE="APPLICATION" TYPE="EXCLUSIVE" TIMEOUT="15">
 <cfloop COLLECTION="#Application.UsersInfo#" ITEM="itmUser">
  <cfif Evaluate(DateDiff("n", StructFind(Application.UsersInfo, itmUser),
Now())) GT 10>
    <cfset StructDelete(Application.UsersInfo, itmUser)>
  </cfif>
 </cfloop>
</cflock>

I just need to know, how in the <CFQUERY> I would check to see if the
member_id was listed in the structure.

Thanks in advance

Why not just something like this within you <cflock>:
<cfquery name="getonlineuser" datasource="x">
SELECT userid
FROM users
WHERE username='#Application.UsersInfo.user_cfid#'
</cfquery>