诗篇68篇默想与祷告:请帮忙看看怎么错了?老不能删除

来源:百度文库 编辑:神马品牌网 时间:2024/05/07 01:27:41
请问str_id=split(request("msgId"),",")
wcd=""
if userid="VIP会员申请" then
table1="userinfo"
elseif userid="应聘申请" then
table1="ypb"
elseif userid="加盟申请" then
table1="add_table"
elseif userid="媒体申请" then
table1="media"
end if
for i=0 to ubound(str_id)
cmd_dele="delete from ["&table1&"] where id="&str_id(i)&""
conn.execute(cmd_dele)
next

错误类型:
Microsoft JET Database Engine (0x80040E14)
FROM 子句语法错误。
/1212/deletemessage.asp, 第 18 行

POST Data:
msgId=2&boxType=2&page=1&orderField=4&orderType=2
错误

access库?
cmd_dele="delete * from ["&table1&"] where id="&str_id(i)

sqlserver库?
cmd_dele="delete from ["&table1&"] where id="&str_id(i)

把你的sql语句考至查询分析器里执行即可