在ASP语言中用SQL命令查询总数后如何显示结果出来

response.write rsa.recordcount

response.Write(rsa("字段名"))
想显示那个字段就写哪个字段名

还不明白的话补充问

sql的count可以用as

set rsa=server.createobject("adodb.recordset")
sqla="select count(*) as cou from kcb where sccj='天'"
rsa.open sqla,conn,1,1
if rsa.eof then
else

response.Write rsa("cou")

end if
rsa.close

<% set rsa=server.createobject("adodb.recordset")
sqla="select count(*) from kcb where sccj='天'"
rsa.open sqla,conn,1,1
for i=1 to rsa.recordcout
if rsa.eof then
exit for
end if
%>
<div>
<%=rsa("字段名称")%>
</div>
<% rsa.moveNext
next
%>