为什么我一加上这个money就会出错
if Rs( "IsTopic ")=1 then Conn.execute( "update [BBSXP_Threads] set money= ' "&money& " ', Topic= ' "&Subject& " ' where ID= "&Rs( "ThreadID ")& " ")

只要我把money= ' "&money& " '这个加上来就会出现以下错误，如何解决

Microsoft JET Database Engine 错误 '80040e14 '

UPDATE 语句的语法错误。


[解决办法]
money的字段类型是什么?

先把
sqlStr = "update [BBSXP_Threads] set money= ' "&money& " ', Topic= ' "&Subject& " ' where ID= "&Rs( "ThreadID ")& " "

Response.Write sqlStr

把结果拿出看看
[解决办法]
set [money]= " & money & "