asp如何输出count(*)值?

[wohingradio88]

各位,我有一段以下代码,已经连接数据库了,并且有一个可以查询到某个相符字段的记录总数.
现在假设我想查询P_HotItem字段值为ABC和BCD的记录各有几条,并且显示在ASP网页中,应该如何处理呀?请指教一下,感激不尽,找了好久也搞不明白.
<!--#include file="../Connections/conn.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "-1"
If (Request("MM_EmptyValue") <> "") Then
Recordset1__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM Products WHERE P_HotItem = " + Replace(Recordset1__MMColParam, "'", "''") + ""

Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

[MR丶CHAN]

select count(*) files1,files2 from table group by files2

[shenzhenNBA]

<%
....
%>

<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT count(*) FROM Products WHERE P_HotItem = " + Replace(Recordset1__MMColParam, "'", "''") + ""

Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0

response.write " 总的记录数为 ：" & Recordset1(0) & " 条"
%>

[街头小贩]

查询P_HotItem字段值为ABC和BCD的记录各有几条
组合两条SQL

SELECT * FROM (SELECT COUNT(*)AS num1 FROM Products WHERE P_HotItem ='ABC'),(SELECT COUNT(*)AS num2 FROM Products WHERE P_HotItem ='BCD')

[街头小贩]

修正一下:

SELECT * FROM (SELECT COUNT(*)AS num1 FROM hr_user WHERE username LIKE '%ABC%') f,(SELECT COUNT(*)AS num2 FROM hr_user WHERE username LIKE '%BCD%') d

[街头小贩]

不用别名会出错!

[yuanlovechina]

关键在于SQL语句
set rs=server.createobject("adodb.recordset")
sql="select count(P_HotItem) as num from products where …… group by P_HotItem "
rs.open sql,conn,1,3

在ASP网页中按一定顺序输出rs("num")