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:325336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4