Multiple Query result returned from CFC
by lokointhehouse2
HTML
<cffunction name="resultsPACQualityAverage" hint="resultsPACQualityAverage">
<cfargument name="reporttypeid" type="string" required="false" default="13"/>
<cfargument name="formd" type="string" required="false" default=""/>
<cfif arguments.reporttypeid eq 13>
<cfset variables.pivotcolumns = 'NSH,WAR,MEM,ORL,OPK'>
<cfelseif arguments.reporttypeid eq 14>
<cfset variables.pivotcolumns = 'IND,MEM,ORL,WHI'>
<cfelseif arguments.reporttypeid eq 15>
<cfset variables.pivotcolumns = 'COL,DUB,IND,MEM,ORL'>
<cfelseif arguments.reporttypeid eq 16>
<cfset variables.pivotcolumns = 'COL,DUB,IND,MEM,ORL'>
<cfelseif arguments.reporttypeid eq 17>
<cfset variables.pivotcolumns = 'WAR,ORL,LMF'>
</cfif>
<cfset local.today=now()>
<CFSET local.date1 = #DateFormat(DateAdd('m', -12, local.today),'mmmm dd, yyyy')#>
<CFSET local.date2 = #now()#>
<cfset local.countloop = 0>
<Cfset local.numMonths = DateDiff("m", local.date1, local.date2)>
<cfset local.list1 = ''>
<cfset local.list2 = ''>
<cfloop index="local.a" from = "1" to ="#local.numMonths#">
<cfset local.list1 = #local.list1# & '[#monthasstring(DatePart("m", DateAdd("m", local.a, local.date1)))#],'>
<cfset local.list2 = #local.list2# & "'#monthasstring(DatePart("m", DateAdd("m", local.a, local.date1)))#',">
</cfloop>
<cfset local.list1 = #REReplace(local.list1, ",$", "")#>
<cfset local.list2 = #REReplace(local.list2, ",$", "")#>
<cfif dayOfWeek(local.today) gt 1>
<cfset local.mostRecentSaturday = dateAdd("d", 7-dayOfWeek(local.today), local.today)>
<cfelse>
<cfset local.mostRecentSaturday = dateAdd("d", -7, local.today)>
</cfif>
<cfset local.list1Weekly = ''>
<cfset local.list2Weekly = ''>
<cfloop index = "local.a" list = "84,77,70,63,56,49,42,35,28,21,14,7"><!--- --->
<cfset local.list1Weekly = #local.list1Weekly# & '[#dateformat(DateAdd("d", -local.a, local.mostRecentSaturday), 'mm/dd/yyyy')#],'>
<cfset local.list2Weekly =...