UBB.Developers Forums Community Development Programming PHP and Server-side Scripting One of you has to know...Global.asa

I have the following in my Global.asa file:


function Session_OnEnd ( )
{

DBInitConnection ( );
oConnection.Execute ( 'UPDATE Members SET Status='Offline' WHERE Email='' + sEmail + ''' );
DBReleaseConnection ( );
Application.Lock ( );
Application ( 'ActiveUsers' )--;
Application.Unlock ( );

}

The UPDATE SQL is not working? Anyone able to shine some light in this area or tell me the possible reasons a Global.asa file might not work.

Need and answer ASAP.

Not very experienced in Javascript.

Are you sure the SQL is correct?
I.E. Can you make a page to execute that and it'll work?
Is that sub actually being called?

Also remember that sessions are terminated after a user leaves the site for a length of time (don't remember now...)

Hi John

As far as I know the SQL is perfect. That sub/function is called when the user session times out, which is 20 minutes by default on my server. I believe it is also called when the session is abandoned.

Thanks for helping me.

Can anyone else do some troubleshooting?