UC知道asp分页问题，点下一页时候显示为空
来源：百度知道 编辑：UC知道 时间：2024/05/09 04:35:07
我这个是根据搜索得出的数据然后分页显示，按搜索后分页正常，显示正常，就是点下一页的时候显示不出数据了，具体代码如下
<%
dim i,intPage,page,pre,last,filepath
dim rs
set rs = server.CreateObject("adodb.recordset")
if sf="省份" then
sql="select * from lw_products where p_class = '"+lb+"' and product_code like '%"+kd+"%' order by Price desc"
else
if kd="" then
sql="select * from lw_products where p_class = '"+lb+"' and Price = '"+sf+"' order by Price desc"
else
sql="select * from lw_products where p_class = '"+lb+"' and Price = '"+sf+"' and product_code like '%"+kd+"%' order by Price desc"
end if
end if
rs.PageSize = 5 '这里设定每页显示的记录数
rs.CursorLocation = 3
rs.Open sql,conn,0,2,1 '这里执行你查询SQL并获得结果记录集
pre = true
last = tru
<%
dim i,intPage,page,pre,last,filepath
dim rs
set rs = server.CreateObject("adodb.recordset")
if sf="省份" then
sql="select * from lw_products where p_class = '"+lb+"' and product_code like '%"+kd+"%' order by Price desc"
else
if kd="" then
sql="select * from lw_products where p_class = '"+lb+"' and Price = '"+sf+"' order by Price desc"
else
sql="select * from lw_products where p_class = '"+lb+"' and Price = '"+sf+"' and product_code like '%"+kd+"%' order by Price desc"
end if
end if
rs.PageSize = 5 '这里设定每页显示的记录数
rs.CursorLocation = 3
rs.Open sql,conn,0,2,1 '这里执行你查询SQL并获得结果记录集
pre = true
last = tru
<a href="yls_search.asp?page=<%=intpage -1%>">上页
你在这里把搜索的条件丢掉了，是不是应该在<a href="yls_search.asp?page=<%=intpage -1%>&搜索条件">
1、首先看你是不是少了先判断为空怎么样，也就是这样
if rs.eof or rs.bof then response.write("暂无数据")
2、你的else后面是不是判断错了，是不是应该这样
else
sql="select * from lw_products order by Price desc "
3、写条件搜索最好不要那样写，这样写
sql="select * from lw_products where 1=1"
if sf="省份" then
sql=sql&"and p_class = '"+lb+"' and product_code like '%"+kd+"%' "
end if
if kd="" then
sql=sql&"and p_class = '"+lb+"' and Price = '"+sf+"'"
end if
sql=sql&"order by Price desc"
4、检查你的条件是否正确
5、分页需不需要条件
<a href="yls_search.asp?page=<%=intpage -1%>&sf="&request("sf")&"&kd="&reques