Question

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

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

请问这里该写什么，才能显示出来查询的结果。

end if
rsa.close

Answer 1

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

Answer 2

<% 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
%>

Answer 3

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

还不明白的话补充问

Answer 4

response.write rsa.recordcount