不能分页,该怎么解决
日期：2014-05-17 浏览次数：20854 次
不能分页
<!--#include file= "conn.asp "-->
<% set rs=server.CreateObject( "adodb.recordset ")
sql= "select * from user "
if session( "userlimit ") <1 then sql=sql& " where user_name= ' "&session( "username ")& " ' "
sql=sql& " order by user_name desc "
rs.open sql,conn,1,1
rs.pagesize=2
PageNo=request( "PageNo ")
if request( "pagerno ")= " "or request( "pageno ") <=1 then pageno=1
totalpages=rs.pagecount
if request.servervariables( "content_length ") > 0 then
currentpage=1
else
currentpage=clng(PageNo)
end if
if currentpage> totalpages then currentpage=totalpages
if not(rs.eof) then rs.absolutepage = currentpage
%>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 " />
<title> 显示用户 </title>
</head>
<body>
<table width= "98% " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 ">
<tr>
<td>
<table width= "100% " border= "0 " cellpadding= "0 " cellspacing= "1 " bgcolor= "#F4F9FF ">
<tr bgcolor= "#E3E8F9 ">
<td width= "20 " height= "15 "> </td>
<td height= "15 "> <div align= "center "> <font size= "2 "> <strong> 用 户 名 </strong> </font> </div> </td>
<td width= "80 " height= "15 "> <div align= "center "> <font size= "2 "> <strong> 用户类型 </strong> </font> </div> </td>
<td width= "80 " height= "15 "> <div align= "center "> <font size= "2 "> <strong> 管理 </strong> </font> </div> </td>
</tr>
<%
rowcount=(currentpage - 1)*rs.pagesize
for i=1 to rs.pagesize
if rs.eof then exit for
%>
<tr bgcolor= "#F4F8FF ">
<!--#include file= "conn.asp "-->
<% set rs=server.CreateObject( "adodb.recordset ")
sql= "select * from user "
if session( "userlimit ") <1 then sql=sql& " where user_name= ' "&session( "username ")& " ' "
sql=sql& " order by user_name desc "
rs.open sql,conn,1,1
rs.pagesize=2
PageNo=request( "PageNo ")
if request( "pagerno ")= " "or request( "pageno ") <=1 then pageno=1
totalpages=rs.pagecount
if request.servervariables( "content_length ") > 0 then
currentpage=1
else
currentpage=clng(PageNo)
end if
if currentpage> totalpages then currentpage=totalpages
if not(rs.eof) then rs.absolutepage = currentpage
%>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 " />
<title> 显示用户 </title>
</head>
<body>
<table width= "98% " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 ">
<tr>
<td>
<table width= "100% " border= "0 " cellpadding= "0 " cellspacing= "1 " bgcolor= "#F4F9FF ">
<tr bgcolor= "#E3E8F9 ">
<td width= "20 " height= "15 "> </td>
<td height= "15 "> <div align= "center "> <font size= "2 "> <strong> 用 户 名 </strong> </font> </div> </td>
<td width= "80 " height= "15 "> <div align= "center "> <font size= "2 "> <strong> 用户类型 </strong> </font> </div> </td>
<td width= "80 " height= "15 "> <div align= "center "> <font size= "2 "> <strong> 管理 </strong> </font> </div> </td>
</tr>
<%
rowcount=(currentpage - 1)*rs.pagesize
for i=1 to rs.pagesize
if rs.eof then exit for
%>
<tr bgcolor= "#F4F8FF ">
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
