请问为什么不能实现翻页功能?请高手赐教
ymeik 2003-09-16 05:57:21 点击“下一页”的时候,也面刷不开。
代码如下:
<%
dim using ,sel,name,no
sel=trim(request("select"))
name=trim(request("selname"))
using=Session("ThisUser") 'using 当前用户的真实姓名
'response.write using&"<br>"
Set ObjRs = server.CreateObject("ADODB.RecordSet")
if sel="按工程负责人" then
no=1
SqlUser="Select ID,ReportTime,ReportComp,State From ReportAndSolve Where Engineer like '%"&name&"%' Order by ReportTime desc"
elseif sel="按投诉单位" then
no=2
SqlUser="Select ID,ReportTime,ReportComp,State From ReportAndSolve Where ReportComp like '%"&name&"%' Order by ReportTime desc"
end if
ObjRs.open SqlUser,MyConn,3,3
if not ObjRs.eof then
ObjRs.pagesize=15
nextpage=request.form("nextpage")
if nextpage="" then
session("abspage")=1
else
if nextpage="上一页" then
session("abspage")=session("abspage")-1
elseif nextpage="下一页" then
session("abspage")=session("abspage")+1
end if
ObjRs.absolutepage=session("abspage")
end if
%>
<right>
<form action=repsearch2.asp method=post>
<%
if ObjRs.pagecount>1 then
if (session("abspage"))>1 then
%>
<input type=submit value=上一页 name=nextpage style="color: rgb(255,255,0); font-size: 9pt; background-color: rgb(0,128,128)">
<%
end if
if (session("abspage"))<ObjRs.pagecount then
%>
<input type=submit value=下一页 name=nextpage style="color: rgb(255,255,0); font-size: 9pt; background-color: rgb(0,128,128)">
<%
end if
end if
%>
<font color="#009933"> 这是第<%=session("abspage")%>页 共<%=ObjRs.pagecount%>页
</font>
<%
response.write"</tr>"
%>
<font color="#009933"> <%=ObjRs.recordcount%>条记录</font>
</form>
我觉得可能是sel的判断那部分引起翻页不成功,不知道对否,该如何解决呢?