求救高手!!分页问题!!!为何到下一页时,传递的参数没起作用?
第一页按条件筛选了,但按下一页时,并没有按我要求的条件进行筛选,而是显示了所有记录???将光标放在到下一页的超级联接的时候会出现我的查询条件,怎么回事啊?是不是超级联接处的查询条件不对?已经4天了......救救我吧,一定送分!!
<%@ Language=VBScript EnableSessionState=true%>
<!--#include file ="call_interbase.asp"-->
<!--#include file = "adovbs.inc"-->
<HTML>
<HEAD>
<META name="VI60_DefaultClientScript" Content="VBScript">
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/THEME.CSS" VI6.0THEME="Expedition">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/GRAPH0.CSS" VI6.0THEME="Expedition">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/COLOR0.CSS" VI6.0THEME="Expedition">
<LINK REL="stylesheet" TYPE="text/css" HREF="_Themes/expeditn/CUSTOM.CSS" VI6.0THEME="Expedition"></HEAD>
<BODY>
<%
DIM RYBH,strMC
RYBH = Session("rybh")
dim objConn,objRs,strSQL
set objConn = Server.CreateObject ("adodb.Connection") '建立数据连接对象
set objRs = Server.CreateObject ("adodb.recordset")'建立记录集对象
objRs.CursorLocation =3
objRs.CursorType =3
objConn.open strConn
strsql= "SELECT C.*,B.RYBH, b.xm,d.mc FROM RECORD C, RYXX B,zdcs d WHERE B.RYBH='"&rybh&"' and c.kh=b.kh and c.jh=d.jh and d.mc like '%"&Request.Form ("sbmc")&"%' "'搜索满足条件的记录
objRs.Open strsql,strConn ,3,3 '打开记录集
Session("mc")=objRs("mc")
objRs.PageSize = 5 '设8笔记录为一页
if not IsEmpty(request("ToPage")) then
ToPage = CInt(request("ToPage"))
if ToPage > objRs.PageCount then
objRs.AbsolutePage =objRs.PageCount
else if ToPage<=0 then
objRs.AbsolutePage = 1
else
objRs.AbsolutePage = ToPage
end if
end if
end if
intPage = objRs.AbsolutePage'取出目前所指向的页码
%>
<A href = "yjjlsql.asp">
<FONT color=#3366ff face=宋体 size=5><STRONG>返回上一级</STRONG></FONT></a>
<p><P align=center><FONT color=#cc3333 face=宋体 size=5><STRONG>目前在第<% = intpage%>页,共有<% = objRs.PageCount %>页<%=objRs.RecordCount %>笔记录</STRONG></FONT>
<hr></p>
<p></p>
<TABLE width="100%" BGCOLOR=#cccccc BORDERCOLOR=#006666 BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR>
<TD><b>姓名</b></TD>
<TD><b>用户编号</b></TD>
<TD><b>卡号</b></TD>
<TD><b>帐户号</b></TD>
<TD><b>设备名称</b></TD>
<TD><b>开机日期</b></TD>
<TD><b>关机日期</b></TD>
<TD><b>用机金额</b></TD>
<TD><b>结算日期</b></TD>
</TR>
<%
for i=1 to objRs.PageSize
IF objRs.EOF then
exit for
End If
rem While Not objRs.EOF
%>
<TR>
<TD><%=objRs("xm")%></TD>
<TD><%=objRs("rybh")%></TD>
<TD><%=objRs("kh")%></TD>
<TD><%=objRs("zhh")%></TD>
<TD><%=objRs("mc")%></TD>
<TD><%=objRs("kjrq")%></TD>
<TD><%=objRs("gjrq")%></TD>
<TD><%=objRs("yjje")%></TD>
<TD><%=objRs("jsrq")%></TD>
</TR>
<% objRs.MoveNext
%>
<%next%>
</TABLE>
<TABLE>
<TR VALIGN = BASELINE ALIGN = CENTER>
<%
if intpage<>1 then
%>
<TD WIDTH = 150>
<A Href = yjjlsql1.asp?ToPage=<%=1%>&b.rybh="<%=session("rybh")%>"&c.kh="&b.kh&"&c.jh="&d.jh&"&d.mc="<%=session("mc") %>">到第一页</a>
</td>
<TD WIDTH = 150>
<A Href = yjjlsql1.asp?ToPage=<%=intpage - 1%>&b.rybh="<%=session("rybh")%>"&c.kh="&b.kh&"&c.jh="&d.jh&"&d.mc="<%=session("mc") %>">到上一页</a>
</td>
<%
end if
if intPage<>objRs.PageCount then
%>
<TD WIDTH = 150>
<A Href = yjjlsql1.asp?ToPage=<%=intpage+1%>&d.mc="<%=session("mc") %>"&b.rybh="<%=session("rybh")%>"&c.kh="&b.kh&"&c.jh="&d.jh&">到下一页</a>
</td>
<TD WIDTH = 150>
<A Href = yjjlsql1.asp?ToPage=<%=objRs.PageCount %>&b.rybh="<%=session("rybh")%>"&c.kh="&b.kh&"&c.jh="&d.jh&"&d.mc="<%=session("mc")%>">到最后一页</a>
</td>
<%
end if
%>
<TD WIDTH = 150>
<form action=yjjlsql1.asp method = post id=form1 name=form1>
<FONT color=#cc3333 face=宋体 size=3><STRONG> 到第
<input type="text" name = ToPage style ="height:25px;width:20px" value=<% = intpage%>>页</STRONG></FONT>
</td></tr>
</table>
</form>
<%
objRs.Close
objConn.Close
set objRs=Nothing
set objConn=nothing
%>
</BODY>
</HTML>