ÕâÊÇÎҵIJ¿·Ö´úÂ룺 <% dim aid dim bid dim a dim b dim i aid = split(trim(request.Form("hf")),",") //aidÊý×éÖµ·Ö±ðÊÇ 75,76 Ò²¾ÍÊDZíµÄ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