Microsoft VBScript error compiler errors' 800 a0401 statements not over
& lt; ! PUBLIC DOCTYPE HTML "-////W3C DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" & gt;
<meta HTTP - equiv="content-type" Content="text/HTML. Charset=gb2312 "/& gt;
No title documents & lt;/title> <br/><br/><br/><br/></head> <br/><br/><body> <br/><br/><p> Test & lt;/p> <br/><br/><% <br/>Dim conn, connstr, db <br/>The db="aa. MDB" <br/>Set the conn=Server. CreateObject (" ADODB. Connection ") <br/>The db=server. MapPath (" SDK. MBD ") <br/>Conn. Open "driver={Microsoft Access driver (*. MDB)}; DBQ="& amp; Bd <br/>Conn. Open connstr <br/>SQL="select * from tableTest"; <br/>Set the rs=dbconnection. Execute (SQL); <br/>Rs. The open SQL, conn, 1, 1 <br/>Eof <br/> the do while not rs.Response. Write (rs (" A1 ")) <br/>Rs. Movenext <br/>Loop <br/>Conn. Close <br/>SQL. Close <br/>Set the rs=nothing <br/>Set the conn=nothing <br/>%> <br/><p> <%=rs (" A1 ") % & gt; </p> <br/><br/><% % RSS. The close conn. Close & gt; <br/></body> <br/></html> <br/></pre> <br/><br/><br/>Error <br/>Microsoft VBScript compiler errors mistakes' 800 a0401 '<br/><br/>The statement did not end <br/><br/>/index. Asp, line 22 <br/><br/>SQL="select * from tableTest"; <br/>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - ^<p class="article - content rp"> CodePudding user response: </p>SQL does not declare <br/>The first line with SQL <br/>Dim conn, connstr, db, SQL<p class="article - content rp"> CodePudding user response: </p><% % RSS. The close conn. Close & gt; This has a problem,<p class="article - content rp"> CodePudding user response: </p>VBScript end statements don't add a semicolon<p class="article - content rp"> CodePudding user response: </p><fieldset> <legend> Hello World reference 3 floor, response: <legend> <blockquote> VBScript end statements don't add a semicolon </blockquote> <fieldset> <br/>Yes, asp cannot have a semicolon </div>
<div class="th_page th_page_color"></div>
<div class="umCopyright">
<p>Page link：<a href="/net/55367.html" target="_blank" style="color:#999">https//www.codepudding.com/net/55367.html</a></p>
</div>
<div class="detail-arr">
<div class="detail-arr-left">Prev:<a href='/net/55366.html'>With vb.net read the STL file, a 3 d graphics display, how to do?</a></div>
<div class="detail-arr-right">Next:<a href='/net/55368.html'>Layui modify the ajax requests</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.NET' target='_blank'>ASP.NET</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>