Home >
front end > Please help!!!!! When running the Microsoft JET Database Engine error 80040 e14 FROM clause grammar
Please help!!!!! When running the Microsoft JET Database Engine error 80040 e14 FROM clause grammar
<% @ LANGUAGE="VBSCRIPT" CODEPAGE="936" % & gt;
<%
If (Request (" news_ID ") & lt;> "") then Command1__mynews_ID=Request (" news_ID")
%>
<%
Mand set Command1=Server. CreateObject (" ADODB.Com ")
Command1. ActiveConnection=MM_mynews_STRING
Command1.Com mandText="DELETE FROM the WHERE news_ID=" + Replace (Command1__mynews_ID, "'", "" '") +"
"Command1.Com mandType=1
Command1.Com mandTimeout=0
Command1. Prepared=true
Command1. The Execute ()
%>
<meta HTTP - equiv="content-type" Content="text/HTML. Charset=gb2312 "& gt;
No title documents & lt;/title> <br/><style type="text/CSS" & gt; <br/><! - <br/>. Style1 {<br/>The font - size: xx - large; <br/>font-weight: bold; <br/>} <br/>--> <br/></style> <br/><br/></head> <br/><br/><body> <br/><Div align="center" & gt; <br/><P & gt; Deleted successfully! <br/></p> <br/><P & gt; <A href="https://bbs.csdn.net/topics/news_edit.asp" & gt; Continue & lt;/a> <A href="https://bbs.csdn.net/topics/news_list.asp" & gt; Exit & lt;/a> </p> <br/></div> <br/></body> <br/></html> <img SRC="https://img.codepudding.com/202009/74561160338471.png" Alt=""/> <br/>Why is code as above, as shown in figure mistakes? <br/><p class="article - content rp"> CodePudding user response: </p>The delete from/table? The where...<p class="article - content rp"> CodePudding user response: </p>There is no database table name! </div>
<div class="th_page th_page_color"></div>
<div class="umCopyright">
<p>Page link：<a href="/frontend/2012.html" target="_blank" style="color:#999">https//www.codepudding.com/frontend/2012.html</a></p>
</div>
<div class="detail-arr">
<div class="detail-arr-left">Prev:<a href='/frontend/2011.html'>Two identical double-precision decimal subtraction is not equal to zero</a></div>
<div class="detail-arr-right">Next:<a href='/frontend/2013.html'>O! Text cyclic display code, not rolling cycle.</a></div>
</div>
</div>
</div>
</div>
</div>
<div class="container th_top">
<div class="row">
<div class="col-md-12">
<div class="hot-tags neitags">
<ul>
<li><i class="iconfont icon-x-tags"></i> Tags： </li>
<a href='/e/tags/?tagname=ASP' target='_blank'>ASP</a> </ul>
</div>
</div>
</div>
</div>
<div class="container th_top">
<div class="row">
<div class="col-md-12">
<div class="xiangguan">
<ul class="msg msghead">
<li class="tbname">Related</li>
</ul>
<ul> </ul>
</div>
</div>
</div>
</div>
<div class="container th_top">
<div class="row">
<div class="col-md-12">
<div class="flinks">
<ul>
<li><i class="iconfont icon-x-tags"></i> Links： </li>
<li class="liflinks"><a target="_blank" href="/" title="CodePudding">CodePudding</a></li>
</ul>
</div>
</div>
</div>
</div>
<div class="footer">
<p><span style="font-size:16px;color:#666;font-weight: bold">About Us:</span> <a href="https://www.codepudding.com/contact.html">Contact Us</a> <a href="https://www.codepudding.com/service.html">Terms of Service</a> <a href="https://www.codepudding.com/privacy.html">
Privacy Policy</a></p>
<p class="foot_info">Copyright © 2010-2023，Powered By <a href="/" target="_blank">CodePudding</a> </p>
</div>
<script type="text/javascript" src="/skin/code/tianhu.js"></script>
</body></html> 