咋没记录

七彩焰阳

1. <!--#include file=conn.asp-->
   
2. <table width="250" border="0" align="center" cellpadding="0" cellspacing="2" class="border">
   
3. <%
   
4. page=clng(request("page"))
   
5. Set rs=Server.CreateObject("ADODB.RecordSet")
   
6. sql="select username,epointnum from TTM_UserEX"
   
7. rs.Open sql,conn,1,3
   
8. if rs.eof and rs.bof then
   
9. response.Write("暂时没有记录")
   
10. else
    
11. 
    
12. rs.PageSize=20
    
13. if page=0 then page=1
    
14. pages=rs.pagecount
    
15. if page > pages then page=pages
    
16. rs.AbsolutePage=page
    
17. for j=1 to rs.PageSize
    
18. %>
    
19. 
    
20. <tr>
    
21. <td width="150" height="22" align="left"><%=rs("UserName")%></td>
    
22. <td width="100" height="22" align="left"><%=rs("epointnum")%></td>
    
23. </tr>
    
24. <%
    
25. rs.movenext
    
26. if rs.eof then exit for
    
27. next
    
28. %>
    
29. <tr valign="bottom">
    
30. <td height="50" colspan="3" align="center" >
    
31. <form method=Post action="?">
    
32. <%if Page<2 then
    
33. response.write "首页 上一页 "
    
34. else
    
35. response.write "<a href=?page=1>首页</a> "
    
36. response.write "<a href=?page=" & Page-1 & ">上一页</a> "
    
37. end if
    
38. if rs.pagecount-page<1 then
    
39. response.write "下一页 尾页"
    
40. else
    
41. response.write "<a href=?page=" & (page+1) & ">"
    
42. response.write "下一页</a> <a href=?page="&rs.pagecount&">尾页</a>"
    
43. end if
    
44. response.write " 页次：<strong><font color=red>"&Page&"</font>/"&rs.pagecount&"</strong>页 "
    
45. response.write " 共<b><font color='#FF0000'>"&rs.recordcount&"</font></b>条记录 <b>"&rs.pagesize&"</b>条记录/页"
    
46. response.write " 转到：<input type='text' name='page' size=4 maxlength=10 class=input value="&page&">"
    
47. response.write " <input class=input type='submit' value=' Goto ' name='cndok'></span></p>"
    
48. %>
    
49. </form> </td>
    
50. 
    
51. </tr>
    
52. <%
    
53. end if
    
54. rs.close
    
55. set rs=nothing
    
56. %>
    
57. </table>

复制代码

七彩焰阳

想要读取TTM_UserEX表中的UserName和epointnum字段中的信息
分页显示，每页显示20条记录   
顺序按照epointnum字段的值由大到小排列
数据库采用的是SQL 2005

七彩焰阳

提示   暂时没有记录
   什么原因？