怎么循环5条记录？ACCESS

[mearymeng]

<%
set rs=cnn.execute("select * from sqyn order by time desc")

for i=0 to 4

if not rs.eof then

response.Write rs("biaoti")

exit for

end if

%>
请纠正~

[FlashK]

While Not rs.EOF
Response.Write rs("biaoti")
rs.MoveNext
Wend

[sxsgssgs]

set rs=cnn.execute("select * from sqyn order by time desc")
改成下边的就对了。

set rst=server.createobject("ADODB.Recordset")
strSQL = "select * from sqyn order by time desc"

rst.Open strSQL,conn,1,1

for i=0 to 4

if rs.eof then exit for

response.Write rs("biaoti")
rs.movenext
next
%>

[sxsgssgs]

我的信欲什么时候能加上去，要吃补吗。哈哈。

[alcoholwang]

<%
set rs=cnn.execute("select * from sqyn order by time desc")
if not rs.eof or not rs.bof then
do while not rs.eof
response.Write rs("biaoti")
loop
end if
rs.close
set rs=nothing
%>

[hermit2003]

<%
set rs=cnn.execute("select top 5 * from sqyn order by time desc")

do while not rs.eof
response.Write rs("biaoti")
rs.movenext
loop
%>

[Newrocky]

sxsgssgs(晋乡浪子) ( ) 信誉：58 2004-04-09 17:30:00 得分:0


我的信欲什么时候能加上去，要吃补吗。哈哈。


天，你是怎么下来的嘛！！！

TO 楼主

在SQL语句中加TOP 5 就可以了！

然后记得在循环中测试是否文件尾就OK！

[bybee]

<%
set rs=cnn.execute("select top 5 * from sqyn order by time desc")

do while not rs.eof
response.Write rs("biaoti")&"<br>"
rs.movenext
loop
%>

[sxsgssgs]

我也没什么呀，只是前一段时间没怎么结贴，等我想结贴的时候，
版主已经把我的记录删除了，我没法结贴了。

[bingbingcha]

to : sxsgssgs

你够惨啊。。同情你。。。要是想加的话，你就多发点FAQ吧。。。

to 楼主

set rs=cnn.execute("select top 5 * from sqyn order by time desc")

把这个改上去就行了