怎样使访问者离开的时候自动删除一条数据库记录!!---详情请进!解决就解!!!!!!!!!!!!!
我的global.asa是这样的!!
为什么进入网站的时候可以增加一条记录!
但是离开的的时候就是删除不了呢??????
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
sub Application_OnStart
dim zaixian,ip,time1,zaixian1
application("zaixian")=0
End sub
Sub Session_OnStart
session("ip")=request.servervariables("remote_addr")
session("time1")=now()
application.lock
application("zaixian")=application("zaixian")+1
application.unlock
session("id")=""
End Sub
Sub Session_OnEnd
application.lock
application("zaixian")=application("zaixian")-1
application.unlock
set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open "driver={microsoft access driver (*.mdb)};dbq="& server.mappath("login/login.mdb")
zaixian1="delete * from zaixian where time='"&session("time1")&"'"
set rs=conn.execute (zaixian1)
rs.close
session("id")=""
End sub
Sub Application_OnEnd
set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open "driver={microsoft access driver (*.mdb)};dbq="& server.mappath("login/login.mdb")
zaixian1="delete * from zaixian where time='"&session("time1")&"'"
set rs=conn.execute (zaixian1)
rs.update
rs.close
End sub
</SCRIPT>