cnompoo的老公:select sum(*) from...where.....

来源：百度文库编辑：高考问答时间：2024/04/28 23:32:06

sum="select sum(金额) from DATA where 学校='"&school&"' and 类型="&id
set a=con.execute(sum)
response.write a

提示:
错误类型：
Response 对象, ASP 0185 (0x8002000E)
找不到对象的默认属性。
/sum/sudlist.asp

浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

网页：
GET /sum/sudlist.asp

set rs=conn.execute("select sum(金额) from DATA where 学校='"&school&"' and 类型="&id)
response.write rs(0)
set rs=nothing

变量名不能用关键字 SUM是个求和的函数名不能用做变量名

把SUM换个变量名试试

select sum(*) from...where..... SELECT SUM(工资) FROM 职工 select distinct id ,num=sum(cast((num) as int) from sy order by id desc 关asp.net select sum(*) select from where like select *from 部系表 select count(*) from 学生 select * from table1 where id in (select id from table2)， select * from v$bgprocess 是什么意思 select * from (select a.*,b.kczwmc kcmc from (select kcdm,max(McjN) Mcj,Max(kcxz) kcxz from (select