dim rs,sql,zh
set rs=server.createobject("adodb.recordset")
sql="select hymc,hyje,dls,sum(chk) as num, from 表 where chk=1 and dls='ll' group by hymc,hyje,dls"
rs,open sql,conn
zh=rs("num")
rs.close
set rs=nothing
response.write "代理商ll的贷物金额为:"&zh
我怎么才能得到这个和?在asp页面中啊?
set rs=server.CreateObject("adodb.recordset")
select hymc,hyje,dls,sum(chk) from 表 where chk=1 and dls='ll'
rs.open sql,conn,1,1
那么我怎么显示出来 hyje字段相加后的值?
rs("hyje")??
好象不对啊!请大家帮我啊!