请您，帮我改一下！！！

[zhupuwei]

formname=request.form("name")
foremail=request.form("email")
forid=request.form("id")
fortime=request.form("time")

formname=replace(formname,"","")


sqltemp=" update liuyan set "
sqltemp=sqltemp & "姓名=" & formname & ","
sqltemp=sqltemp & "信箱=" & foremail & ","
sqltemp=sqltemp & "时间=" & fortime & "where id="&forid

set conn=server.createobject("adodb.connection")
conn.open connStr
conn.execute(sqltemp)

这段代码错在哪？？？
错误类型：
Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误

[TrueAndFalse]

sqltemp=" update liuyan set "
sqltemp=sqltemp & "姓名='" & formname & "',"
sqltemp=sqltemp & "信箱='" & foremail & "',"
sqltemp=sqltemp & "时间='" & fortime & "' where id="&forid

[zhupuwei]

谢谢！
但现在变成这样的了
错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'id=' 中。

[baiyunfei]

sqltemp=" update liuyan set "
sqltemp=sqltemp & "姓名='" & formname & "',"
sqltemp=sqltemp & "信箱='" & foremail & "',"
sqltemp=sqltemp & "时间='" & fortime & "' where id="&forid
注意下你的字段是何类型，时间如果是日期型，又是access数据库的话用
"时间=#"&fortime&"#..........
最好先response.write sqltemp 来看下语句

[zhupuwei]

现在对了，谢谢了！！！

[xzq686]

sqltemp="update liuyan set 姓名='"&formname&"',信箱='"&foremail&"',时间='"&fortime&"' where id='"&forid&"'"