asp页面用update不能更新多个字段

question=trim(request("question.value"))
qita=trim(request("qita"))
answer=trim(request("answer"))


sql="update [zbld_user] set QUESTION='"&question&"',"&"answer='"&answer&"' where GRBH='"&session("GRBH")&"'"
set rs=conn.execute(sql)
set rs=nothing


每次只更新answer的内容不更新question这是为什么
answer、question都是varchar(50）
单独在数据库中更新可以

---

question answer GRBH的字段类型都是文本的话，字段值的两边加单引号，如果某个字段是数字类型的话，字段值的两边不要加单引号。
另外直接conn.execute即可，不需要rs了.
VBScript code:

<%
question = trim(request("question.value"))
qita = trim(request("qita"))
answer = trim(request("answer"))
question = Replace(question, "'", "''")
answer= Replace(answer, "'", "''")

sql="UPDATE [zbld_user] SET [question]='" & question & "', [answer]='" & answer & "' WHERE [GRBH]='" & session("GRBH") & "'"
conn.Execute sql
conn.Close
Set conn = Nothing
%>