Why not write a marker client variable then search for it in your data? e.g.
<cfset Client.Application="MyApp"> Then... SELECT CGLOBAL.lvisit, CDATA.data FROM CGLOBAL INNER JOIN CDATA ON CGLOBAL.cfid = CDATA.cfid WHERE (((CDATA.data) Like '%Application=MyApp%')); (Note, I was trying this in Access, not SQL Server). ----- Original Message ----- From: "Kevin Langevin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 10:09 PM Subject: RE: Keeping track of logged-in users... > Thanks for the suggestions, all. > > I checked the article in CFDJ, and it looked like it might cover what I was > looking for, but DOH! I don't have a current subscription. I've been > meaning to re-up, but haven't gotten around to it, and the article teaser is > available, but the article itselsf is only available to members. :( > > Ah well... If anyone with a subscription can summarize for me what the > author did to accomplish this task, I'd be mighty grateful. > > I wish I could use the Application variable or even a login-triggered db > field increment, but unfortunately, as others pointed out, there's nothing > to trigger the decrement when someone times out. :( > > Unless someone knows how to query the client DB based on an application name > and a client variable name, then I think I'm going to have to keep the user > table updated with the most recent lastAccess. It'll do, I think, I was > just hoping for a solution that could be accomplished without the extra > update on every application.cfm execution. > > Thanks again... > > > Kevin Langevin > Flying Chimp Media > 954-585-0999 > [EMAIL PROTECTED] > http://www.FlyingChimp.com > > > -----Original Message----- > > From: Stephen Moretti [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 23, 2002 5:31 AM > > To: CF-Talk > > Subject: Re: Keeping track of logged-in users... > > > > > > > Hmmm... > > > > > > A quick suggestion/solution could be that when someone logs on, you can > > > insert a value (or incremente) into a structure and then count the > > > length of that structure - this will give you who is currently logged > > > on. Thoereitically this is how it could be done one way. > > > > > > > There is an article in the CFDJ archive all about this.... > > > > "Live Monitoring of User Sessions" > > http://www.sys-con.com/coldfusion/articlea.cfm?id=136 > > > > > > ;o) > > > > Regards > > > > Stephen > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
