asp制作统计

asp制作统计

sql="select count(sj) as sjcounts from ct where sj=10"
ser rs=conn.execute(sql)
response.write rs("sjcounts")

本例中，response.write rs("sjcounts")写出2

告诉我你的问题和Email,
有别的要求也可以联系我们,
有可能帮你,
使用百度_Hi给我留言

<%
set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)}; dbq="&server.MapPath("bgxt.asp")
set rs=Server.CreateObject("ADODB.RECORDSET")
sql="select * from ct where sj=10"
rs.open sql,conn,1,1
Response.Write(RS.RecordCount)
rs.close
%>