I think that'll do the same thing but I'll guess that mine's faster. :-) On Tue, Aug 11, 2009 at 12:03 PM, Dave Phillips < experiencedcfdevelo...@gmail.com> wrote:
> > I think Francios meant something like this: > > <cfoutput query="getAce" group="title"> > <cfquery dbtype="query" name="qAids"> > select aid > from getAce > where title = <cfqueryparam value="#getAce.title#" > cfsqltype="cf_sql_varchar"> > </cfquery> > aid: #valueList(qAids.aid)# > </cfoutput> > > That should give you your comma delimited list of only the aid values that > match the current title in the grouping. > > Dave Phillips > > -----Original Message----- > From: John M Bliss [mailto:bliss.j...@gmail.com] > Sent: Tuesday, August 11, 2009 10:54 AM > To: cf-talk > Subject: Re: valueList not giving me what i want.. quick look > > > Then something like...? > > <cfoutput query="getAce" group="title"> > <cfset thisaid = ""> > <cfoutput> > <cfset thisaid = ListAppend(thisaid, getAce.aid)> > </cfoutput> > aid: #thisaid# > </cfoutput> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4