RE: How to count sessions

[Eric Creese]

Here is what I have now. Everything is working fine except I can not get all the individual sessions to loop through the query. It only returns data for one record, even if I have 4 sessions opened by different users.


<cfset tracker = createObject("java", "coldfusion.runtime.SessionTracker")>

<cfset sessions = tracker.getSessionCollection("MyAppName")>


<!--- Test to see how data is returned --->
<cfloop collection="#sessions#" item="key">
    <cfoutput>#sessions["#key#"].user#</cfoutput>
</cfloop>

<cfloop collection="#sessions#" item="key" >
<cfquery name="getmem" datasource ="xxx">
  SELECT fname,lname,class_year
  FROM alumni
  WHERE username in( '#sessions["#key#"].user#')
</cfquery>
</cfloop>


<table>
<cfoutput query="getmem">
<tr><td>#fname#</td><td>#lname#</td><td>#class_year#</td></tr>
</cfoutput>
</table>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---