查询数据时，为什么我点击“下一页”会把表中的所有记录都显示出来了？

[Miriamy]

查询数据时，为什么我点击“下一页”会把表中的所有记录都显示出来了？
怎样做才能正确的看到下一页的信息呢？
这个问题困扰了我好多天了，我只好增加每页显示的记录个数来掩盖这个错误，少翻页，
但还是不行呀，数据太多了，这样效率太低了
周一就要交了，我还没分出来

有哪位高手帮忙了？？

[lxxstarii]

你在“ 下一页”连接上加上“查询的条件参数”如：

if int(strpage)>1 then
response.write" <a href=huiyuanxinxiindex.asp?page=1&leibieid="&request("leibieid")&"&shenfenid="&request("shenfenid")&"&selectid="&request("selectid")&">首页</a> "
response.write" <a href=huiyuanxinxiindex.asp?page="&cstr(cint(strpage)-1)&"&leibieid="&request("leibieid")&"&shenfenid="&request("shenfenid")&"&selectid="&request("selectid")&">上一页</a> "
else
response.write"  首页 上一页"
end if
if int(strpage)<select_pagecount then
response.write" <a href=huiyuanxinxiindex.asp?page="&cstr(cint(strpage)+1)&"&leibieid="&request("leibieid")&"&shenfenid="&request("shenfenid")&"&selectid="&request("selectid")&">下一页</a>"
response.write" <a href=huiyuanxinxiindex.asp?page="&cstr(select_pagecount)&"&leibieid="&request("leibieid")&"&shenfenid="&request("shenfenid")&"&selectid="&request("selectid")&">尾页</a>"
else
response.write" 下一页 尾页"
end if

[angelheavens]

你把当前页号值传递了吗?

[glasses1999]

第一页有问题吗？
把你的控制分页的源码贴出来

[NetBoy]

页码和查询条件都是要传递的，缺一不可

[Miriamy]

我是这么写的，不行是为什么呀

<%end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if

response.write "<form method=Post action="&filename&"?serchtype="&request("serchtype")&"&serchname="&serchname&"&floorid="&floorid&"&roomid="&roomid&"&danwei="&danwei&"&officeid="&officeid&"&clasidd="&clasidd&"®="®&"®ister1="®ister1&"®ister2="®ister2&"&isopen="&isopen&"&isclose="&isclose&"&djtime1="&djtime1&"&djtime2="&djtime2&"&sytime1="&sytime1&"&sytime2="&sytime2&">"
response.write "<p align='center'><font color='#000080'>>>分页</font> "

if CurrentPage<2 then
response.write "<font color='#000080'>首页 上一页</font> "
else
response.write "<a href="&filename&"?page=1&serchtype="&serchtype&"&serchname="&serchname&"&floorid="&floorid&"&roomid="&roomid&"&danwei="&danwei&"&officeid="&officeid&"&clasidd="&clasidd&"®="®&"®ister1="®ister1&"®ister2="®ister2&"&isopen="&isopen&"&isclose="&isclose&"&djtime1="&djtyime1&"&djtime2="&djtime2&"&sytime1="&sytime1&"&sytime2="&sytime2&">首页</a> "
response.write "<a href="&filename&"?page="¤tPage-1&"&serchtype="&serchtype&"&serchname="&serchname&"&floorid="&floorid&"&roomid="&roomid&"&danwei="&danwei&"&officeid="&officeid&"&clasidd="&clasidd&"®="®&"®ister1="®ister1&"®ister2="®ister2&"&isopen="&isopen&"&isclose="&isclose&"&djtime1="&djtime1&"&djtime2="&djtime2&"&sytime1="&sytime1&"&sytime2="&sytime2&">上一页</a> "
end if

if n-currentpage<1 then
response.write "<font color='#000080'>下一页 尾页</font>"
else
response.write "<a href="&filename&"?page="&(CurrentPage+1)&"&serchtype="&serchtype&"&serchname="&serchname&"&floorid="&floorid&"&roomid="&roomid&"&danwei="&danwei&"&officeid="&officeid&"&clasidd="&clasidd&"®="®&"®ister1="®ister1&"®ister2="®ister2&"&isopen="&isopen&"&isclose="&isclose&"&djtime1="&djtime1&"&djtime2="&djtime2&"&sytime1="&sytime1&"&sytime2="&sytime2&">"
response.write ">下一页</a> <a href="&filename&"?page="&n&"&serchtype="&serchtype&"&serchname="&serchname&"&floorid="&floorid&"&roomid="&roomid&"&danwei="&danwei&"&officeid="&officeid&"&clasidd="&clasidd&"®="®&"®ister1="®ister1&"®ister2="®ister2&"&isopen="&isopen&"&isclose="&isclose&"&djtime1="&djtime1&"&djtime2="&djtime2&"&sytime1="&sytime1&"&sytime2="&sytime2&">尾页</a>"
end if

response.write "<font color='#000080'> 页次：</font><strong><font color=red>"¤tPage&"</font><font color='#000080'>/"&n&"</strong>页</font> "
response.write "<font color='#000080'> 共<b>"&totalnumber&"</b>条信息 <b>"&maxperpage&"</b>条信息/页</font> "
response.write " <font color='#000080'>转到：</font><input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">"
response.write "<input border='0' type='image' src='images/go.gif' name='cndok'></span></p></form>"

end function
%>