这是我的部分代码： <% dim aid dim bid dim a dim b dim i aid = split(trim(request.Form("hf")),",") //aid数组值分别是 75,76 也就是表的ID
for i=0 to 1 //下面的代码循环执行2次 a=0 While (NOT Re1.EOF) sqll="select sum(gongfei) from weixiuneirong where cid ="&aid(i)&"" //gongfei字段值分别为3,4 | 5,6 set rs=conn.execute(sqll) a=rs(0) Re1.Movenext Wend response.write a
b=0 While (NOT Re2.EOF) sqlm="select sum(jinger) from beijian where cid ="&aid(i)&"" //jinger字段值分别为2, 4 | 7,8 set rs2=conn.execute(sqlm) b=rs2(0) Re2.Movenext Wend response.b
