ASP
批量修改时的问题急。。。
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区<%
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
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
...全文
