我要听祥林嫂评剧电影:ASP代码有错误,高手帮忙看看了,

来源:百度文库 编辑:高校问答 时间:2024/04/29 14:22:40
<%
strSql ="Select * From CPID where ID= 1"
Set rs=conn.Execute(strSql)
%>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>

<table width="100%" border="1" align="center">
<tr>
<td><table width="100%" border="0" align="center">
<tr>
<td colspan="2">首页/<%=rs("FLID")%>/<%=rs("ZFLID")%>/<%=rs("NAME")%></td>
</tr>
<tr>
<td width="76%"><table width="100%" border="0">
<tr>
<td><img src="image/800c%20335.jpg" width="335" height="335"></td>
<td><table width="100%" border="0">
<tr>
<td><div align="center"><strong><%=rs("NAME")%></strong></div></td>
</tr>
<tr>
<td>商品编号:<%=rs("xinghao")%></td>
</tr>
<tr>
<td>商品颜色:<%=rs("yanse")%></td>
</tr>
<tr>
<td>商品规格:<%=rs("guige")%></td>
</tr>
<tr>
<td>商品品牌:<%=rs("pinpai")%></td>
</tr>
<tr>
<td>运输方式:免费送货,免费安装。</td>
</tr>
<tr>
<td>付款方式:货到付款</td>
</tr>
<tr>
<td>售后服务:1年免费维修<img src="image/1113S.jpg" width="113" height="113"></td>
</tr>
<tr>
<td>  市场价:<s><%=rs("jiage")%>¥</s></td>
</tr>
<tr>
<td>  <span class="style1">会员价:<%=rs("userjia")%>¥ </span></td>
</tr>
<tr>
<td><div align="center"><img src="image/gm.gif" width="89" height="29">    <img src="image/frgwc.gif" width="117" height="29"></div></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table></td>
<td><table border="0">
<tr>
<td><%=rs("xinghao")%>其他颜色:</td>
</tr>
<tr>
<td>

<table width="200" border="1">

<%

set myrs=server.CreateObject("adodb.recordset")
sql="Select * From CPID where xinghao=800c order by ID"
myrs.Open sql,conn,1,1
do until myrs.EOF
%>

<tr>

<td><%=myrs("tupianxiao")%></td>
</tr>
<tr>
<td><%=myrs("NAME")%></td>
</tr>
<tr>
<td><%=myrs("userjia")%></td>
</tr>
<%
myrs.MoveNext
loop
myrs.Close
set myrs=nothing
%>
</table>

</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>

这块有问题:
<%
set myrs=server.CreateObject("adodb.recordset")
sql="Select * From CPID where xinghao=800c order by ID"
myrs.Open sql,conn,1,1
do until myrs.EOF
%>

<tr>

<td><%=myrs("tupianxiao")%></td>
</tr>
<tr>
<td><%=myrs("NAME")%></td>
</tr>
<tr>
<td><%=myrs("userjia")%></td>
</tr>
<%
myrs.MoveNext
loop
myrs.Close
set myrs=nothing
%>
改为:
1、
sql="Select * From CPID where xinghao='800c' order by ID"
2、
应在myrs.MoveNext之后加上
if myrs.eof then exit do

提示的什么错误,运行后的错误页面说下,这样让人看,头大啊!

CUP100% PF不断上升.

晕一个!到底哪里错了?