asp分页程序问题

来源:百度知道 编辑:UC知道 时间:2024/05/15 03:11:51
<% set conn=server.createobject("ADODB.Connection")
conn.open "Driver={Microsoft Access Driver (*.mdb)};dbq=" &server.mappath("message.mdb") %>

<% Set rs = Server.CreateObject ("ADODB.Recordset")
sql="select * from mytable"
rs.Open sql, conn, 1 %>

<% rs.PageSize=10
IF rs.Eof THEN
Response.Write("<font size=2 color=#000080>[数据库中没有记录!]</font>")
ELSE
If Request("rs.CurrentPage")="" Then
rs.AbsolutePage=1
Else
rs.AbsolutePage=CLng(Request("rs.CurrentPage"))
End If %>

<% if rs.PageCount=1 then
Response.Write("[第一页] [上一页] [下一页] [最后一页] ")
else
if rs.AbsolutePage=1 then

Response.Write("[第一页] [上一页] ")
Response.Write("[<a Href="test.asp?Page=<% =request("page") + 1%>">下一页] ")

<% rs.PageSize=10
IF rs.Eof THEN
Response.Write("<font size=2 color=#000080>[数据库中没有记录!]</font>")
ELSE
If Request("rs.CurrentPage")="" Then
rs.AbsolutePage=1
Else
rs.AbsolutePage=CLng(Request("rs.CurrentPage"))
End If %>
这段少了个end if

Response.Write("[<a Href="test.asp?Page=<% =request("page") + 1%>">下一页] ")
Response.Write("[<a Href="test.asp?Page=<% = rs.PageCount%>">最后一页</a>] ")

这两句改为
Response.Write("[<a Href=""test.asp?Page="""& request("page") + 1&""">下一页] ")
Response.Write("[<a Href=""test.asp?Page="""& rs.PageCount&""">最后一页</a>] ")

还有其他
Response.Write()里面的也要像上面的方法改正

<%Response.Write "<BR>数据总