Recordsets

Hi,

I'm having a problem where I have a huge number of recordsets,

I'm not sure how Dreamweaver does it but it looks like it opens all the recordsets the closes them instead of opening one closing etc.

But what I would like to do is get the same information from all these recordsets i.e.

Select

IIF(ISNULL(SUM(appold.`Data Units`)),0,(SUM(appold.`Data Units`))) AS DU,

IIF(ISNULL(SUM(appold.`Voice Units`)),0,(SUM(appold.`Voice Units`))) AS VU,

IIF(ISNULL(SUM(appold.`Data Faults`)),0,(SUM(appold.`Data Faults`))) AS DF,

IIF(ISNULL(SUM(appold.`Voice Faults`)),0,(SUM(appold.`Voice Faults`))) AS VF,

IIF(ISNULL(SUM(appold.Telephone)),0,(SUM(appold.Telephone))) AS Tel,

IIF(ISNULL(SUM(appold.Survey)),0,(SUM(appold.Survey))) AS Survey,

IIF(ISNULL(( (SUM(appold.`Data Units`)) + (SUM(appold.`Voice Units`)) + (SUM(appold.`Data Faults`)) + (SUM(appold.`Voice Faults`)) + (SUM(appold.Survey)))),0,(( (SUM(appold.`Data Units`)) + (SUM(appold.`Voice Units`)) + (SUM(appold.`Data Faults`)) + (SUM(appold.`Voice Faults`)) + (SUM(appold.Survey))))) AS NoChannels, (COUNT(appold.build_name)) AS NoTickets


WHERE (appold.monthentry = MMColParam) AND (build_name = 'build1')


to

WHERE (appold.monthentry = MMColParam) AND (build_name = 'build20')


The build_name will be something different but there are 20 different names.

Is it also possible to have these as a Response.Write for each item in each recordset so that I can paste them in different places on a page.

Thanks,

Sanjay