I have code generating a dynamic named query, ie
getCompanyTractorStats2
getCompanyTractorStats3
I have a CFC that generates a query result, and I assign dynamic names
like this:
<!---// Loop from the 1st of the month to current and create per-day
variables //--->
<cfloop from="1" to="#dateFormat(now(), "DD")#" index="curDay">
<cftry>
<!---// Call function to get tractor statistics //--->
<cfset "getCompanyTractorStats#curDay#" =
cfc.getCompanyTractorStats(url.dsn, '#dateFormat(now(), "MM")#/' &
curDay & '/#dateFormat(now(), "YYYY")#') />
<cfset "getOwneropTractorStats#curDay#" =
cfc.getOwneropTractorStats(url.dsn, '#dateFormat(now(), "MM")#/' &
curDay & '/#dateFormat(now(), "YYYY")#') />
<cfcatch type="any">
<!--- Ignore errors, that means the file is missing
//--->
</cfcatch>
</cftry>
</cfloop>
I need to reference the values to specific queries below
I am trying #getCompanyTractorStats[curDay].myCol#
Trying all combinations of eval and DE, I am tearing my hair out, anyone
help me here?
Thanks a bunch!
Chris Peterson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274356
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
