2.8w+
社区成员
- 主页
怎么循环5条记录？ACCESS
<%
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
%>
请纠正~
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
%>
请纠正~
...全文
请发表友善的回复…
发表回复
bingbingcha 2004-04-09
to : sxsgssgs
你够惨啊。。同情你。。。要是想加的话，你就多发点FAQ吧。。。
to 楼主
set rs=cnn.execute("select top 5 * from sqyn order by time desc")
把这个改上去就行了
你够惨啊。。同情你。。。要是想加的话，你就多发点FAQ吧。。。
to 楼主
set rs=cnn.execute("select top 5 * from sqyn order by time desc")
把这个改上去就行了
sxsgssgs 2004-04-09
我也没什么呀，只是前一段时间没怎么结贴，等我想结贴的时候，
版主已经把我的记录删除了，我没法结贴了。
版主已经把我的记录删除了，我没法结贴了。
bybee 2004-04-09
<%
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
%>
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
%>
Newrocky 2004-04-09
sxsgssgs(晋乡浪子) ( ) 信誉：58 2004-04-09 17:30:00 得分:0
我的信欲什么时候能加上去，要吃补吗。哈哈。
天，你是怎么下来的嘛！！！
TO 楼主
在SQL语句中加TOP 5 就可以了！
然后记得在循环中测试是否文件尾就OK！
我的信欲什么时候能加上去，要吃补吗。哈哈。
天，你是怎么下来的嘛！！！
TO 楼主
在SQL语句中加TOP 5 就可以了！
然后记得在循环中测试是否文件尾就OK！
hermit2003 2004-04-09
<%
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
%>
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
%>
alcoholwang 2004-04-09
<%
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
%>
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
%>
sxsgssgs 2004-04-09
我的信欲什么时候能加上去，要吃补吗。哈哈。
sxsgssgs 2004-04-09
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
%>
改成下边的就对了。
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
%>
FlashK 2004-04-09
While Not rs.EOF
Response.Write rs("biaoti")
rs.MoveNext
Wend
Response.Write rs("biaoti")
rs.MoveNext
Wend