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