高手赐教--有关分页问题,为什么这样写不对?
<%
dim rs,rs1,sql1
set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM news where class_num='"&class_num&"' ORDER BY webdate DESC"
'response.write sql
rs.open sql, conn, 1, 1
if rs.eof and rs.bof then
response.write "<br><font size=2>没有相关资讯内容</font>"
jjpage=1
else
dim curpage, i
if request("page")="" then
curpage = 1
else
curpage = cint(request("page"))
end if
rs.pagesize = 15
rs.absolutepage = curpage
for i = 1 to rs.pagesize
%>
<tr>
<td width="5%"> </td>
<td width="4%"><img src="images/news_page.gif" width="10" height="10"></div></td>
<td width="91%" height="30"><a href="news_view.asp?id=<%=rs("id")%>"><%=rs("title")%></a> <font color="#999999">(<%=rs("webdate")%>)</font><SPAN id=Label1>
<%if rs("webdate")>date()-7 then%>
<img src="images/news_new.gif" width="28" height="11">
<%end if%>
</SPAN></td>
</tr><% rs.movenext
if rs.eof then
i = i + 1
exit for
end if
next
end if%>
</table> </td>
</tr>
<tr>
<td height="20" colspan="3"> </td>
</tr>
<tr>
<td colspan="3"><div align="right">
<%if jjpage<>1 then
response.write "本页" + cstr(i-1) + "条/总" + cstr(rs.recordcount) + "条 "
if curpage = 1 then
response.write "首页 前页 "
else
response.write "<a href='news_more.asp?class_num="&strclass&"&page=1'>首页</a> <a href='news_more.asp?class_num="&strclass&"&page=" + cstr(curpage-1) + "'>前页</a> "
end if
if curpage = rs.pagecount then
response.write "后页 末页"
else
response.write "<a href='news_more.asp?class_num="&strclass&"&page=" + cstr(curpage+1) + "'>后页</a> <a href='news_more.asp?class_num="&strclass&"&page=" + cstr(rs.pagecount) + "'>末页</a>"
end if
End If
rs.close
%>
dim rs,rs1,sql1
set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM news where class_num='"&class_num&"' ORDER BY webdate DESC"
'response.write sql
rs.open sql, conn, 1, 1
if rs.eof and rs.bof then
response.write "<br><font size=2>没有相关资讯内容</font>"
jjpage=1
else
dim curpage, i
if request("page")="" then
curpage = 1
else
curpage = cint(request("page"))
end if
rs.pagesize = 15
rs.absolutepage = curpage
for i = 1 to rs.pagesize
%>
<tr>
<td width="5%"> </td>
<td width="4%"><img src="images/news_page.gif" width="10" height="10"></div></td>
<td width="91%" height="30"><a href="news_view.asp?id=<%=rs("id")%>"><%=rs("title")%></a> <font color="#999999">(<%=rs("webdate")%>)</font><SPAN id=Label1>
<%if rs("webdate")>date()-7 then%>
<img src="images/news_new.gif" width="28" height="11">
<%end if%>
</SPAN></td>
</tr><% rs.movenext
if rs.eof then
i = i + 1
exit for
end if
next
end if%>
</table> </td>
</tr>
<tr>
<td height="20" colspan="3"> </td>
</tr>
<tr>
<td colspan="3"><div align="right">
<%if jjpage<>1 then
response.write "本页" + cstr(i-1) + "条/总" + cstr(rs.recordcount) + "条 "
if curpage = 1 then
response.write "首页 前页 "
else
response.write "<a href='news_more.asp?class_num="&strclass&"&page=1'>首页</a> <a href='news_more.asp?class_num="&strclass&"&page=" + cstr(curpage-1) + "'>前页</a> "
end if
if curpage = rs.pagecount then
response.write "后页 末页"
else
response.write "<a href='news_more.asp?class_num="&strclass&"&page=" + cstr(curpage+1) + "'>后页</a> <a href='news_more.asp?class_num="&strclass&"&page=" + cstr(rs.pagecount) + "'>末页</a>"
end if
End If
rs.close
%>
...全文
相关推荐
关于UICollectionView横向滑动分页的问题
关于UICollectionView的contentSize为什么不起作用
自己写的分页控件
自己写的分页控件,数据在前端缓存。代码中还有很多很多不足甚至是BUG,望不吝赐教。
mybatis 分页自己写的一个分页
物理分页查询 只需要传 开始页数和每页多少条数据 到实体类 然后在sql语句中写分页参数就可以使用了
自己写的分页 支持首页末页下一页上一页
看到有人问分页的问题,就写了一个,其实如果嫌自己写分页麻烦,完全可以用bootstrap分页,当然,如果你不想用插件,也可以自己写,这是我写的分页,分享给大家
PageHelper插件实现一对多查询时的分页问题
主要介绍了PageHelper插件实现一对多查询时的分页问题,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧


