我刚入门做了个分页为什么去点页码时结果是空的呢?谢谢!先各位朋友指点。
程序代码:
<!-- #include file="conn.asp" --> <% sql="select * from config" set rs_config=conn.execute(sql) biaoji=rs_config("biaoji") '下面一段,打开了这个表,选择了全部的数据 dim rs,sql,page,username username=request.querystring("username") set rs = server.createobject("adodb.recordset") sql = "select * from pc_form where username='"+username+"'order by sqsj desc" rs.open sql,conn,1,1 '设置每页10条 rs.pagesize = 10 '接收page的值 page = request.querystring("page") '把接收到的值赋值给页码即可 rs.absolutepage = page %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title><%=biaoji%>-付款申请-</title> <style type="text/css"> td { font-size: 9pt; line-height: 14pt} a:link {color: #0080FF; text-decoration: none } a:visited {color: #0080FF; text-decoration: none } a:hover {color: #ee9c00; text-decoration: underline } </style> </head> <body bgproperties="fixed" background="images/bg01.gif"> <div align="center"> <center> <table border="0" width="800" cellpadding="0" cellspacing="0" background="images/frist.jpg" style="border-collapse: collapse" bordercolor="#111111" height="120"> <tr> <td width="100%" align="center" valign="middle"><font size="3px" color="red"><%=biaoji%><p>-付款申请-</p></font></td> </tr> </table> </center> </div> <div> <center> <table border="0" width="800" bgcolor="#CACAFF" cellspacing="0" cellpadding="6" style="border:1px dotted #0000FF; border-collapse: collapse; color:#0000FF; background-color:#CACAFF" bordercolor="#111111" height="20"> <tr> <% for i = 1 to rs.pagecount %> <td width="100%" align="right" valign="middle"><a href="pc_list.asp?page=<%=i%>"><%=i%></td> <% next %> </tr> </table> </center> </div> <div id="pc" align="center"> <center> <table border="0" width="800" bgcolor="#CACAFF" cellspacing="0" cellpadding="6" style="border:1px dotted #0000FF; border-collapse: collapse; color:#0000FF; background-color:#CACAFF" bordercolor="#111111"> <tr> <td width="100%"> <% for i=1 to rs.pagesize if rs.eof then exit for '最后一页不足10条,所以,循环到没有数据,就中途退出 %> <table border="0" width="100%" cellpadding="0" style="border-collapse: collapse; border: 1px dotted #A4A4FF" bordercolor="#111111" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="61" rowspan="13" align="right"><!--DWLayoutEmptyCell--> </td> <td width="49" align="right"><!--DWLayoutEmptyCell--> </td> <td align="right"><!--DWLayoutEmptyCell--> </td> <td width="137" align="right"><!--DWLayoutEmptyCell--> </td> <td align="right"><!--DWLayoutEmptyCell--> </td> <td colspan="3" align="right"><!--DWLayoutEmptyCell--> </td> <td width="81" align="right"><!--DWLayoutEmptyCell--> </td> <td width="68" rowspan="13" align="right"><!--DWLayoutEmptyCell--> </td> </tr> <tr> <td align="right"><!--DWLayoutEmptyCell--> </td> <td align="right"><!--DWLayoutEmptyCell--> </td> <td colspan="2" align="center"><%=biaoji%> </td> <td colspan="3" align="right"><!--DWLayoutEmptyCell--> </td> <td align="right"><!--DWLayoutEmptyCell--> </td> </tr> <tr> <td align="right"><!--DWLayoutEmptyCell--> </td> <td align="right"><!--DWLayoutEmptyCell--> </td> <td colspan="2" rowspan="2" align="center">现金支出(费用报销)单</td> <td colspan="3" align="right">部 门:</td> <td align="left"><%=rs("bm")%></td> </tr> <tr> <td height="18" align="right"><!--DWLayoutEmptyCell--> </td> <td align="right"><!--DWLayoutEmptyCell--> </td> <td colspan="3" align="right" valign="top">报帐人:</td> <td align="left"><%=rs("username")%></td> </tr> <tr> <td height="18" align="right"><!--DWLayoutEmptyCell--> </td> <td width="15" align="right"><font color="#225ccc"></td> <td align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td width="279" align="right"><!--DWLayoutEmptyCell--> </td> <td colspan="3" align="right"><font color="#225ccc">送达日:</td> <td align="left"><%=rs("sqsj")%></td> </tr> <tr> <td height="10" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td height="10" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td height="10" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td height="10" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td width="66" height="16" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td width="14" height="16" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td height="10" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> <td height="10" align="right" valign="top"><!--DWLayoutEmptyCell--> </td> </tr> <tr> <td rowspan="4" align="center" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">事由<font color="#225ccc"></td> <td width="15" height="20" align="center" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">1</td> <td colspan="4" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=rs("sy01")%></td> <td width="14" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">¥:</td> <td align="right" valign="top" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=FormatNumber(rs("je01"))%></td> </tr> <tr> <td width="15" align="center" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">2</td> <td colspan="4" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=rs("sy02")%></td> <td align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">¥:</td> <td align="right" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=FormatNumber(rs("je02"))%></td> </tr> <tr> <td width="15" align="center" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">3</td> <td colspan="4" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=rs("sy03")%></td> <td align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">¥:</td> <td align="right" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=FormatNumber(rs("je03"))%></td> </tr> <tr> <td width="15" align="center" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">4</td> <td colspan="4" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=rs("sy04")%></td> <td align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">¥:</td> <td align="right" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"><%=FormatNumber(rs("je04"))%></td> </tr> <tr> <td colspan="8" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">合计金额(大写)¥: </td> </tr> <tr> <td colspan="2" align="center" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF">备注:</td> <td colspan="6" align="left" style="color: #0066FF; border: 1px dotted #0000FF; background-color: #CACAFF"> <h1> </h1></td> </tr> <tr> <td height="16" colspan="8" align="left" valign="top"><!--DWLayoutEmptyCell--> </td> </tr> </table> <% rs.movenext next %> </td> </tr> </table> </center> </div> <div align="center"> <center> <table border="0" width="800" cellpadding="0" bgcolor="#CACAFF" style="border:1px dotted #808000; border-collapse: collapse; background-color:#CACAFF" bordercolor="#111111" cellspacing="0"> <tr> <td width="100%" bgcolor="#ebebeb" height="2"></td> </tr> <tr> <td width="100%"> </td> </tr> <tr> <td width="100%"> <p align="center"><font color="#0066FF">--<%=biaoji%>--</font></td> </tr> </table> </center> </div> </body> </html>由上一页面地址栏传递过来的信息是http://localhost/my_system/pc_list.asp?username=123