为什末不能分页呀?
写了一个查询的分页程序,为什末不能分页?请大侠们帮我看看?谢谢了
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>lendbook</title>
</head>
<body>
<%
dim counter
dim m,n,i
Set conn=server.CreateObject("ADODB.Connection")
conn.open "dsn=bookmanage"
Set count=conn.Execute("select * from book where state='1' " )
Do while not count.eof
counter=counter+1
count.movenext
loop
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from book where state='1' "
rs.Open sql,conn,1,1
%>
<form name="notlend_book" method="post" action=" borrow_book .asp">
<table width="100%" height="100" border="0">
<tr style="BACKGROUND-COLOR: cornsilk"> 未借出图书</font></tr>
请选择您需要借阅的图书确定后 按下“提交”按钮。
<tr style="BACKGROUND-COLOR: cornsilk">
<td align="center" width="7%" > 图书序号</td>
<td align="center" width="8%" > 图书编号</td>
<td align="center" width="38%"> 图书名称</td>
<td align="center" width="20%">图书作者</td>
<td align="center" width="10%">出版社</td>
</tr>
<% rs.pagesize=10
rs.absolutepage=request.querystring("Pcnt")
for m=1 to rs.pagesize
if rs.eof then
exit for
end if
%>
<% do while not (rs.eof or err)%>
<tr style="BACKGROUND-COLOR: cornsilk">
<td ><input type="radio" name="bookchange" value="<%=rs(0)%>"><%=rs(0)%></td>
<% for i=1 to 4%>
<td style="BACKGROUND-COLOR: cornsilk" valign="center" align="left" width="15%">
<%=rs(i)%>
</td>
<%next%>
</tr>
<%rs.MoveNext
loop %>
<%next%>
<tr>
<input name="submit" type="button" value="提交"> <input name="cancel" type="button" value="取消">
</tr>
<tr>
<td colspan="4">目前有<%=rs.pagecount%>页 共<%=counter%>条记录</td></tr>
<tr>
<td>
<%
for n=1 to rs.pagecount
%>
<a href="numberpage.asp?Pcnt=<%=n%>"><%=n%></a>
<%next%>
<% rs.close
set conn=nothing
%>
</td></tr>
</table>
</form>
</body>
</html>