Question

ASP 数据库从第七条信息开始读

ASP 数据库从第七条信息开始读 怎么弄啊，谢谢

<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 7 * from news order by id desc"
rs_news.open sqltext4,conn,1,1
%>
我没分了……只有这点

Answer 1

<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select * from news order by id desc"
rs_news.open sqltext4,conn,1,1

rs_news.absoluteposition=7

%>

Answer 2

set rs=server.createobject("adodb.recordset")
sqltext4="select top 7 id from news order by id desc"
rs.open sqltext4,conn,1,1
Sid=0
if Rs.Recordcount>6 Then
Sid=Rs(0)
Else
Response.write"数据库记录不够7跳"
End IF
Rs.Close
IF Sid>0 Then
Sql="Select * From news Where ID>="&Sid

Rs.Open Sql,Conn,1,1
....
End IF

Answer 3

从第七条信息开始读7条？还是从第七条信息开始读剩下所有的？

1、从第七条开始，所以就排除前6条然后取top 7
sqltext4="select top 7 * from news where id not in(select top 6 id from news order by id desc) order by id desc"
或者：
2、同样排除前6条 这次读取剩下所有的
sqltext4="select * from news where id not in(select top 6 id from news order by id desc) order by id desc"