Location:
Search - sqlpa
Search list
Description: 利用SQL语句进行分页,效果极佳。使用示例:
set mypage = new sqlpage
mypage.sql = 执行查询的Sql语句
mypage.orderby = "id desc,date desc"
mypage.pagesize = 20 每页20条
rs.open mypage.newsql,conn,1,1
do while not rs.eof
....
....
Loop
rs.close
mypage.showpage-use SQL for pagination and excellent results. Use examples : set mypage = new sqlpage mypage.sql = implementation Sql query language sentence mypage.orderby = "id desc. date desc "mypage.pagesize page = 20 m 20 rs.open ypage.newsql, conn, 1, while not a do rs.eof .... .... Loop rs.close Azamat age.showpage
Platform: |
Size: 2048 |
Author: 蓝冰 |
Hits: