控制FOR循环记录条数

<%
if owen1= "" and owen2= "" then
sql="select * from NEWS order by hits desc"
set rs=conn.execute(sql)
j=1
do while not rs.eof
%>

 

javastr=javastr+"<tr><td height=\"24\" style=\"BORDER-bottom: #999999 1px dotted\">"
javastr=javastr+"◎&nbsp;<span style=\&quot;font-size:9pt;line-height:15pt\"><a href=\"onews.asp?id=<%=rs("id")%>\" title=\"<%=rs("title")%>\" target=\"_blank\"><%=left(rs("title"),9)%></a></span>  <font color=\"#999999\" >(阅读<font color=\"#FF0000\" ><%=rs("hits")%></font>次)</font>"
javastr=javastr+"</td></tr>"
<%

j=j+1
if j>5 then exit do'循环5条记录就跳出循环。

rs.movenext
loop
%>