Hello everyone, I got a small brainteaser for those awake this morning
I have a query fuseaction that goes like this:
<cfloop index="DateLoop" from="1" to="#ArrayLen(DateGroupArray)#">
<Cfloop index="SchoolStatusLoop" from="1" to="#ArrayLen(SchoolStatusArray)#">
<CFQUERY DATASOURCE="#Application.DSN#"
NAME="ReportCount#DateLoop#-#SchoolStatusLoop#">
Query Information goes here
</CFQUERY>
<CFINCLUDE TEMPLATE="rpt_bldarray.cfm">
</CFLOOP>
</CFLOOP>
What this does, is loops the query over and over using the loop for different
criteria from the arrays involved.
The problem comes in evaluating the results, I tried setting up:
<CFSET EvalResult =
Evaluate(DE("ReportCount"),DateLoop,DE("-"),SchoolStatusLoop,DE(".ResultCount"))>
In rpt_bldarray to build the result, but all I get is something along the lines of a
query name (ReportCount1-1.ResultCount for example). How do I use Evaluate() here to
get the query result, and not the query name? TIA
Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
