Question

（急）请高手来下 ADODB.Field 错误 '800a0bcd' ....................../caseshow.asp，行 17

代码如下：<!--#include file="top.asp"-->
<table width="1003" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" bgcolor="#EEEEEE"><table width="975" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="10" height="96" bgcolor="#FFFFFF"><!--#include file="left.asp"--></td>
<td width="965" valign="top" bgcolor="#FFFFFF"><table width="98%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td width="54%" height="43" style="border-bottom:1px solid #83BAF1; "><span style="font-weight: bold; font-size: 15px; color: #1B6EBE">  案例中心</span></td>
<td width="46%" style="border-bottom:1px solid #83BAF1; "><div align="right">当前位置：首页>>案例中心  </div></td>
</tr>
<tr>
<td colspan="2"><table border="0" align="center" cellpadding="0" cellspacing="0">
<%set rs=server.CreateObject("adodb.recordset")
sql="select * from admin_product where id="&request("id")
rs.open sql,conn,1,1
bigid=rs("p_bigclass")
id=rs("id")
smallid=rs("p_smallclass")
%>
<tr>
<td align="center"><br />
<img src="<%=rs("p_img")%>" border="0" /></a></td>
</tr>
<tr>
<td height="25"><span class="STYLE2">案例名称：<%=rs("p_name")%></span></td>
</tr>
<tr>
<td height="25" style="line-height:150%;"><span class="STYLE2"><%=rs("p_cont")%></span></td>
</tr>
<%rs.close
set rs=nothing%>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="foot.asp"-->

Answer 1

一般是在执行循环时，在执行到最后一个记录时，没有及时的终止循环。

应该是你传的参数有错误，所以你应该这样改：〕

<!--#include file="top.asp"-->
<table width="1003" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" bgcolor="#EEEEEE"><table width="975" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="10" height="96" bgcolor="#FFFFFF"><!--#include file="left.asp"--></td>
<td width="965" valign="top" bgcolor="#FFFFFF"><table width="98%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td width="54%" height="43" style="border-bottom:1px solid #83BAF1; "><span style="font-weight: bold; font-size: 15px; color: #1B6EBE"> 案例中心</span></td>
<td width="46%" style="border-bottom:1px solid #83BAF1; "><div align="right">当前位置：首页>>案例中心 </div></td>
</tr>
<tr>
<td colspan="2"><table border="0" align="center" cellpadding="0" cellspacing="0">
<%set rs=server.CreateObject("adodb.recordset")
sql="select * from admin_product where id="&request("id")
rs.open sql,conn,1,1
if not rs.eof then
bigid=rs("p_bigclass")
id=rs("id")
smallid=rs("p_smallclass")
%>
<tr>
<td align="center"><br />
<img src="<%=rs("p_img")%>" border="0" /></a></td>
</tr>
<tr>
<td height="25"><span class="STYLE2">案例名称：<%=rs("p_name")%></span></td>
</tr>
<tr>
<td height="25" style="line-height:150%;"><span class="STYLE2"><%=rs("p_cont")%></span></td>
</tr>
<%
end if
rs.close
set rs=nothing%>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="foot.asp"-->