Updating records in the table

[OtarBoy]

Currently i have a table called users. I wish to allow users to submit their ratings and together with the timestamp. Initially, it works with just submitting the rating alone. However when i try to submit the rating and the timestamp together, the system returns syntax error in the UPDATE statement. Can anyone help me take a look?

<%
Rate=Request.QueryString("Rating")
Session("rate")=Rate
Session("time")=Now()
Response.write(Session("time"))

SQLquery = "UPDATE users " &_
"SET (Ratings,DateTime) = ('"&Session("rate")&"','"&Session("time")&"')" &_
"where user_name ='" & Session("name") & "'"

conn.Execute(SQLquery)
%>

[MAK]

http://forums.databasejournal.com/sh...threadid=34992