Variables['q#dayspan#'].totalorders
-----Original Message-----
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 1:06 PM
To: CF-Talk
Subject: Re: Must I Use Evaluate() Here?
Yup, looping over the collection if you have a structure is more elegant
than using evaluate.
Here's an interesting one though...I am dynamically generating
queries/query names, is there any way to evaluate the query results
dynamically without using evaluate?
I would do a single query and then loop qoq's for better performance but
I'm doing some SQL that qoq's can't do.
the setter loop:
<cfset dayslist = "0,1,7,30,90,365">
<cfloop list="#dayslist#" index="dayspan"> <cfquery name="q#dayspan#"
datasource="#Request.DS#"
username="#Request.user#" password="#Request.pass#"> SELECT totalorders
etc....
This gives 6 queries named q0, q1, q7 etc.
the evaluator:
<cfloop list="#dayslist#" index="dayspan"> Evaluate('q' & dayspan &
'.totalorders')
???????
----- Original Message -----
From: "Aaron Rouse" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Wednesday, August 30, 2006 9:51 AM
Subject: Re: Must I Use Evaluate() Here?
>I think it gets forgotten about as an option more times than not.
>
> On 8/30/06, Teddy Payne <[EMAIL PROTECTED]> wrote:
>>
>> Regardless of the speed factor, why not use the loop structure that
was
>> made
>> to handle structures? *rhetorical question*
>>
>> Teddy
>>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251507
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
