UC知道语法错误 (操作符丢失) 在查询表达式 'SMSJ_jg set del=0 where id = (1)' 中。
来源：百度知道 编辑：UC知道 时间：2024/06/23 01:11:58
<%if request("Submit")="删 除" then
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
conn.execute("delete from SMSJ_jg set del=0 where id="&id(i))
next
elseif request("Submit")="审 核" then
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
conn.execute("update SMSJ_jg set sh=1 where id="&id(i))
next
end if就下面那段出错!!!
if request("action")="del" then
conn.execute("delete SMSJ_jg set del=0 where id = ("&request("id")&")")
response.write("<script>alert(""删除成功！"");location.href=""jg.asp"";</script>")
Response.end
end if
if request("action")="sh" then
conn.execute("update SMSJ_jg s
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
conn.execute("delete from SMSJ_jg set del=0 where id="&id(i))
next
elseif request("Submit")="审 核" then
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
conn.execute("update SMSJ_jg set sh=1 where id="&id(i))
next
end if就下面那段出错!!!
if request("action")="del" then
conn.execute("delete SMSJ_jg set del=0 where id = ("&request("id")&")")
response.write("<script>alert(""删除成功！"");location.href=""jg.asp"";</script>")
Response.end
end if
if request("action")="sh" then
conn.execute("update SMSJ_jg s
end if就下面那段出错!!!
if request("action")="del" then
conn.execute("delete SMSJ_jg set del=0 where id = ("&request("id")&")")
response.write("<script>alert(""删除成功！"");location.href=""jg.asp"";</script>")
Response.end
end if
'使用下面语句替换Set是更新语句使用.
'使用FROM指定操作表名
Conn.execute("Delete from [SMSJ_jg] where id="&Request("id")&"")