asp单行代码统计表内各种数据总和
<% = Conn.Execute("select count(dlsid) from [member] where dlsid='"&newdlshyid&"'")(0) %> 人
会员人数：<% = Conn.Execute("select count(dlsid) from [member] where dlsid='"&newdlshyid&"'")(0) %>
会员帐户：<% = Conn.Execute("SELECT SUM(rmb) FROM [member] where dlsid='"&newdlshyid&"'")(0) %> 元
流水：<% = Conn.Execute("select count(id) from [ancoset] where dlsid='"&newdlshyid&"'")(0) %> 笔
=========================
商家数量：<% = Conn.Execute("select count(id) from [dls]")(0) %> 家
会员人数：<% = Conn.Execute("select count(id) from [member]")(0) %> 人
商家总额：<% = Conn.Execute("SELECT SUM(rmb) FROM [dls]")(0) %> 元
会员总额：<% = Conn.Execute("SELECT SUM(rmb) FROM [member]")(0) %> 元
流水明细：<% = Conn.Execute("select count(id) from [ancoset]")(0) %> 笔
【已报名】<% bmrs = Conn.Execute("SELECT SUM(crsl+etsl) FROM [baoming] where yid="&bm_yid&"")(0):response.Write(bmrs) %> 人