这条SQL分页语句有什么错误?

[txlty]

系统说这句有错误.
--------------------------就是这句--------------------------------------

rs.open "select top 20 * from [infomation] where touserid=("&userid&") and id > (select max(id) from (select top (page-1)*20 id from [infomation] order by id desc)) order by id desc",cn

----------------------------结束-----------------------------------------
注:
infomation为数据表,ID和touserid为数据项,userid为已经获得的数值,page为已经获得的页码

[sxsgssgs]

http://www.pconline.com.cn/pcedu/empolder/wz/asp/0311/248396.html

[Tikyliu]

page=1时会是什么样的结果？我很期待。

[i三千]

这样试试:

rs.open "select top 20 * from [infomation] where touserid="&userid&" and id > (select max(id) from (select top "&(page-1)*20&" id from [infomation] order by id desc) as temp) order by id desc",cn

[i三千]

select top 20 时,注意不能出现select top 0

上边Tikyliu(天外飞仙) 已经提示了.你要提前判断.

[txlty]

谢谢了,给分!!!!!!!!!!!!!!!!!

[txlty]

给不了
谁回复一下

[txlty]

已经可以了:)