注册 登录
编程论坛 ASP技术论坛

数据显示问题!有源码

xuanwang 发布于 2009-07-17 14:58, 386 次点击
只有本站会员才能查看附件,请 登录


没有显示查询出来的数据
3 回复
#2
multiple19022009-07-17 15:13
rs.RecordCount是0否?
#3
xuanwang2009-07-17 15:37
不是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不显示,在数据库中都查得到值
#4
aspic2009-07-17 17:47
前面一个能显示后面怎么可能不显示~
1