俺菜鸟一个,大家帮我看看这个分页程序吧
我至尽试了很多分页程序了,可是没有一个成功的.........
大家帮我修改一下,成功了就给分!!!
<%
on error resume next
if request.QueryString("page")="" then
page=1
else
page=cint(request.QueryString("page"))
set link1=server.CreateObject("adodb.connection")
link1.open "driver={sql server};server=leon;uid=sa;pwd=;database=pubs"
rs.open "select * from roysched",link1,1,1
rs.pagesize=12
rs.absolutepage=page
if err.number<>0 then
response.Write("出现异常错误")
response.End()
end if
%>
<base target="_blank">
<table border="1">
<%
for i=0 to rs.pagesize-1
if rs.eof then
exit for
response.Write "<tr><td>"&i+(page*13-13)+1&":<a href='"&rs("title_id")&"'>&rs("lorange")&"</a></td></tr>"
rs.movenext
end if
next
%>
<tr><td align=right>
<base target='_top'>
<%
pageleon=split(request.ServerVariables("QUERY_STRING")
if ubound(pagelen)<1 then
if page>1 then response.Write("<a href="fengye.asp?page=1">首页</a><a href="fengye.asp?page="&page-1&"">上页</a>")
else
response.Write("下页 尾页")
for i=1 to rs.pagecount
if i=page then
response.Write(i&"")
else
response.Write("<a href="fengye.asp?page="&i&"">"&i&"</a>")
next
end if
rs.close
set rs=nothing
set link1=nothing
%>
</table>