Home All Groups Group Topic Archive Search About


Author
3 Mar 2005 7:15 PM
Marcin Zmyslowski
Hello all!

I want to create a page in ASP language which gives me information about
currently logged users. I thought to do it by this way: when somebody
will log in to page, there will be a value of this user id stored in the
table among the other fields in the form which are filling in. After
clicking on the button "Log off" the value of the user id will be
deleted from the MS SQL Server 2000 database. I would do it, but I don`t
know how to solve the problem when somebody will close the Internet
Explorer window by clicking "x". Then the procedure of deleting a value
of user id will not call, and this value will be still stored in the
database, so I will not have actual state of currently logged users.
Could you help me how to do it, and gives me example with solving this
problem? Maybe there is another possiblity to do it?

Thank you in advance for help
Marcin from Poland

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Author
3 Mar 2005 7:33 PM
Curt_C [MVP]
first off, do a google on this one. It's a flaw in thinking here. Remeber,
web is a request/response system Once the response is sent the user isnt
really "logged on". Now, sessions you can do some work with. Set a value,
flush it, etc.. that's the route I would go down if you need to get this
info. As for the problems you pointed out, the Global.asa and the session
events in there will help clean up the values but just keep in mind there is
NO 100% accurate way to do what you are after.

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com


Show quote
"Marcin Zmyslowski" <marc***@kapy.bydg.pl> wrote in message
news:e4s%23RVCIFHA.3612@TK2MSFTNGP09.phx.gbl...
> Hello all!
>
> I want to create a page in ASP language which gives me information about
> currently logged users. I thought to do it by this way: when somebody
> will log in to page, there will be a value of this user id stored in the
> table among the other fields in the form which are filling in. After
> clicking on the button "Log off" the value of the user id will be
> deleted from the MS SQL Server 2000 database. I would do it, but I don`t
> know how to solve the problem when somebody will close the Internet
> Explorer window by clicking "x". Then the procedure of deleting a value
> of user id will not call, and this value will be still stored in the
> database, so I will not have actual state of currently logged users.
> Could you help me how to do it, and gives me example with solving this
> problem? Maybe there is another possiblity to do it?
>
> Thank you in advance for help
> Marcin from Poland
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

AddThis Social Bookmark Button