怎么输出统计的行数阿？？？

[jeffery188604253]

set rs=server.CreateObject("adodb.recordset")
rs.open"select count(*) from product",db,1,3

怎么输出统计的行数阿？？？

[hwqnew]

set rs=server.CreateObject( "adodb.recordset ")
rs.open "select count(*) as xx from product ",db,1,3

response.write(rs("xx"))

[zhouyuzhu]

2种方法
1.楼上的写法
<%set rs=server.CreateObject("adodb.recordset")   
rs.open "select count(*) as xx from product",db,1,3   
response.write(rs( "xx "))
%>
2.
<%set rs=server.CreateObject("adodb.recordset") 
rs.open "select * from product",db,1,3
response.write(rs.recordcount)
%>

[toury]

<%
set rs=server.CreateObject("adodb.recordset") 

'不要count(*),效率太低 字段名:随便一个字段名(无NULL,最好是索引字段)

rs.open "select count(字段名) from product ",db,1,1
response.write rs(0)&""
%>

[jeffery188604253]

谢谢各位帮忙