I'm using asp and sql server, i hava also used vb script and java script . i have to time field type call login and logout.i want to findout logout time.i can disply already login time and i can used now() function and insert into the database. but in logout time ,i can used same function now().when i saw in database it disply login time not logout time.i also used query in sql server.


q= "update LoginHistory set LoginHistoryOutTime= #" & now() & "# where LoginHistorySessionID=" & Session.SessionID & ""
Response.Write q
Set rs=con.Execute(q)

but it show error. Error is Incorrect syntax near '10'


How can reslove my problem.
pls suggest me...

thank

Hii dayarprasad!!

You can handle your logout event ,on global.asa file or any other like "logout.asp" file.
but ensure that in session.abandon page you can access session variables and you can use your logout sql to execute.
Don't always rely on session_onEnd event handler(in global.asa) file,session default timeout is 20 mints,if user do not perform any activity for 20 mints,it will be fire,even if user has no intention to logout.Also if user closes the browser for say in x mint,the session_onEnd event will fire after approx.(x+20) mint.
for more details http://p2p.wrox.com/topic.asp?TOPIC_ID=1774
hope this will help you

Cheers :)

vinod