查询结果 翻页问题.

[dansheng2000]

请问查询结果翻页如何实现......

sql="select * from book where (xuhao = '"&request("xuhao")&"' ) and (TIANBIAORQ between '"&cdate(request("time1"))&"'and '"&cdate(request("time2"))&"')"


<%if rs3.pagecount<>1 and rs3.pagecount<>0 then%>
<%if page<rs3.pagecount then%>
<%if page=1 then %>
[首页] [上一页]
<%else%>
[<a Href="seach-do.asp?page=<%=1%>&xuhao=<%request("xuehao")%>">首页</a>] [<a Href="seach-do.asp?page=<% =page-1 %>&xuhao=<%request("xuehao")%>">上一页</a>]
<% end if %>
[<a Href="seach-do.asp?page=<%page+1%>&xuhao=<%request("xuehao")%>">下一页</a>] [<a Href="seach-do.asp?page=<%=rs3.PageCount%>&xuhao=<%request("xuehao")%>">尾页</a>]
<%else%>
[<a Href="seach-do.asp?page=<% = 1%>&xuhao=<%request("xuehao")%>">首页</a>] [<a Href="seach-do.asp?page=<% =page -1 %>&xuhao=<%request("xuehao")%>">上一页</a>]
[下一页] [尾页]
<%end if %>
<%else%>
[首页] [上一页] [下一页] [尾页]
<%end if%>
[页次:<font color=red><b><%=page%></b></font>/<%=rs3.PageCount%>]
[共<font color=red><b><%=rs3.RecordCount%></b></font>篇]



翻页后数据不对，篇数也不对。请教．．．．

[itzhiren]

分页问题嘛，网上很多的，搜一下

[kafly]

最讨厌<% end if %> ，效率底不说，看起来也费力啊