看看我的分页代码哪里错啦!系统是安装了.net的,后台是oracle8.05
<%@ Language=VBScript %>
<!--#include file="inc/conn.inc" -->
<% 'Set rs=server.createobject("adodb.recordset")
Response.Expires = 0
Server.ScriptTimeOut = 500 '程序运行超时时间,请尽可能设置多的时间。
PageShowSize = 4 '每页显示多少个页连接(就是每页显示几个翻页符)
MyPageSize = 2 '每页显示多少个程序
'=========设置显示内容循环部分=========
Dim numRows
numRows = MyPageSize
Dim index
index = 0
'========判断page参数是否存在或空======
If Not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Or Request("page") <=0 Then
MyPage=1
Else
MyPage=Int(Abs(Request("page")))
End if
dim classid,sqlstr
'按需要打开数据库内容
if request.form("subclass")="" then
sqlstr="select id,title from article_tab where a_class_id="&session("class")
else
sqlstr="select id,title from article_tab where a_subclass_id="&request.form("subclass")
end if
ScriptName = Request.Servervariables("URL")
ScriptVals = Request.Servervariables("QUERY_STRING")
'response.write sqlstr
'response.end
'============ 程序总数 ============
Set Rs=server.createobject("adodb.recordset")
Rs.open sqlstr,conn,1,1
Rs.PageSize = MyPageSize
MaxPages = Rs.PageCount
Rs.absolutepage = MyPage
total = Rs.RecordCount
%>
<html>
<head>
<title>文章发布</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
While ((numRows <> 0) AND (NOT Rs.EOF))
Content = rs("content")
Name = rs("title")
response.write "<table><td>"& rs("title") &"</td></table>"
index=index+1
numRows=numRows-1
Rs.MoveNext
Wend
'========循环内容结束===================
Rs.close
Page_link '调用分页函数
Function Page_Link
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/MypageSize)+1
qstring = ScriptName& "?"
if PageNextSize >1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "<a href='" & qstring & "page=" & PagePrev & "' title='上一翻页'>[<<]</a>-"
Response.write "<a href='" & qstring & "page=1' title='页首'>[1]</a>-"
end if
if MyPage-1 > 0 then
Prev_Page = MyPage - 1
Response.write "<a href='" & qstring & "page=" & Prev_Page & "' title='上一页'>[<]</a> "
end if
if Maxpages>=PageNextSize*PageShowSize then
PageSizeShow = PageShowSize
Else
PageSizeShow = Maxpages-PageShowSize*(PageNextSize-1)
End if
If PageSizeShow < 1 Then PageSizeShow = 1
for PageCounterSize=1 to PageSizeShow
PageLink = (PageCounterSize+PageNextSize*PageShowSize)-PageShowSize
if PageLink <> MyPage Then
Response.write "<a href='" & qstring & "page=" & PageLink & "'>[" & PageLink & "]</a> "
else
Response.Write "<B>["& PageLink &"]</B> "
end if
If PageLink = MaxPages Then Exit for
Next
if Mypage+1 <=Pagetpage then
Next_Page = MyPage + 1
Response.write "<a href='" & qstring & "page=" & Next_Page & "' title='下一页'>[>]</A>"
end if
if MaxPages > PageShowSize*PageNextSize then
PageNext = PageShowSize * PageNextSize + 1
Response.write "-<A href='" & qstring & "page=" & Pagetpage & "' title='页尾'>["& Pagetpage &"]</A>"
Response.write "-<a href='" & qstring & "page=" & PageNext & "' title='下一翻页'>[>>]</a>"
End if
End Function
%>
</body>
</html>
conn.inc
<%
set conn=server.createobject("adodb.connection")
dns="Provider=MSDAORA;Persist Security Info=True;User ID=nhrc;Password=nhrc;Data Source=xpelive"
conn.Open dns
%>