为什么查询后,当查询字段分页显示时,点击首页、上页、下页、末页显示的是空白，无记录？该如何解决
日期：2014-05-17 浏览次数：20926 次
为什么查询后,当查询字段分页显示时,点击首页、上页、下页、末页显示的是空白，无记录？！
代码如下： kfs为当前查询字段
<%
kfs=request.form( "kfs ")
lxr=request.form( "lxr ")
ccase=request.form( "ccase ")
worker=request.form( "worker ")
spr=request.form( "spr ")
set conn=server.createobject( "adodb.connection ")
conn.open "driver={microsoft access driver (*.mdb)};dbq= "&server.mappath( "gustb.mdb ")
%>
<%
exec= "select * from beian where kfs= ' "&kfs& " ' "
set rs=server.createobject( "adodb.recordset ")
rs.CursorLocation = 3
rs.PageSize = 10
rs.CacheSize = 5
rs.open exec,conn,1,1
%>
<%
if request( "pages1 ")=0 then
pages1=1
else
pages1=cint(request( "pages1 "))
end if
if not rs.eof then
rs.AbsolutePage=pages1
end if
if not rs.eof then
recPerpage=0
%>
<html>
<head>
<title> kqsjk </title>
</head>
<body bgcolor= "#799AE1 ">
<table border= "0 " width= "80% " id= "table1 " align= "center ">
<tr>
<td colspan= "5 " bgcolor= "#00659C " height= "80 ">
<p align= "center "> <font size= "10 " face= "华文新魏 "> <font color= "#FFFFFF "> 淮安冲浪房产科技有限公司 </font> </font> </td>
</tr>
<tr>
<td bgcolor= "#00659C " width= "10% "> <a href= "kqindex.asp "> <font color= "#000000 "> 回到首页 </font> </a> </td>
<td bgcolor= "#00659C " width= "13% "> <a href= "beian.asp "> <font color= "#000000 "> 备案延时系统 </font> </a> </td>
<td bgcolor= "#00659C " colspan= "2 "> <a href= "javascript:window.close(); "> <font color= "#000000 "> 退出系统 </font> </a> </td>
</tr>
<tr>
<td colspan= "5 "> 您当前位置：备案查询 </td>
</tr>
<tr>
<td colspan= "5 " height= "230 ">
<table width= "100% " border= "1 " bgcolor= "#FFFFFF " align= "center " bordercolor= "#000000 " cellpadding= "1 " cellspacing= "0 " >
<tr bgcolor= "#00659C ">
<td> <div align= "center "> 编号 </div> </td>
<td> <div align= "center "> 开发商 </div> </td>
<td>
代码如下： kfs为当前查询字段
<%
kfs=request.form( "kfs ")
lxr=request.form( "lxr ")
ccase=request.form( "ccase ")
worker=request.form( "worker ")
spr=request.form( "spr ")
set conn=server.createobject( "adodb.connection ")
conn.open "driver={microsoft access driver (*.mdb)};dbq= "&server.mappath( "gustb.mdb ")
%>
<%
exec= "select * from beian where kfs= ' "&kfs& " ' "
set rs=server.createobject( "adodb.recordset ")
rs.CursorLocation = 3
rs.PageSize = 10
rs.CacheSize = 5
rs.open exec,conn,1,1
%>
<%
if request( "pages1 ")=0 then
pages1=1
else
pages1=cint(request( "pages1 "))
end if
if not rs.eof then
rs.AbsolutePage=pages1
end if
if not rs.eof then
recPerpage=0
%>
<html>
<head>
<title> kqsjk </title>
</head>
<body bgcolor= "#799AE1 ">
<table border= "0 " width= "80% " id= "table1 " align= "center ">
<tr>
<td colspan= "5 " bgcolor= "#00659C " height= "80 ">
<p align= "center "> <font size= "10 " face= "华文新魏 "> <font color= "#FFFFFF "> 淮安冲浪房产科技有限公司 </font> </font> </td>
</tr>
<tr>
<td bgcolor= "#00659C " width= "10% "> <a href= "kqindex.asp "> <font color= "#000000 "> 回到首页 </font> </a> </td>
<td bgcolor= "#00659C " width= "13% "> <a href= "beian.asp "> <font color= "#000000 "> 备案延时系统 </font> </a> </td>
<td bgcolor= "#00659C " colspan= "2 "> <a href= "javascript:window.close(); "> <font color= "#000000 "> 退出系统 </font> </a> </td>
</tr>
<tr>
<td colspan= "5 "> 您当前位置：备案查询 </td>
</tr>
<tr>
<td colspan= "5 " height= "230 ">
<table width= "100% " border= "1 " bgcolor= "#FFFFFF " align= "center " bordercolor= "#000000 " cellpadding= "1 " cellspacing= "0 " >
<tr bgcolor= "#00659C ">
<td> <div align= "center "> 编号 </div> </td>
<td> <div align= "center "> 开发商 </div> </td>
<td>
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
