没有显示查询出来的数据

rs.RecordCount是0否？

不是0<%
        set rs = Server.CreateObject("ADODB.RecordSet")
        dim strSql
        strSql="select count(*) as number,st.studykind as studykinds,fdz.fdzname as fdznames,sum(case when signstate=0 then 1 else 0 end) as internet,sum(case when signstate=1 then 1 else 0 end) as paper"
        strSql=strSql+" from stusignsys as stu,fdzlist as fdz,studykindlist as st"
        strSql=strSql+" where stu.studykindID=st.studykindID"
        strSql=strSql+" and fdz.fdzname='" & fdzname & "' and stu.stu_level='" & stu_level & "' and stu.signdate between '" & SYear & "' and '" & EYear & "'"
        strSql=strSql+" group by st.studykind,fdz.fdzname"      
      rs.Open strSql,conn,1,1
%>

<tr>   
    <%do while not rs.eof %>
    <td style="width: 95px"> <%=rs("fdznames") %> </td>
    <td> <%=rs("number") %> </td>  
    <td> <%=rs("internet") %> </td>
    <td> <%=rs("paper") %> </td>
    <td style="width: 82px"> <%=rs("number") %> </td>
    <td style="width: 77px"> <%=rs("number") %> </td>
    <td style="width: 81px"> <%=rs("number") %> </td>
    <td style="width: 69px"> <%=rs("number") %> </td>
    <td style="width: 68px"> <%=rs("number") %> </td>
    <%
          rs.MoveNext
      loop
    %>
就是后面的number不显示，在数据库中都查得到值

前面一个能显示后面怎么可能不显示~