bt_ybdjxx表内有个名为 Fsbgr 的字段，当有数据的时候变量自动+1，初始为0，最后统计出这个字段有数据的记录条数一共是多少？谢谢！
<%
set rs=Server.Createobject("ADODB.Recordset")
  sql="SELECT Fsbgr(*) AS n FROM [bt_ybdjxx] a WHERE dwdh ="&session("manage")
      rs.open sql,conn,1,1
          if rs.eof then
        response.write("您的报告还没有被审核")
          else
              rs("n")=rs1("n")+1
      rs.movenext
  end if
%>

<%
set rs=Server.Createobject("ADODB.Recordset")
rs.open "SELECT Fsbgr FROM [bt_ybdjxx] WHERE dwdh="&session("manage"),conn,1,1
if rs.eof and rs.bof then
response.write("您的报告还没有被审核")
else
conn.execute "update [bt_ybdjxx] set Fsbgr=rs("Fsbgr")+1 WHERE dwdh="&session("manage")
zs=conn.execute("SELECT count(*) from [bt_ybdjxx] WHERE Fsbgr<>0")(0)
response.write("有数据共有"&zs&"条")
end if
rs.close
set rs=nothing
%>

[[it] 本帖最后由 hmhz 于 2008-2-4 17:19 编辑 [/it]]