Newbi question. ASP , DB

[Tony]

Hello everyone.
Im learning ASP and DB desige, and doing this for the first time. so i
decided the best way to learn to start a project.
Currently im designing memeber site. where user can login and creat profile
and upload images ..etc.
I like to show User status on the page. whether user is Online or Offline.
the online part is easy, when user logs in , i think i can set a field in db
to Yes (Isonline) and quring the db each time other members want to see hows
online or not , but hard part to figure, is Offline part ..well, this is the
problme.....
Lets say memeber simply clost the browser or jumps to differnet website. how
can i set his/her status to Offline if they don't logoff from website
first.?
I was thinking to use session variable at all time so when user simplay
leaves the site .. session variable will terminate and set thier status to
offline.. but how can i accomplish this or is there better logical way to
achive this method?

thanks for your helps and input
Regards

[TomB]

You can use the Session_OnEnd to set your IsOnline field, in global.asa.
There are apparently problems with Session_OnEnd not firing.....

[url]www.aspfaq.com/2078[/url]


"Tony" <tonysar@nonospams.sympatico.ca> wrote in message
news:u7UN2OpqDHA.2488@TK2MSFTNGP12.phx.gbl...

> Hello everyone.
> Im learning ASP and DB desige, and doing this for the first time. so i
> decided the best way to learn to start a project.
> Currently im designing memeber site. where user can login and creat

profile

> and upload images ..etc.
> I like to show User status on the page. whether user is Online or Offline.
> the online part is easy, when user logs in , i think i can set a field in

db

> to Yes (Isonline) and quring the db each time other members want to see

hows

> online or not , but hard part to figure, is Offline part ..well, this is

the

> problme.....
> Lets say memeber simply clost the browser or jumps to differnet website.

how

> can i set his/her status to Offline if they don't logoff from website
> first.?
> I was thinking to use session variable at all time so when user simplay
> leaves the site .. session variable will terminate and set thier status to
> offline.. but how can i accomplish this or is there better logical way to
> achive this method?
>
> thanks for your helps and input
> Regards
>
>