Re: Tracking users when browser is closing
From: Alex Kail (kail3_at_hotmail.com)
Date: 07/28/04
- Next message: Bjorn: "submitting two forms in same page?"
- Previous message: dmiller23462: "Re: ASP Date/Time Variables"
- In reply to: hawkon: "Tracking users when browser is closing"
- Next in thread: Lord Merlin: "Re: Tracking users when browser is closing"
- Reply: Lord Merlin: "Re: Tracking users when browser is closing"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 11:22:24 -0700
I just finished up a feature like this on my community website. My
solution was to use an IFrame with an ASP page that I called
WhosOnline.asp. This is a self refreshing page that refreshes every 30
seconds.
The page executes a stored procedure on SQL Server that modifies and
reads a table called WHOS_ONLINE_T. This table only has two fields
(member_id and date_visited). Basically what the procedure does is
deletes any records in which the date visited is older than 35 seconds,
plugs in the members id and date visited (or updates the record if the
member is already present in the table with the current date/time). Then
the proc returns all records from the table.
It works beautifully and as a result the data in the table is only 30
seconds stale at most. Not bad for given that we are in a stateless
environment.
If you are interested, email me and I can give you the specs. It tooke
me less than an hour to completely code.
Alex Kail
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Bjorn: "submitting two forms in same page?"
- Previous message: dmiller23462: "Re: ASP Date/Time Variables"
- In reply to: hawkon: "Tracking users when browser is closing"
- Next in thread: Lord Merlin: "Re: Tracking users when browser is closing"
- Reply: Lord Merlin: "Re: Tracking users when browser is closing"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
