28,391
社区成员
发帖
与我相关
我的任务
分享请教asp问题！
strSql="select count(*),st.studykind,fdz.fdzname,signstate0=sum(case when signstate=0 then 1 else 0
end),signstate1=sum(case when signstate=1 then 1 else 0 end) "
strSql=strSql+" from stusignsys as stu,fdzlist as fdz,studykindlist as st"
strSql=strSql+" where stu.studykindID=st.studykindID and stu.fdzid=fdz.fdzid"
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"
该语句的查询的是某几个字段的个数
根据这条sql语句，怎样将查询结果用asp代码显示在表格中？
end),signstate1=sum(case when signstate=1 then 1 else 0 end) "
strSql=strSql+" from stusignsys as stu,fdzlist as fdz,studykindlist as st"
strSql=strSql+" where stu.studykindID=st.studykindID and stu.fdzid=fdz.fdzid"
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"
该语句的查询的是某几个字段的个数
根据这条sql语句，怎样将查询结果用asp代码显示在表格中？
...全文
请发表友善的回复…
发表回复
王者coco 2009-07-17
- 打赏
- 举报
没的数据显示，不知道代码哪有问题，以下是部分代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>招生报名信息统计</title>
<script type="text/javascript">
</script>
</head>
<body>
<div style="background:#CCFFFF;text-align:center;">
<div style="text-align:center"><b>招生报名信息统计<br /></b>
<form name="form1" method="post" action="">
统计范围：<label id="lblRange"><%=range %></label>
<br />
入学年级：<label id="lblStu_level"><%=stu_level %></label> <br />
报名时间：<label id="lblSYear"><%=sYear%>-</label>
<label id="lblSMonth"><%=sMonth%>-</label>
<label id="lblSDay"><%=sDay%>~</label>
<label id="lblEYear"><%=eYear%>-</label>
<label id="lblEMonth"><%=eMonth%>-</label>
<label id="lblEDay"><%=eDay%></label>
<table border="1" style="width: 919px; height: 294px">
<tr>
<td width="27" rowspan="2">序号</td>
<td rowspan="2" style="width: 95px">教学服务站</td>
<td height="26" colspan="8">
学历教育报名人数</td>
<td colspan="5">
非学历教育报名人数</td>
<td rowspan="2" style="width: 25px">总计</td>
<td rowspan="2" style="width: 26px">网上</td>
<td rowspan="2" style="width: 21px">纸介</td>
</tr>
<tr bgcolor="#66CCFF">
<td width="22" height="62">合计</td>
<td width="25">网上</td>
<td width="22">纸介</td>
<td style="width: 82px"><p>高中起点</p>
<p> 专科</p></td>
<td style="width: 77px"><p>高中起点</p>
<p>
本科</p></td>
<td style="width: 81px"><p>专科起点</p>
<p>
本科</p></td>
<td style="width: 69px">
专科第二<br />
<br />
学历</td>
<td style="width: 68px"><p>本科第二</p>
<p>
学历</p></td>
<td style="width: 27px">合计</td>
<td width="24">网上</td>
<td width="21">纸介</td>
<td style="width: 34px">
单科<br />
<br />
选修</td>
<td width="34"><p>专业</p>
<p>进修</p></td>
</tr>
<%
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 and stu.fdzid=fdz.fdzid"
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>
<%for i=1 to rs.RecordCount %>
<td><%=i %></td>
<%next %>
<%do while not rs.eof %>
<td style="width: 95px"><%=rs("fdznames") %></td>
<td><%=rs("") %></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>
<td style="width: 27px"><%= %></td>
<td><%=rs("number") %></td>
<td><%=rs("number") %></td>
<td style="width: 34px"><%=rs("number") %></td>
<td><%=rs("number") %></td>
<td style="width: 25px"><%= %></td>
<td style="width: 26px"><%= %></td>
<td style="width: 21px"><%= %></td>
<%
rs.MoveNext
loop
%>
</tr>
<tr>
<td colspan="2">
合计</td>
<td>1</td>
<td>1</td>
<td>1</td>
<td style="width: 82px">1</td>
<td style="width: 77px">1</td>
<td style="width: 81px">1</td>
<td style="width: 69px">1</td>
<td style="width: 68px">1</td>
<td style="width: 27px">1</td>
<td>1</td>
<td>1</td>
<td style="width: 34px">1</td>
<td>1</td>
<td style="width: 25px">1</td>
<td style="width: 26px">1</td>
<td style="width: 21px">1</td>
</tr>
</table>
</form>
</div>
</div>
<br />
<br />
<center><a href="StatOne.asp">继续统计</a></center>
</body>
</html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>招生报名信息统计</title>
<script type="text/javascript">
</script>
</head>
<body>
<div style="background:#CCFFFF;text-align:center;">
<div style="text-align:center"><b>招生报名信息统计<br /></b>
<form name="form1" method="post" action="">
统计范围：<label id="lblRange"><%=range %></label>
<br />
入学年级：<label id="lblStu_level"><%=stu_level %></label> <br />
报名时间：<label id="lblSYear"><%=sYear%>-</label>
<label id="lblSMonth"><%=sMonth%>-</label>
<label id="lblSDay"><%=sDay%>~</label>
<label id="lblEYear"><%=eYear%>-</label>
<label id="lblEMonth"><%=eMonth%>-</label>
<label id="lblEDay"><%=eDay%></label>
<table border="1" style="width: 919px; height: 294px">
<tr>
<td width="27" rowspan="2">序号</td>
<td rowspan="2" style="width: 95px">教学服务站</td>
<td height="26" colspan="8">
学历教育报名人数</td>
<td colspan="5">
非学历教育报名人数</td>
<td rowspan="2" style="width: 25px">总计</td>
<td rowspan="2" style="width: 26px">网上</td>
<td rowspan="2" style="width: 21px">纸介</td>
</tr>
<tr bgcolor="#66CCFF">
<td width="22" height="62">合计</td>
<td width="25">网上</td>
<td width="22">纸介</td>
<td style="width: 82px"><p>高中起点</p>
<p> 专科</p></td>
<td style="width: 77px"><p>高中起点</p>
<p>
本科</p></td>
<td style="width: 81px"><p>专科起点</p>
<p>
本科</p></td>
<td style="width: 69px">
专科第二<br />
<br />
学历</td>
<td style="width: 68px"><p>本科第二</p>
<p>
学历</p></td>
<td style="width: 27px">合计</td>
<td width="24">网上</td>
<td width="21">纸介</td>
<td style="width: 34px">
单科<br />
<br />
选修</td>
<td width="34"><p>专业</p>
<p>进修</p></td>
</tr>
<%
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 and stu.fdzid=fdz.fdzid"
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>
<%for i=1 to rs.RecordCount %>
<td><%=i %></td>
<%next %>
<%do while not rs.eof %>
<td style="width: 95px"><%=rs("fdznames") %></td>
<td><%=rs("") %></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>
<td style="width: 27px"><%= %></td>
<td><%=rs("number") %></td>
<td><%=rs("number") %></td>
<td style="width: 34px"><%=rs("number") %></td>
<td><%=rs("number") %></td>
<td style="width: 25px"><%= %></td>
<td style="width: 26px"><%= %></td>
<td style="width: 21px"><%= %></td>
<%
rs.MoveNext
loop
%>
</tr>
<tr>
<td colspan="2">
合计</td>
<td>1</td>
<td>1</td>
<td>1</td>
<td style="width: 82px">1</td>
<td style="width: 77px">1</td>
<td style="width: 81px">1</td>
<td style="width: 69px">1</td>
<td style="width: 68px">1</td>
<td style="width: 27px">1</td>
<td>1</td>
<td>1</td>
<td style="width: 34px">1</td>
<td>1</td>
<td style="width: 25px">1</td>
<td style="width: 26px">1</td>
<td style="width: 21px">1</td>
</tr>
</table>
</form>
</div>
</div>
<br />
<br />
<center><a href="StatOne.asp">继续统计</a></center>
</body>
</html>
sy_binbin 2009-07-17
- 打赏
- 举报
你这样写要加别名的
strSql="select count(*) as sl,st.studykind as ststudykind ,fdz.fdzname as fdzfdzname,signstate0=sum(case when signstate=0 then 1 else 0
end),signstate1=sum(case when signstate=1 then 1 else 0 end) "
然后输出的时候用
<%=rs("sl")%>
<%=rs("ststudykind")%>
<%=rs("fdzfdzname")%>
strSql="select count(*) as sl,st.studykind as ststudykind ,fdz.fdzname as fdzfdzname,signstate0=sum(case when signstate=0 then 1 else 0
end),signstate1=sum(case when signstate=1 then 1 else 0 end) "
然后输出的时候用
<%=rs("sl")%>
<%=rs("ststudykind")%>
<%=rs("fdzfdzname")%>
王者coco 2009-07-17
- 打赏
- 举报
这两个字段studykind,fdzname也没输出来
lzp4881 2009-07-17
- 打赏
- 举报
<%=rs("signstate0") %>
<%=rs("signstate1") %>
strSql="select count(*) as sl ,st.....这里加一个别名
然后用
<%=rs("sl")%>
<%=rs("signstate1") %>
strSql="select count(*) as sl ,st.....这里加一个别名
然后用
<%=rs("sl")%>
sy_binbin 2009-07-17
- 打赏
- 举报
当然啥都没有啊！你数据集里根本没有signstate这个字段
王者coco 2009-07-17
- 打赏
- 举报
我直接用字段名<td><%=rs("signstate") %></td>，但是什么也没输出
lzp4881 2009-07-17
- 打赏
- 举报
....
<table>
<%
....
do while not rs.eof
response.write "<tr>"
response.write "<td>"&rs(0)&"</td>"
response.write "<td>"&rs(1)&"</td>"
response.write "<td>"&rs(2)&"</td>"
response.write "<td>"&rs(3)&"</td>"
...
rs.movenext
response.write "</tr>"
loop
%>
</table>
...
<table>
<%
....
do while not rs.eof
response.write "<tr>"
response.write "<td>"&rs(0)&"</td>"
response.write "<td>"&rs(1)&"</td>"
response.write "<td>"&rs(2)&"</td>"
response.write "<td>"&rs(3)&"</td>"
...
rs.movenext
response.write "</tr>"
loop
%>
</table>
...
