急死

[张三大胖]

<%
bibi=split(request("kemu"),",")
a=""
for i=0 to ubound(bibi)

a=a+SUM(CASE 科目代码 WHEN "bibi(i)" THEN 余额 ELSE 0 END) AS "bibi(i)"
response.Write i
next


%>

就是把SUM(CASE 科目代码 WHEN "bibi(i)" THEN 余额 ELSE 0 END) AS "bibi(i)"看成是字符串

应该怎么做啊

[leohuang]

try
----------------------------------------
a=a + "SUM(CASE 科目代码 WHEN '" & bibi(i) & "' THEN 余额 ELSE 0 END) AS " & bibi(i)

[Forthleo]

a=a+SUM(CASE 科目代码 WHEN "bibi(i)" THEN 余额 ELSE 0 END) AS '" & bibi(i) & "'"

[张三大胖]

为什么出来的结果

select 公司名称,时间戳,SUM(CASE 科目代码 WHEN '1001' THEN 余额 ELSE 0 END) AS '1001',SUM(CASE 科目代码 WHEN ' 1001.01' THEN 余额 ELSE 0 END) AS ' 1001.01' from t_nbwl2006 group by 公司名称,时间戳
在' 1001.01' 会自动多出一个空格呢？

[leohuang]

就这样,提交的时候有一个空格
trim()一下就可以了

a=a + "SUM(CASE 科目代码 WHEN '" & trim(bibi(i)) & "' THEN 余额 ELSE 0 END) AS " & trim(bibi(i))

或者一开始就替换掉
bibi=split(replace(request("kemu")," ",""),",")