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:[email protected]]
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
