求解 Microsoft JET Database Engine error '80040e14'

魔法师 · 发表于 2011-8-9 16:38:15

进后台显示这个
Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'id=<font face='.

/dywy/admin_lbl/other_management.asp, line 15

帮忙解决  谢谢

other_management.asp代码



<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link href="../css/wss.css" rel="stylesheet" type="text/css" />
</head>

<%
id =trim(request.QueryString("id"))

set rs=server.CreateObject("adodb.recordset")
sql="select  * from other where id="&id
rs.open sql,conn,3,3

submit =trim(request.form("submit"))

if submit="确认修改" then

content =trim(request.form("content"))
data =trim(request.form("data"))
smallcontent =trim(request.form("smallcontent"))

URL =Request.ServerVariables("Http_REFERER")

' 如果编辑的内容很多，上传速度太慢，请设置以下的时间，单位秒
Server.ScriptTimeout = 999999
'''''''''''''''''''''''''''''''''''''''''''''''
cate_name=rs("cate_name")

rs("content") =content
rs("data")    =data
rs("smallcontent") =smallcontent

rs.update
rs.close
set rs=nothing
Response.Write("<script>alert("""&cate_name&"修改成功！"");location.href=""other_management.asp?id="&id&""";</script>")
response.end

end if

%>

<body topmargin="0" leftmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
<td height="317" align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
   <form id="form1" name="form1" method="post" action="other_management.asp?id=<%=id%>" onSubmit="JavaScript:return check_Null();">
      <tr>
      <td width="346" height="25" colspan="2" align="left" background="images/01.gif" bgcolor="#069AAA" style="color:#FFFFFF">  ◆ 其他信息修改 --->  <%=rs("cate_name")%></td>
      </tr>
      <tr>
      <td height="73" colspan="2" valign="top"><table width="100%" border="0" cellspacing="1" cellpadding="0">
         <tr>
            <td width="13%" height="25" align="right" bgcolor="#E3EDF4">标题：  </td>
            <td bgcolor="#EFEFEF">  <strong><%=rs("left_name")%></strong></td>
            </tr>
         <tr>
            <td height="25" align="right" bgcolor="#E3EDF4">首页显示部分： </td>
            <td bgcolor="#EFEFEF"><label>  
               <textarea name="smallcontent" cols="50" rows="5" id="smallcontent"><%=rs("smallcontent")%></textarea>
            </label></td>
         </tr>
         <tr>
            <td height="25" align="right" bgcolor="#E3EDF4">发布时间： </td>
            <td bgcolor="#EFEFEF"><label>  
            <input name="data" type="text" id="data" value="<%=rs("data")%>" size="30" maxlength="40">
            </label></td>
            </tr>
         <tr>
            <td height="407" align="right" bgcolor="#E3EDF4">企业简介： </td>
            <td bgcolor="#EFEFEF">

   <label>
   <textarea name="content" cols="70" rows="20" id="content" style="display:none"><%=rs("content")%></textarea>
            </label>
            <IFRAME ID="eWebEditor1" src="eWebEditor\ewebeditor.asp?id=content&style=s_light" frameborder="0" scrolling="no" width="100%" height="100%"></IFRAME></td>
         </tr>
      </table></td>
      </tr>
      <tr>
      <td height="28" colspan="2" align="center" valign="middle" bgcolor="#CCCCCC"><label>
      <input type="submit" name="Submit" value="确认修改" />
      </label></td>
      </tr>
   </form>
</table></td>
  </tr>
</table>
</body>
</html>
<Script Language="JavaScript">

</script>

lwbo1987 · 发表于 2011-8-9 16:43:52

是不是access数据库，楼主的主机类型是4GH的吗？

魔法师 · 发表于 2011-8-9 16:53:24

access数据库 win 150G的

lwbo1987 · 发表于 2011-8-9 17:02:35

是4GH的还是shared，这个可能和数据库有关系，需要联系客服

[提问] 求解 Microsoft JET Database Engine error '80040e14'

回复 2# 的帖子

回复 3# 的帖子

浏览过的版块

GoDaddy讨论