批量修改时的问题急。。。

[hrxnoise]

<%

dim nid,name,money,time,i
if request("action")="update" then
for i=1 to request.form("nid").count


nid=replace(request.form("nid")(i),"'","")

name=replace(request.form("name")(i),"'","")
money=replace(request.form("money")(i),"'","")


conn.execute("update ap set name='"&name&"',money='&money&' where nid="&nid)

next
conn.close
set conn=nothing
response.write "<script language=javascript>alert('修改成功！');window.location.href='javascript:history.go(-1)';</script>"
end if
%>



会出现以下错误


错误类型：
Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误。
/112/jgpl.asp, 第 15 行


浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

网页：
POST 195 ??? /112/jgpl.asp

POST Data:
nid=1&name=gdfgdf&money=33&nid=2&name=gdfgdfg&money=22&nid=3&name=dfgdf&money=222&nid=4&name=viee&money=11&nid=5&name=0gfdgfd&money=11&nid=6&name=0gfdgdf&money=11&Submit2=%B1%A3%B4%E6%D0%DE%B8%C4

[caixinke]

conn.execute("update ap set name='"&name&"',money='&CSTR(money)&' where nid="&nid)

[rehearts]

conn.execute("update ap set name='"&name&"',money='"&money&"' where nid="&nid)

[webDreamsinger]

根据post过来的值假定noney字段类型为数字。

conn.execute("update ap set name='"&name&"', money="&money&" where nid="&nid)

若为字符则：
conn.execute("update ap set name='"&name&"', money='"&money&"' where nid="&nid)

[YISUKU_LEE]

response.write

response.end（）

把SQL打出来看一下估计是你的字符串拼装错了~~