I'd just append the info to a logfile. If a user logs in then log it. If a user logs out then log it. If a user doesn't log out then the system will timeout their session eventually, though this won't be logged. You can count the number of forced logouts by counting the number of logins without corresponding logouts in the log file - should you so wish.
> -----Original Message----- > From: Snake [mailto:snake@;snakepit.net] > Sent: 06 November 2002 16:46 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Online Users > > > So u know when people login and logout, I do that too. > > -----Original Message----- > From: Steve Martin [mailto:steve.martin@;sequence.co.uk] > Sent: 06 November 2002 16:44 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Online Users > > > I just store login information in the session scope which > takes care of > flushing itself when the timeout is reached. Why specifically are you > storing such information in a db? > > > -----Original Message----- > > From: Robertson-Ravo, Neil (REC) > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > Sent: 06 November 2002 16:31 > > To: '[EMAIL PROTECTED]' > > Subject: [ cf-dev ] Online Users > > > > > > This is a no brainer and I must be having a brain fart.... > > > > We have an online table which holds records for each user > > logged onto the > > system after login. > > These rows have a date logged on etc, and indeed this works > > well when the > > user signs off as expected (as this removes the rows in question) > > > > however, what process do you guys have in place when a user > > does NOT sign > > off and simply closes the browser and does not return for a few days > > later...? > > > > It means that they remain 'online' in the DB...... > > > > What do you guys have in place... any ideas? > > > > Neil > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] For > human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
