28,390
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
skyfzx 2003-10-31
- 打赏
- 举报
用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"
%>
<%
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"
%>
wauo 2003-10-17
- 打赏
- 举报
UP~~~~~~~~~~~~~
rebornman 2003-10-17
- 打赏
- 举报
关注
