|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Delete |
|
From: |
Ranjith |
|
Date: |
11/4/1999 6:56:14 AM |
|
IP: |
203.94.224.6 |
hi,
I want to delete a record from the table when a user closes his browser,I have written the script for this on the Session_OnEnd,but its not working,any help would be appreciated.
My code goes like this:
SUB Session_OnEnd
set connect = server.CreateObject ("ADODB.connection")
connect.Open "DSN=xxx;UID=xx;PWD=xxxx;"
set rs = server.CreateObject ("ADODB.recordset")
rs.Open str, connect
str = "delete from login where user_id =1"
connect.execute (str)
rs.Close
set rs = nothing
connect.Close
set connect = nothing
end if
END SUB
Thanks
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
