set rs=conn.execute("select Status,count(Status) as StatusCount from Table1 where ProductClass=3 ……
[/Quote]
如果产品分类也是表调用的呢?
也就是还有一个表是ProductClass表,中是产品名称和ID,其中ID和这个表的ProductClass字段对应,
要出来各个产品的各种数据
set rs=conn.execute("select Status,count(Status) as StatusCount from Table1 where ProductClass=3 group by Status")
do while not rs.eof
response.write "产品分类为3,Status为"&rs("Status")&"的数据有"&rs("StatusCount")&"个"
rs.movenext
loop