ADODB.Field 错误 '80020009' BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除

来源：百度知道 编辑：UC知道 时间：2024/06/05 05:29:12
<% set rs=server.createobject("adodb.recordset")
sql="select * from all_model where type='info' and pl<'100' order by pl"
rs.open sql,conn,1,1
i=1

%>
<tr>
<%do while not rs.eof%>

<%
Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open "Select top 1 * From info where model like '"&rs("model")&"' and img_1 like '%2%' and state='1' Order By id

DESC",conn, 1,1
%>
<TR>
<TD class=b3><div align="center"><a href=../info/open.asp?id=<%=rst("id")%>&type=05 ><img

src="../photo/<%=rst("img_1")%>" width="90" height="70" border="0"></a></div></TD>

Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open "Select top 1 * From info where model like '"&rs("model")&"' and img_1 like '%2%' and state='1' Order By id DESC",conn, 1,1
这个rst你并没有判断是否为空
错误应该出在这裏
因为你在<a href=../info/open.asp?id=<%=rst("id")%>&type=05 >用了rst

而且后面你又重复定义了rst
set rst=server.createobject("adodb.recordset")
这裏也应该有问题