注册 登录
编程论坛 ASP技术论坛

Microsoft JET Database Engine (0x80040E14) 错误

fengmnll 发布于 2010-05-19 09:24, 427 次点击
<!--#include file="conn.asp"-->
<% class_id=request.QueryString("class_id")
   sqll="delete from Class where class_id="&class_id&""
   response.Write sqll
   conn.execute(sqll)
  response.write "<script language=JavaScript>" & chr(13) & "alert('删除成功!');"&"window.location.href = 'edit_class.asp'"&"</script>"
%>  
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'class_id=' 中。
不知道是什么地方出错了?
2 回复
#2
gupiao1752010-05-19 10:09
1.
<!--#include file="conn.asp"-->
<% class_id=request.QueryString("class_id")
   response.write class_id '输出看看class_id是否有值!
   response.end
   sqll="delete from Class where class_id="&class_id&""
   response.Write sqll
   conn.execute(sqll)
  response.write "<script language=JavaScript>" & chr(13) & "alert('删除成功!');"&"window.location.href = 'edit_class.asp'"&"</script>"
%>
2.
   sqll="delete from Class where class_id="&class_id&""
关于上面这条SQL语句,请核对class_id在数据库里是什么字段,如果是数字字段,那请改为这样的SQL语句:
   sqll="delete from Class where class_id="&class_id


#3
fengmnll2010-05-19 12:14
回复 2楼 gupiao175
呵呵谢谢解决了
1