Question

asp中如何显示count(*)结果

<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 loupan.L_name,count(*) from loupan,kehu where kehu.L_id=loupan.id group by loupan.L_name"
rs.open sql,conn,1,1
'num=rs(0)
'response.write(num)
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="margin-top:2px">
<%
do while not rs.eof
%>
<tr>
<td width="15" align="center"></td>
<td width="60" height="25"><%=rs("L_name")%></td>
<td width="25" align="right" class="font_STYLE11" style="color:#FF0000"><%=rs(count(*))%>人 </td>
</tr>
<%
rs.movenext
loop
%>
</table>
<%=rs(count(*))%>这个地方报错
</tr>
<%
rs.movenext
loop
%>
</table>

Answer 1

set rs=conn.execute("select count(Id) as num from 表名")

response.write(rs("num"))

Answer 2

用 <%=rs(1)%>

或者给字段一个别名
sql="select top 10 loupan.L_name,count(*) as [count] from loupan,kehu where kehu.L_id=loupan.id group by loupan.L_name"

<%=rs("count")%>

Answer 3

set rs=conn.execute("select count(Id) as num from 表名")