<%
groupid = request("groupid")
if groupid="" or groupid="undefined" then groupid=1

    Set cs = Server.CreateObject("ADODB.RecordSet")
    sql="select count(*) as cs from agentlog where agentid='"&groupid&"' and housetype =1"
    cs.Open sql,conn,1,1

    Set cz = Server.CreateObject("ADODB.RecordSet")
    sql="select count(*) as cz from agentlog where agentid='"&groupid&"' and housetype =2"
    cz.Open sql,conn,1,1
   
    Set sc = Server.CreateObject("ADODB.RecordSet")
    sql="select count(*) as sc from agentlog where agentid='"&groupid&"' and housetype =0"
    sc.Open sql,conn,1,1

response.write cs("cs")
response.write cz("cz")
response.write sc("sc")

%>

数据库理查出来都有值的..但是我页面上显示就变0了..求高手解释

是MY SQL 的数据库..那个groupid字段是字符类型的..去掉'会报错..我现在就是查出来显示是0

我找到原因了..我 request返回值返回空了..所以查出来为空数据..