求助asp分页问题

来源:百度知道 编辑:UC知道 时间:2024/06/19 02:57:50
<%
sql="select * from wtdj order by ID desc "
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn
rs.PageSize=7
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
%>
<body>
<table width="1000" border="1" cellpadding="0" cellspacing="0" bordercolor="#4D9F4F"class="body">
<tr>
<td>姓 名</td>
<td>性 别</td>
<td>手机号</td>
<td>固定电话</td>
<td>小区名称</td>
<td>房屋结构</td>
<td>房屋类型</td>
<td>租售价格</td>
<td>租售选择</td>
<td>所在楼层</td>
<td>建筑面积</td>
<td>楼层总数</

<%
  sql="select * from wtdj order by ID desc "
  Set rs=Server.CreateObject("ADODB.Recordset")
  rs.Open sql,conn
  rs.PageSize=7
  pagecount=rs.PageCount
  page=int(request.QueryString ("page"))
  if page<=0 then page=1
  if request.QueryString("page")="" then
  page=1
  end if
  %>
  <body>
  <table width="1000" border="1" cellpadding="0" cellspacing="0" bordercolor="#4D9F4F"class="body">
  <tr>
  <td>姓 名</td>
  <td>性 别</td>
  <td>手机号</td>
  <td>固定电话</td>
  <td>小区名称</td>
  <td>房屋结构</td>
  <td>房屋类型</td>
  <td>租售价格</td>
  <td>租售选择</td>
  <td>所在楼层</td>
  <td>建筑面积</td>
  <td>楼层总数</td