search

codegooglecom / easyasp

Automatically exported from code.google.com/p/easyasp
0 stars 0 forks source link

储存过程如果设置每页显示的条数 #56

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Set Rs = Easp.db.GetPageRecord("easp_sp_pager",Array("KeHu", "ID,BizName", 
"ID>100", "ID Desc", "ID", 3))
Dim i : i = 0
While Not rs.Eof And (i<Rs.PageSize)
   '...这里是你的数据循环显示,例如：
    Easp.WC("<li><a href=""Index.asp?id="&rs("id")&""">"&rs("BizName")&"</a></li>")
    i = i + 1
    rs.MoveNext()
Wend

现在每页显示10 条 如何改变显示的条数！

Original issue reported on code.google.com by jzkai...@gmail.com on 21 Jul 2010 at 8:33

GoogleCodeExporter commented 9 years ago 
Easp.db.PageSize = 20
或者
Set Rs = Easp.db.GetPageRecord("easp_sp_pager:20",Array("KeHu", "ID,BizName", 
"ID>100", "ID Desc", "ID", 3))

Original comment by Tainray@gmail.com on 28 Jul 2010 at 2:09