金时利文件夹:Microsoft JET Database Engine (0x80040E14)是什么错误

来源:百度文库 编辑:高校问答 时间:2024/04/29 07:15:51
程序代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn.asp" -->
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers="superadmin"
MM_authFailedURL="login.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL")
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
%>
<%

if(Request.QueryString("id") <> "") then cmd__did = Request.QueryString("id")

%>
<%

set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = MM_conn_STRING
cmd.CommandText = "DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
cmd.CommandType = 1
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.Execute()

%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>留言删除成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="refresh" content="3;URL=admin.asp">
</head>
<body>
<table width="650" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" class="thin">
<tr>
<td height="35" align="center" back ground="images/topbg.gif">留言板</td>
</tr>
<tr>
<td height="20" align="right" back ground="images/bmbg.gif">『<a href="insert.asp">留言</a>』  『<a href="index.asp">查看</a>』  『<a href="login.asp">管理</a>』</td>
</tr>
<tr>
<td align="center">记录删除成功,3秒后返回<a href="admin.asp">管理页面</a></td>
</tr>
<tr>
<td height="20" align="center" back ground="images/bbg.gif">版权所有人</td>
</tr>
</table>

</body>
</html>

出现的问题:
无法显示网页
试图访问的网页出现问题,无法显示。

--------------------------------------------------------------------------------

请尝试执行下列操作:

单击刷新按钮,或稍后重试。

打开 127.0.0.1 主页,然后查找与所需信息相关的链接。
HTTP 错误 500.100 - 内部服务器错误 - ASP 错误
Internet 信息服务

--------------------------------------------------------------------------------

技术信息(用于支持人员)

错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'ID=' 中。
/guestbook/login.asp, 第 16 行

浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; 56flvplayer 1.0)

网页:
GET /guestbook/login.asp

时间:
2006年5月23日, 9:59:48

详细信息:
Microsoft 支持

<%

if(Request.QueryString("id") <> "") then c
md__did = Request.QueryString("id")

%>
<%

set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = MM_conn_STRING
cmd.CommandText = "DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
cmd.CommandType = 1
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.Execute()
else
response.write "对不起ID值取不到"
response.end
end if
%>

变量的值为空(或缺少关键字) ,请仔细查看源代码

"DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
中,cmd__did中无内容,请核查