Question

怎样在ASP里使用select count(*)显示统计出不为空的字段数量？

select count(*) from allmembership where deeplove<>''
以上这行SQL查询代码可以分析allmembership表deeplove字段有多少个null或空字符串的数量。请问怎样才能把这行查询代码写在ASP里使页面上可以显示统计出返回的数值？
我的意思是怎样将select count(*) from allmembership where deeplove is not null查询的结果显示到ASP页面上，是不是依然可以像<%= rs("deeplove") %>这样显示输出呢？

Answer 1

sql="select count(*) from allmembership where deeplove is not null"
rs.open sql

显示:
<%=rs(0)%>

还可以
sql="select count(*) as counts from allmembership where deeplove is not null"
rs.open sql
显示:
<%rs("counts")%>