ASP分页问题不解。。。。。。帮忙解决
错误
ADODB.Field 错误 '80020009'
BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。
anpin.asp,行0
代码
<%
set rst=server.CreateObject("adodb.recordset")
sql="select * from cp_table order by id desc"
rst.open sql,conn,1,3
rst.pagesize=10
pagecount=rst.pagecount '总页数
page=int(request("page"))
'if page<=0 then page=1
if request("page")="" then page=1
rst.absolutepage=page
if rst.eof and rst.bof then
Response.Write("暂时没有记录")
else
for i= 1 to rst.pagesize
%>
<table width="584" height="136" style="border-bottom:#999999 1px double;">
<!--DWLayoutTable-->
<tr>
<td width="185" rowspan="5" align="center" valign="middle"><a href="show_chanpin.asp?toid=<%=rst("id")%>&toname=<%=rst("tit")%>"><img src="picimg/<%=rst("pic")%>" width="100" border="0"></a></td>
<td width="79" height="20" valign="top"><DIV align="right">产品名称:</DIV></td>
<td width="298" valign="top"><%=rst("tit")%></td>
</tr>
<tr>
<td height="20" valign="top"><DIV align="right">产品规格:</DIV></td>
<td valign="top"></td>
</tr>
<tr>
<td height="20" valign="top"><DIV align="right">产品备注:</DIV></td>
<td valign="top"></td>
</tr>
<tr>
<td height="20" valign="top"><DIV align="right">产品类别:</DIV></td>
<td valign="top"><a href="chanpin.asp?totype=<%=rst("type")%>"><%=rst("type")%></a>→</td>
</tr>
<tr>
<td height="42" valign="top"><DIV align="right">产品信息:</DIV></td>
<td valign="top"><a href="show_chanpin.asp?toid=<%=rst("id")%>&toname=<%=rst("tit")%>"><img src="images/arrow.gif" width="75" height="18" border="0"></a></td>
</tr>
<tr>
<td height="2"></td>
<td></td>
<td></td>
</tr>
</table>
<%
rst.movenext
next
end if
rst.close
set rst=nothing
%>