查询分页,求助高人,感激不尽!100分。
<!--#include file="conn.asp" -->
<!--#include file="showpage.asp" -->
<%
sql="select * from bugtable where project_name='"&request("project_name")&"'"
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.pagesize=1
page=Clng(request("pagetext"))
if Rs.eof then
response.write "<span class=p9>还没记录!</span>"
%>
<%
else
if page<1 then page=1
if page>rs.pagecount then page=rs.pagecount
showpage rs,page
%>
<TABLE valign=top border=0 cellPadding=0 cellSpacing=3 width=450 >
<form method=POST action=page.asp>
<td>
<%
if page<>1 then
response.write"<a href=page.asp?pagetext=1><<首页</a><a href=page.asp?pagetext="&(page-1)&">前页</a>"
end if
if page<>rs.pageCount then
response.write"<a href=page.asp?pagetext="&(page+1)&">后页</a> <a href=page.asp?pagetext="&rs.pageCount&">尾页>></a>"
end if
%>
页次:<strong><%=Page%></strong>/<strong><%=rs.pageCount%></strong>页 转到:<input type=text name=pagetext size=5 maxlength=10 class=smallInput value=<%=Page%>><input class=buttonface type=submit value=Go name=B1></span></p>
</form>
</td></TABLE>
<% end if %>
第二页显示“还没记录!”而第二页的确应有。