有关循环的问题,帮忙啊
ADODB.Field 错误 '80020009'
BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。
/test.asp,行0
==================================================
<%set rc=conn.Execute(sql)%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30" height="25"> <div align="center"><img src="http://www.chinacomponents.com.cn/images/nfang.gif" width="5" height="5"></div></td>
<td width="570" height="25"><a href="http://www.chinacomponents.com.cn/sczx/qkview1.asp?new_id=<%=rc("new_id")%>&leibie=<%=rc("leibie")%>" target="_blank"><%=rc("title")%></a></td>
</tr>
<tr>
<td width="30"> </td>
<td width="570"><%=rc("jianjie")%></td>
</tr>
<tr>
<td width="30" height="20"> </td>
<td width="570" height="20"> <div align="right"><a href="http://www.chinacomponents.com.cn/sczx/qkview1.asp?new_id=<%=rc("new_id")%>&leibie=<%=rc("leibie")%>" target="_blank">详细信息</a> </div></td>
</tr>
<%rc.movenext%>
<tr>
<td width="30" height="25"> <div align="center"><img src="http://www.chinacomponents.com.cn/images/nfang.gif" width="5" height="5"></div></td>
<td width="570" height="25"><a href="http://www.chinacomponents.com.cn/sczx/qkview1.asp?new_id=<%=rc("new_id")%>&leibie=<%=rc("leibie")%>" target="_blank"><%=rc("title")%></a></td>
</tr>
<tr>
<td width="30"> </td>
<td width="570"><%=rc("jianjie")%></td>
</tr>
<tr>
<td width="30" height="20"> </td>
<td width="570" height="20"> <div align="right"><a href="http://www.chinacomponents.com.cn/sczx/qkview1.asp?new_id=<%=rc("new_id")%>&leibie=<%=rc("leibie")%>" target="_blank">详细信息</a> </div></td>
</tr>
<%rc.movenext%>
<tr>
<td colspan="2"> <br> <table width="98%" border="0" cellspacing="2" cellpadding="0" bordercolorlight="#ffffff" bordercolordark="#AACCF2" align="center">
<%
i=0
do while not rc.eof and i<10
if i mod 2 = 0 then
bgcol = "#EFEFEF"
else
bgcol = "#ffffff"
end If%>
<tr>
<td width="29" height="25"> <div align="center"><img src="http://www.chinacomponents.com.cn/images/nfang.gif" width="5" height="5"></div></td>
<td width="266" height="25"><a href="http://www.chinacomponents.com.cn/sczx/qkview1.asp?new_id=<%=rc("new_id")%>&leibie=<%=rc("leibie")%>" target="_blank">
<%if len(rc("title"))>22 then%>
<%=left(rc("title"),20)%>...
<%else%>
<%=rc("title")%>
<%end if%>
</a></td>
<%rc.movenext%>
<td width="29" height="25"> <div align="center"><img src="http://www.chinacomponents.com.cn/images/nfang.gif" width="5" height="5"></div></td>
<td width="266" height="25"><a href="http://www.chinacomponents.com.cn/sczx/qkview1.asp?new_id=<%=rc("new_id")%>&leibie=<%=rc("leibie")%>" target="_blank">
<%if len(rc("title"))>22 then%>
<%=left(rc("title"),20)%>...
<%else%>
<%=rc("title")%>
<%end if%>
</a></td>
<%rc.MoveNext
i=i+1
loop
%>
</tr>
</table></td>
</tr>
</table>
<%rc.close%>