Question

asp代码如何控制显示的记录数

<%
set rs=server.createobject("adodb.recordset")
sql="select* from news where shenhe=true order by NewsID desc"
rs.open sql,conn,1,1
do while not rs.eof
response.write "<img src=images/addani.gif><a href=news/newscontent.asp?id="+Cstr(rs("NewsID"))&" title="&rs("otitle")&" target=_self>"
if len(rs("otitle"))>14 then
response.write left(rs("otitle"),12)&"..."
else
response.write rs("otitle")
end if
response.write "</a> <span style=""FONT: 10px , Verdana"">[加入日期："&rs("odate")&"]</span>"
if rs("odate")+2>=DateValue(date) then
response.write " <img src=images/new01.gif>"
end if
response.write"<br>"
rs.movenext
loop
rs.close
%>
要求显示6条记录

Answer 1

sql="select* from news where shenhe=true order by NewsID desc"

改为

sql="select top 6 * from news where shenhe=true order by NewsID desc"

或者在while里面加个循环的控制，输出6条记录后退出循环就可以了，不过比较推荐第一种做法，速度较快点

Answer 2

把这个
sql="select* from news where shenhe=true order by NewsID desc"
改成
sql="select top 6 from news where shenhe=true order by NewsID desc"