ok for example, if you use the MM login behavior it sets a session as
MM_Username. So then on your query you just do something like
<cfquery name="foo" datasource="#dsn#">
SELECT *
FROM TABLE
WHERE username = #session.MM_Username#
</cfquery>
just substitute MM_Username with what session ur using:)
dave
> Eric,
>
> Assuming that Application.UsersInfo is a structure...
>
> <cfoutput>
> <cfloop list="#structKeyList(Application.UsersInfo, ',')#"
> index="myLoop">
> #myLoop# - #Application.UsersInfo[myLoop]#<br />
> </cfloop>
> </cfoutput>
>
> Steve
>
>
> -----Original Message-----
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2003 5:25 PM
> To: CF-Talk
> Subject: RE: How to count sessions
>
>
> How can I convert #StructCount(Application.UsersInfo)# into something
> that will make the Application.UsersInfo a simple value that I can then
> use for querying?
>
> -----Original Message-----
> From: Eric Creese
> Sent: Friday, November 07, 2003 4:13 PM
> To: CF-Talk
> Subject: RE: How to count sessions
>
> ok I did the tutorial and got what I wanted. Now here is a tough one.
> can I use the the session vars to to query my users table to display the
> users names?
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2003 3:55 PM
> To: CF-Talk
> Subject: RE: How to count sessions
>
> http://tutorial12.easycfm.com/ <http://tutorial12.easycfm.com/>
> copy & paste is your friend ;)
>
> put it in the Application.cfm page
>
>> where should I put this code?
>>
>> -----Original Message-----
>> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
>> Sent: Friday, November 07, 2003 3:18 PM
>> To: CF-Talk
>> Subject: RE: How to count sessions
>>
>>
>> wonderful... nice trick - very helpful.
>>
>> -Mark
>>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Friday, November 07, 2003 2:58 PM
>> To: CF-Talk
>> Subject: RE: How to count sessions
>>
>> actually there is...one way in CFMX is this quick stuff
>>
>> <cfapplication name="sessionLister" sessionManagement="yes">
>>
>> <cfset tracker = createObject("java",
>> "coldfusion.runtime.SessionTracker")> <cfset sessions =
>> tracker.getSessionCollection("myappname")>
>>
>> <cfdump var="#sessions#">
>>
>> Ray Camden has some other code for this...a flash app even...out on
>> his blog under
>> http://www.camdenfamily.com/morpheus/blog/
> <http://www.camdenfamily.com/morpheus/blog/>
>>
>> Doug
>>
>> -----Original Message-----
>> From: brob [mailto:[EMAIL PROTECTED]
>> Sent: Friday, November 07, 2003 3:56 PM
>> To: CF-Talk
>> Subject: Re: How to count sessions
>>
>> I dont think there's a server variable that counts the number of
>> unique sessions available. You can find out this way
>> though....First yo have an application variable like
>> application.counter, and then everytime a member logs in you increment
>> that counter by 1.
>>
>> Be sure to check for things like if they are already logged in and
>> are
>> just signing in again, to not increment the
>> counter. You can also avoid this problem by writing code on the login
>> page to forward them to their member page if their logging session
>> variable is TRUE. That way they dont have to put in their
>> username/password twice
>> ----- Original Message -----
>> From: Eric Creese
>> To: CF-Talk
>> Sent: Friday, November 07, 2003 2:22 PM
>> Subject: How to count sessions
>>
>> How can you count the number of active session are opened. For
>> instance I have a membership site and I want to get a
>> count of members who have logged in and have an open session.
>>
>> E
>>
>> _____
>>
>>
>> _____
>>
>>
>>
> _____
>
> _____
>
>
> _____
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
