数据通过查询取出来了,但点下一页,就回到出错页面,不知是什么原因,高分求助
数据取出来了,但现在的又出了新的问题(分页又不对),再帮我看一下是什么原因引起的。
在取出的页面里点“下一页”它说“数据库中没有我想要的记录”但明明有记录。
我把代码粘出来,各位在帮我看看,小弟不胜感激!!!!!!
<!--#include file= "OnePage.fun " -- >
<html >
<title >维修状态查询 </title >
<link rel= "stylesheet " href= "style.css " >
<body topmargin= "0 " leftmargin= "0 " bgcolor= "#83ACCD " >
<div align= "center " >
<TABLE border=0 cellPadding=0 cellSpacing=0 width=850 height= "1 " >
<tr >
<td width= "100% " height= "43 " style= "border: 1 solid #D9F2FF " >
<p align= "center " > <object classid= "clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 " codebase= "http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0 " width= "851 " height= "56 " title= "ht " >
<param name= "movie " value= "image/ht.swf " >
<param name= "quality " value= "high " >
<embed src= "image/ht.swf " quality= "high " pluginspage= "http://www.macromedia.com/go/getflashplayer " type= "application/x-shockwave-flash " width= "851 " height= "55 " >
</object >
</tr >
</table >
</TD > </TR > </TBODY > </TABLE > </TD >
</TR > </TBODY > </center > </TABLE > </TD > </TR >
</TBODY > </TABLE >
<div align= "center " >
<table bgcolor= "#0066CC " width=850 height= "20 " >
<tr >
<td > <p > <font color= "#FFFFFF " >你现在的位置:- > <a href= "../index.htm " >主页 </a >- > <a href= "index.htm " >维修壮态查询 </a > </font > </td > </p >
</tr >
</center >
</table >
</font > </center >
</div >
<%
Jh = Request.form( "jh ")
Xlh = Request.form( "xlh ")
Sxrqstart = Request.form( "sxrqstart ")
Sxrqend = Request.form( "sxrqend ")
Wcrqstart = Request.form( "wcrqstart ")
Wcrqend = Request.form( "wcrqend ")
Fhrqstart = Request.form( "fhrqstart ")
Fhrqend = Request.form( "fhrqend ")
Wxzt = Request.form( "wxzt ")
Sxdw = Request.form( "sxdw ")
dim sql
sql = " SELECT MC,JH,XLH,SXDW,SXRQ,HTH,WCRQ,YDH,FHRQ,WXBZ,CPZT,WXZT FROM Status WHERE SXDW = ' "&Sxdw& "' "
if Jh < > " " then
sql = sql & " And JH Like ' "&Jh& "%' "
end if
if Xlh < > " " then
sql = sql & " And Xlh Like ' "&Xlh& "%' "
end if
if Sxrqstart < > " " then
sql = sql & " And sxrq >= # "&Sxrqstart& "# "
end if
if Sxrqend < > " " then
sql = sql & " And sxrq <= # "&Sxrqend& "# "
end if
if Wcrqstart < > " " then
sql = sql & " And wcrq >= # "&Wcrqstart& "# "
end if
if Wcrqend < > " " then
sql = sql & " And wcrq <= # "&Wcrqend& "# "
end if
if Fhrqstart < > " " then
sql = sql & " And fhrq >= # "&Fhrqstart& "# "
end if
if Fhrqend < > " " then
sql = sql & " And fhrq <= # "&Fhrqend& "# "
end if
if Wxzt < > " " then
sql = sql & " And WXZT Like ' "&Wxzt& "%' "
end if
set cn = Server.CreateObject( "ADODB.Connection ")
set rs = Server.CreateObject( "ADODB.Recordset ")
cn.Open "status "
set rs.ActiveConnection = cn
rs.Open sql,cn,3,1
rs.PageSize = 25
% >
<%
Page = CLng(Request( "Page "))
If Page > rs.PageCount Then Page = rs.PageCount
If Page < 1 Then Page = 1
ShowOnePage rs, Page
% >
<form >
<input type= "textarea " name= "userid " value= " " > " <%=sql% > "
</form >
<DIV ALIGN=right > <P > <HR >
<FORM Action= <%=Myself% > Method=GET >
<%If Page < > 1 Then ' 如果不是位于第一页% >
<A HREF= <%=Myself% >?Page=1&jh= <%=jh% >&xlh= <%=xlh% >&sxrqstart= <%=sxrqstart% >&sxrqend= <%=sxrqend% >&wcrqstart= <%=wcrqstart% >&wcrqend= <%=wcrqend% >&fhrqstart= <%=fhrqstart% >&fhrqend= <%=fhrqend% >&wxzt= <%=wxzt% >&sxdw= <%=sxdw% > >第一页 </A >
<A HREF= <%=Myself% >?Page= <%=(Page-1)% >&jh= <%=jh% >&xlh= <%=xlh% >&sxrqstart= <%=sxrqstart% >&sxrqend= <%=sxrqend% >&wcrqstart= <%=wcrqstart% >&wcrqend= <%=wcrqend% >&fhrqstart= <%=fhrqstart% >&fhrqend= <%=fhrqend% >&wxzt= <%=wxzt% >&sxdw= <%=sxdw% > >上一页 </A >
<%End If
If Page < > rs.PageCount Then ' 如果不是位于最后一页
% >
<A HREF= <%=Myself% >?Page= <%=(Page+1)% >&jh= <%=jh% >&xlh= <%=xlh% >&sxrqstart= <%=sxrqstart% >&sxrqend= <%=sxrqend% >&wcrqstart= <%=wcrqstart% >&wcrqend= <%=wcrqend% >&fhrqstart= <%=fhrqstart% >&fhrqend= <%=fhrqend% >&wxzt= <%=wxzt% >&sxdw= <%=sxdw% > >下一页 </A >
<A HREF= <%=Myself% >?Page= <%=rs.PageCount% >&jh= <%=jh% >&xlh= <%=xlh% >&sxrqstart= <%=sxrqstart% >&sxrqend= <%=sxrqend% >&wcrqstart= <%=wcrqstart% >&wcrqend= <%=wcrqend% >&fhrqstart= <%=fhrqstart% >&fhrqend= <%=fhrqend% >&wxzt= <%=wxzt% >&sxdw= <%=sxdw% > >最后一页 </A >
<%End If% >
<% if page >1 then % >
页次: <FONT COLOR= "Red " > <%=Page% >/ <%=rs.PageCount% > </FONT >
<% else
% >
页次: <FONT COLOR= "Red " > <%=Page% >/ <%=rs.PageCount% > </FONT >
<% end if% >
</FORM >
</body >
</html >