or something.
when they login write their info to a db and then in the application.cfm
file have it update that db with the current time & then after the update
code do a delete code where it deletes every record thats over say 10
minutes old.
by doing that you dont have to rely on the sessions to get the info. Cause
u will have all there info there.
u know what i am sayin?
> 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]
