asp求和。。。重赏!!

来源:百度知道 编辑:UC知道 时间:2024/07/06 23:23:18
accsee数据库。表名user
字段 mc sl ls
A 20 入
b 10 出
c 30 入
d 10 出
------------------
合计: 30
自己搞定答案如下。
<%
set rs=server.createobject("adodb.recordset")
strsql="select sum(sl) as ru from user where uid='出库'"
rs.open strsql,conn,1,1
ru=rs(0)
set rs2=server.createobject("adodb.recordset")
strsql1="select sum(sl) as chu from user where uid='退货'"
rs2.open strsql1,conn,1,1
chu=rs2(0)
aa=ru-chu
response.write(aa)
%>

测试通过!!
<%
set rs=server.CreateObject ("ADODB.Recordset")
strsql="select sum(sl) as ru from user where ls='入'"
rs.open strsql,conn,1,1
ru=rs("ru")
rs.close
set rs=nothing

set rs=server.CreateObject ("ADODB.Recordset")
strsql="select sum(sl) as chu from user where ls='出'"
rs.open strsql,conn,1,1
chu=rs("chu")
rs.close
set rs=nothing

aa=ru-chu
response.Write(aa)
%>

补:晕,你这和我的有什么区别