you cannot merge two source columns in an update.
try this
SQLquery = "UPDATE users " &_
"SET [Ratings] = ('"&Session("rate")&"',
[DateTime]='"&Session("time")&"')" &" where user_name ='" & Session("name") & "'"
The output of SQLQuery should be
Update users set [ratings] ='0.66',
[datetime]='12/31/2004' where
[user_name]='MAK'




Reply With Quote