日期:2014-05-19  浏览次数:20466 次

查询的问题
mdbsql   =   "select   top   "&Page_size& "   *   from   table   where   id   <   (select   min   (id)   from   (select   top   "&(currentPage-1)*Page_size& "   id   from   table   order   by   id   desc)   as   T)   order   by   id   desc "

这样能正常显示
问题是当我要用日期排序

mdbsql   =   "select   top   "&Page_size& "   *   from   table   where   id   <   (select   min   (id)   from   (select   top   "&(currentPage-1)*Page_size& "   id   from   table   order   by   date   desc)   as   T)   order   by   date   desc "

就会少了很多条结果
不明白为什么

------解决方案--------------------
看上去,好像是分页码