Then something like...? <cfoutput query="getAce" group="title"> <cfset thisaid = ""> <cfoutput> <cfset thisaid = ListAppend(thisaid, getAce.aid)> </cfoutput> aid: #thisaid# </cfoutput>
On Tue, Aug 11, 2009 at 11:49 AM, Francois Levesque <cfab...@gmail.com>wrote: > > The valuelist returns all the values in that column, regardless of any > cfoutput group used. > You might want to use a query of query to get the values for that name, and > then use valuelist on that new query. > > Francois Levesque > http://blog.critical-web.com/ > > > On Tue, Aug 11, 2009 at 11:46 AM, Paul Ihrig <pih...@gmail.com> wrote: > > > > > i need the group on the out side because i am grouping by a name that > > gets trimed from many similar names and such. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4