So the volunteers query does not contain the EntityID? It is only present in the getRoster query? If so then just scope it: getRoster.EntityID
On 2/22/06, Rick Root <[EMAIL PROTECTED]> wrote: > > Consider the following code: > > > <cfoutput query="getRoster" group="ENTITYID"> > <cfset volunteers = getVolunteers(ENTITYID)> > <!-- volunteers is a query ---> > <cfoutput><!-- output some stuff here --></cfoutput> > <cfloop query="volunteers"> > foo bar #ENTITYID# > </cfloop> > </cfoutput> > > The reference to ENTITYID inside the cfloop breaks, says it doesn't > exist. Is that because CF only looks at the current query being looped > over? > > It works fine if I add something like <cfset thisEntityID = ENTITYID> > just after the first cfoutput line and then reference *THAT* variable > instead. > > Just seems odd. > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233113 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
