在ASP中从数据库的第6条记录读取记录怎么写？

来源：百度知道 编辑：UC知道 时间：2024/09/22 16:38:26
在ASP中从数据库的第6条记录读取记录怎么写？

<% set rs=server.createobject("adodb.recordset")
sql="select top 5 * from HN_news where kinds=true and class=4 order by id desc"
rs.open sql,conn,1,1
response.Write"<div class='ttcontent' title='网站建设-程序设计-系统开发-创意方案-包装设计-广告制作'>"
response.Write"<div id='ttc1_1'>"
response.Write"<ul class='list3'>"
DO WHILE Not rs.eof
%>
<li><span><%=rs("time")%></span><strong>·</strong><a href="newsdisp.asp?id=<%=rs("id")%>" title="<%=rs("title")%>" target="_blank">
<% = Left(rs("title"),21) %><% if Len(rs("title"))>20 then %>…<% end if %></a></li>

<%
rs.movenext
LOOP
respo

select top 5 * from HN_news where id not in (select top 5 id from HN_news order by id desc) and kinds=true and class=4 order by id desc

不知道对没有？没有条件调试哦，五条记录的

select top 5 * from HN_news where id not in (select top 5 id from HN_news and kinds=true and class=4 order by id desc) and kinds=true and class=4 order by id desc

select top 5 * from HN_news where id not in (select top 5 id from HN_news order by id asc) and kinds=true and class=4 order by id desc

测试通过

rs.move(6)