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 & ""
but it show error. Error is Incorrect syntax near '10'
How can reslove my problem.
pls suggest me...