分页-->当前页面显示多少条记录问题!~!~ ●●●●●■■■■■■
下面代码可以正常运行,我设置了 rs.pagesize=2 为什么一页显示的内容还是只有一条记录,而不是二条记录。错在哪里,请兄弟们帮帮忙!~!~!~!~!~!~
<%
Dim conn,rs,i
set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.MapPath("db1.mdb")
exec="select * from guestbook order by 1 desc"
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,1,1
rs.PageSize=2
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then page=1
rs.AbsolutePage=page
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<form name="form1" method="post" action="ok.asp?id=<%=request("id")%>">
<table width="833" height="26" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<% for j=1 to pagecount %>
<td><%=rs("name")%></td>
<% Next %>
</tr>
</table><br>
<a href="index.asp?page=<%=page-1%>">上一页</a>
<a href="index.asp?page=<%=page+1%>">下一页</a></a>
<p align="center"></p>
</form>
</body>
</html>