<%
set rs=server.createobject("adodb.recordset")
sql="select * from 123 order by id desc"
rs.open sql,conn,3
rs.pagesize=4
if request("page")<>"" then
  epage=cint(request("page"))
   if epage<1 then epage=1
   if epage>rs.pagecount then epage=rs.pagecount
else
epage=1
end if
rs.absolutepage=epage
%>
..........................
<%
for i=0 to rs.pagesize-1
if rs.bof or rs.eof then exit for
%>
..............................
<%
rs.movenext()
next
%>
..............................
</table>
<p align="center">
<a href="new1.1.asp">首页</a>&nbsp;
<a href="new1.1.asp?page=<%=epage-1%>">前一页</a>&nbsp;
<a href="new1.1.asp?page=<%=epage+1%>">后一页</a>&nbsp;
<a href="new1.1.asp?page=<%=rs.pagecount%>">末页</a>
</p>
<p align="center">现在是第<%=epage%>页一共有<%=rs.pagecount%>页</p>
<%
conn.close()
%>

现在运行起来只显示一条数据 如何修改才能显示出4条数据啊~

<%
set rs=server.createobject("adodb.recordset")
sql="select * from Song_News order by id desc"
rs.open sql,conn,3,1
rs.pagesize=4
if request("page")<>"" then
  epage=cint(request("page"))
   if epage<1 then epage=1
   if epage>rs.pagecount then epage=rs.pagecount
else
epage=1
end if
rs.absolutepage=epage

%>
                <div class="line">                              
    <div class="floatbox">
<div class="line_image">
<a href="new1.3.2.asp?id=<%=rs("id")%>"><img src="../<%=rs("NewsPhoto")%>" alt="Glastasse - Tee - Ficusbl?tter" width="215" height="129" border="0" style="border: 0px  ;" title="<%=rs("NewsTitle")%>" /></a></div>
            <div class="line_content">
<table width="100%">
  <tr>
    <td><h2>
<a href="new1.3.2.asp?id=<%=rs("id")%>"><%if len(trim(rs("NewsTitle")))>15 then
response.write left(trim(rs("NewsTitle")),15)&".."
else
response.write trim(rs("NewsTitle"))
end if%></a></h2>
</td>
  </tr>
  <tr>
    <td><p>
<%if len(trim(rs("NewsContent")))>15 then
response.write left(trim(rs("NewsContent")),100)&".."
else
response.write trim(rs("NewsContent"))
end if%>
</p>
</td>
  </tr>
  <tr>
    <td><a class="button blue small" href="new1.3.2.asp?id=<%=rs("id")%>">查看全文</a></td>
  </tr>
</table>
</div>
</div>
</div>
<%
for i=0 to rs.pagesize-1
if rs.bof or rs.eof then exit for
%>
<%
rs.movenext()
next
%>
</table>
<p align="center">
<a href="new1.1.asp">首页</a>&nbsp;
<a href="new1.1.asp?page=<%=epage-1%>">前一页</a>&nbsp;
<a href="new1.1.asp?page=<%=epage+1%>">后一页</a>&nbsp;
<a href="new1.1.asp?page=<%=rs.pagecount%>">末页</a>
</p>
<p align="center">现在是第<%=epage%>页一共有<%=rs.pagecount%>页</p>
<%
conn.close()
%>

只显示数据库了一条数据~~~