ASP+Access判断记录集为空.

Question

<%
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from b1 order by id desc ",conn%> <%Do Until rs.eof%><%=rs("username")%><%=rs("mail")%><%rs.movenext
loop
rs.close
conn.close
set rs=nothing
set conn=nothing
%> 当username,mail其中一个字段为空,就不能正常显示了.请问高手怎么解决?在本代码上怎么改?

Answer 1

在sql语句中判断username和mail的值是否为空，为空的就不读去他，代码如下set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from b1 where username<>"" and mail<>"" order by id desc ",conn,1,1
Do Until rs.eof
response.write(rs("username"))
response.Write(rs("mail"))
rs.movenext
loop
rs.close
conn.close

Answer 2

<%
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from b1 order by id desc ",connDo while not rs.eof%><%=rs("username")%><%=rs("mail")%><%rs.movenext
loop
rs.close
conn.close
set rs=nothing
set conn=nothing
%> 字段为空的话 你可以做个判断 显示为别的

Answer 3

加入if判断记录集是否为空 如下：rs.Open "select * from b1 order by id desc ",connif rs.eof thenresponse.write “赞无记录"elseDo Until rs.eof%><%=rs("username")%><%=rs("mail")%><%rs.movenext
loopend if
rs.close
conn.close
set rs=nothing
set conn=nothing

Answer 4

怎么个不正常法？截个图看看呀。