利用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