Delete user from DB using Global.asa
Posted on 2001-08-23
I got a DB that containd the online visitors of the site.
I am trying to delete a visitor from the DB, after he closes his browser.
I recognize the user by his IP.
Here is the code:
Application("ActiveUsers") = Application("ActiveUsers") - 1
SQL="DELETE * From Online Where IP='"&Request.ServerVariables("REMOTE_ADDR")&"'"
I can see that the count of Application("ActiveUsers") is really -1.
But, the records are not being deleted from the DB.
Am I doing something wrong?
Thanks in advance for your help.
Best Regards, Tamar.