asp控制登录的问题
来源:百度知道 编辑:UC知道 时间:2024/06/03 00:32:12
<script LANGUAGE="VBScript" RUNAT="Server">
Sub Application_OnStart
application("online")=0
set application("conn")=Server.CreateObject("ADODB.Connection")
End Sub
sub Application_OnEnd
set application("conn")=nothing
End Sub
Sub Session_OnStart
End Sub
Sub Session_OnEnd
if Session("user_id")="" then
application.lock
application("online")=application("online")-1
application("conn").Execute ("update tbluser set online=0 where user_id="&session("user_id"))
application.unlock
application("conn").close
end if
End Sub
</script>
大家帮我看看这段写在GLOBAI.ASA里的代码哪里有错误啊?
谢谢!
Sub Application_OnStart
application("online")=0
set application("conn")=Server.CreateObject("ADODB.Connection")
End Sub
sub Application_OnEnd
set application("conn")=nothing
End Sub
Sub Session_OnStart
End Sub
Sub Session_OnEnd
if Session("user_id")="" then
application.lock
application("online")=application("online")-1
application("conn").Execute ("update tbluser set online=0 where user_id="&session("user_id"))
application.unlock
application("conn").close
end if
End Sub
</script>
大家帮我看看这段写在GLOBAI.ASA里的代码哪里有错误啊?
谢谢!
改为
<script LANGUAGE="VBScript" RUNAT="Server">
Sub Application_OnStart
application("online")=0
set application("conn")=Server.CreateObject("ADODB.Connection")
End Sub
sub Application_OnEnd
set application("conn")=nothing
End Sub
Sub Session_OnStart
End Sub
Sub Session_OnEnd
if Session("user_id")="" then
application.lock
application("online")=application("online")-1
application("conn").Execute ("update tbluser set online=0 where user_id="&session("user_id")&"")
application.unlock
application("conn").close
end if
End Sub
</script>