%
if request("newsname")="" then
newsname="公司新闻"
else
newsname=request("newsname")
end if
set rs=server.CreateObject("adodb.recordset")
sql="Select * from new where lei='"&newsname&"' order by time desc"
rs.open sql,conn,1,1
%>
<%
if not rs.eof then
tel=rs.recordcount '总共记录数
shum=20
rs.pagesize=shum '每页显示的条数
maxpage=rs.pagecount '总共页数
requestpage=clng(request("p")) '接收页码
if requestpage="" or requestpage=0 then '当前页为空或者为零时 值为1
requestpage=1
end if
'当前页大于最大页码时 当前页等于最大页码
if requestpage>maxpage then
requestpage=maxpage
end if
'向下移动相应的行数
if not requestpage=1 then
rs.move (requestpage-1)*rs.pagesize
end if
for i=1 to rs.pagesize and not rs.eof
%>