I suppose the tables CDATA and CGLOBAL will hold the data even if the user logs out from the site
You will have to put a condition on lvisit for 20 min But even in that case, if the user logs out for eg at 12:00 , he will appear online till 12:20 > -----Original Message----- > From: Matthew Walker [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 23, 2002 4:47 PM > To: CF-Talk > Subject: Re: Keeping track of logged-in users... > > 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 > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
