请问有谁知道Oracle+ASP怎么实现分页功能啊！急！急！

[wyp0623]

Oracle 不支持recordcount
该怎么实现分页呢

[rebornman]

关注

[wauo]

UP~~~~~~~~~~~~~

[skyfzx]

用SQL分页吧
<%
StartRe=10
EndRe =30

tmpSQL="SELECT id,* FROM qymcyhz WHERE id IN ( SELECT id FROM (SELECT ROWNUM AS NUMROW, id FROM qymcyhz WHERE name is not null and time<=SYSDATE and time>SYSDATE-30) WHERE NUMROW > "&StartRe&" AND NUMROW <= "&EndRe&" ) ORDER BY time desc"
%>