Question

语法错误 (操作符丢失) 在查询表达式 'USER_ID=' 中

错子哪里？
<!--#include file="../../includes/ADOVBS.inc"-->
<!--#include file="../../includes/conn_access.asp"-->
<%
dim delesql
dim useridtxt
dim pagetxt
useridtxt = Request("userid")

Microsoft JET Database Engine 错误 '80040e14'

语法错误 (操作符丢失) 在查询表达式 'USER_ID=' 中。

/lunwen/BBS2/admin/user_del.asp，行 11

pagetxt = Request("cpage")
openDB
delesql="DELETE FROM UserInfo WHERE USER_ID=" & useridtxt
conn.Execute delesql
set conn=nothing
response.redirect "User_list.asp?page=" & pagetxt
%>

Answer 1

一般情况下是useridtxt
也就是request("userid")值为空了
为了防止出错，你可以先判断一下，
if trim(useridtxt)="" then
response.write("<script language='javascript'>")
response.write("alert("没有USERID值");")
'在此你可以设置返回上页
response.write("window.history.back();")
response.write("</script>")
response.end()
end if

Answer 2

<%
On error resume next
dim delesql
dim useridtxt
dim pagetxt
useridtxt = clng(Request("userid"))
pagetxt = clng(Request("cpage"))
openDB
delesql="DELETE FROM UserInfo WHERE USER_ID=" & useridtxt
if err then
response.write "发生错误,当前userid为:"+request("userid")
response.end
else
conn.Execute delesql
set conn=nothing
response.redirect "User_list.asp?page=" & pagetxt
end if
%>

如果报错为clng整形错误,说明request("userid")的值为空或不为数字,将request("userid")的值,response.write出来看看到底是什么

Answer 3

地址栏传参错误，没有获取到ID