asp rs.movenext不管用

[露珠111]

<%set rs=server.CreateObject("Adodb.recordset")

rs.open "select * from zs_news where m_classid="&classid&" order by m_id desc",conn,1,1

rs.movenext'这行为什么不管用呢？去了这行能显示本条记录，但是加上不能显示下条记录

response.write(rs("m_classid"))


rs.close

%>
请教高手指点

[灬上海爽爷]

<%set rs=server.CreateObject("Adodb.recordset")

rs.open "select * from zs_news where m_classid="&classid&" order by m_id desc",conn,1,1

if not rs.eof then
rs.movenext
if not rs.eof then response.write(rs("m_classid"))
end if
rs.close

%>


试试吧

[hookee]

<%
set rs = CreateObject("Adodb.recordset") 
rs.CursorLocation = 3
rs.Open "select * from zs_news where m_classid=" & classid & " order by m_id desc", conn, 1, 1
Response.Write "记录数:" & rs.RecordCount
Do While not rs.EOF
  response.write rs("m_classid")
  rs.MoveNext
Loop
rs.Close
conn.Close
%> 

[in0512]

rs.movenext要和

do while not rs.eof
....
rs.movenext
loop

或者

while not rs.eop
...
rs.movenext
wend

一起使用

[in0512]

上面不是rs.eop,是rs.eof

[liuwei_IT_love]

与
do while not rs.eof
连用试试
rs.movenext
loop

[tfpeixun]

要判断一下是否为空三。

[sumjor]

<%
set rs=server.CreateObject("Adodb.recordset") 
rs.open "select * from zs_news where m_classid="&classid&"  order by m_id desc",conn,1,1 
do whiel not rs.eof 
response.write(rs("m_classid")) 
rs.movenext
loop
rs.close 
set rs=nothing
%> 

[露珠111]

谢谢各位指点，我主要是只想显示下一条记录，其他都不显示，循环的话要都显示才行的啊？？

<%
set rs=server.CreateObject("Adodb.recordset")
rs.open "select * from zs_news where m_classid="&classid&" order by m_id desc",conn,1,1
do whiel not rs.eof
response.write(rs("m_classid"))
rs.movenext
loop
rs.close
set rs=nothing
%>
怎么能只显示下一条记录呢？

[hookee]

要确保有2条记录才可以
If Not(rs.EOF And rs.BOF) Then
Response.Write rs("xx")
If rs.RecordCount>1 Then
rs.MoveNext
Response.Write rs("xx")
End If
End If

[灬上海爽爷]

<%
set rs=server.CreateObject("Adodb.recordset")
rs.open "select top 2 * from zs_news where m_classid="&classid&" order by m_id desc",conn,1,1
do while not rs.eof
response.write(rs("m_classid"))
rs.movenext
loop
rs.close
set rs=nothing
%>

[露珠111]

还是只能显示本条，不能显示下一条，我想只显示下一条，哎！麻烦各位了！

[zzhqiao]

<%
set rs=server.CreateObject("Adodb.recordset")
rs.open "select top 2 * from zs_news where m_classid="&classid&" order by m_id desc",conn,1,1
while not rs.eof
rs.movenext
response.write(rs("m_classid"))
wend
rs.close
set rs=nothing %>