小温侯是谁:ASP里面，如何计算两个值的比率？

count(*)怎么会是字段？计算条数得
Set adoConn = Server.CreateObject("ADODB.Connection")
ConnectionString = "Driver={SQL Server};SERVER=(local);UID=ctintranet;Password=;DATABASE=ctintranet"
adoConn.Open ConnectionString
Set RS1 = Server.CreateObject("ADODB.Recordset")
Set RS2 = Server.CreateObject("ADODB.Recordset")
str="select count(*) from bbinfo,errinfo where area=010"
rs.open str,conn,1,1,1
str2="select count(*) from errinfo where area=010 "
rs2.open str2,conn,1,1,1
'''
resault=FormatPercent(rs1(0)/rs2(0))

把第一记录集的结果存入变量 如 num1=rs1(0)

把第二记录集的结果也存入变量 如 num2=rs2(0)

resault=FormatPercent(num1/num2)

输出 resault 即是两个数的百分比

str=select count(*) from bbinfo,errinfo where area=010
rs.open str,conn,1,2,1
resault=FormatPercent(bbinfor.count(*)/errinfor.count(*))
就可以了呵呵
count(*)是一个字段的名字吧，好奇怪的感觉啊呵呵
同样多条信息也可以用循环搞定，只是用rs.movenext罢了呵呵