Question

语法错误 (操作符丢失) 在查询表达式 'userid in ()' 中。 /Manage/saveuser.asp, 第 36 行。

<!--#include file="conn.asp"-->
<!--#include file="../md5.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.reload('login.asp')</script>"
response.End
else
if session("flag")>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
end if
dim userid,action
action=request.QueryString("action")
userid=request.QueryString("id")
if userid="" then userid=request("userid")
select case action
case "save"
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from [user] where userid="&userid,conn,1,3
if trim(request("userpassword"))<>"" then rs("userpassword")=md5(trim(request("userpassword")))
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("useremail")=trim(request("useremail"))
rs("quesion")=trim(request("quesion"))
if trim(request("answer"))<>"" then rs("answer")=md5(trim(request("answer")))
rs("shousex")=request("usersex")
rs("shengshi")=trim(request("shengshi"))
rs("shouhuodizhi")=trim(request("shouhuodizhi"))
rs("youbian")=trim(request("youbian"))
rs("usertel")=trim(request("usertel"))
rs("vip")=trim(request("vip"))
rs.Update
rs.Close
set rs=nothing
response.Write "<script language=javascript>alert('操作成功!');window.location.reload('manageuser.asp')</script>"
case "del"
conn.execute "delete from [user] where userid in ("&userid&") "
conn.execute "delete from shop_action where userid in ("&userid&")"
response.Redirect "manageuser.asp"
end select
%>

Answer 1

case "del"
conn.execute "delete from [user] where userid in ("&userid&") "
conn.execute "delete from shop_action where userid in ("&userid&")"
response.Redirect "manageuser.asp"

我想报错的原因在于你的userid的值为空，所以才会报错
case "del"
response.Write(userid)
response.End()
conn.execute "delete from [user] where userid in ("&userid&") "
conn.execute "delete from shop_action where userid in ("&userid&")"
response.Redirect "manageuser.asp"

这里写了输出userid的值 ，之后结束操作，你运行页面，看userid是否有值的。

追问

运行了后是空白的页面。能加你Q吗？

追答

当然可以，你运行出来页面为空，则说明你传的值 userid 是一个空值，没有值 ，你想SQL则为：delete from [user] where userid in () ，这个语句当然为错误的，所以页面才报错的。
如果你还不清除，可以在线联系我Q：1606083272

Answer 2

conn.execute "delete from [user] where userid in ("&userid&") "
conn.execute "delete from shop_action where userid in ("&userid&")"

这两句，如果是接收到单个id就不要用 in 表达式
(可以改为 delete from [user] where userid=ID )
多个id可以考虑用循环删除