Global.asa
Hvorfor virker ddet ikke?<script language=\"vbscript\" runat=\"server\">
Sub Session_OnStart
session.timeout = 1
End Sub
Sub Session_OnEnd
DatabaseFile=\"C:\\HP\\Chat.Mdb\"
Const adOpenKeyset = 1
Const adLockOptimistic = 3
rst.Open \"Select * From Messages\", \"DRIVER=Microsoft Access Driver (*.mdb); DBQ=\" & Databasefile & \";\",adOpenKeyset,adLockOptimistic
rst.AddNew
rst(\"Message\")=\"<I>\" & Session(\"UserName\") & \" har forladt \" & GetRoom(Session(\"UserName\"))
rst(\"Time\")=Date & \"-\" & Time
rst.update
rst.close
set rst=Nothing
Set rst = Server.CreateObject(\"ADODB.recordset\")
rst.Open \"Select * From Users Where \'UserName\'=\'\" & Session(\"UserName\") & \"\'\", \"DRIVER=Microsoft Access Driver (*.mdb); DBQ=\" & Databasefile & \";\",adOpenKeyset,adLockOptimistic
rst(\"Room\")=\"\"
rst.update
rst.close
set rst=Nothing
end sub
</script>
