Valuelist returns all the results of the query, so you don't need cfoutput query="": aid: <cfoutput>#valueList(getAce.aid)#</cfoutput>
Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:17 AM, Paul Ihrig <pih...@gmail.com> wrote: > > i know i know this. but it escapes me... > > just a cfoutput inside my loop gives me exactly the list i want.. > but i need the , commas.. > > <cfoutput query="getAce" group="title"> > aid: <cfoutput>#getAce.aid#</cfoutput> > </cfoutput> > > Mounting Panel aid: > > 1811922492502512522532542552562572603203213223233243253263273283293303313323332435 > Wallmount Brackets aid: 36 > > > this loops through to many times but has commas.. and is wrong.. > > <cfoutput query="getAce" group="title"> > aid: <cfoutput>#valueList(getAce.aid)#</cfoutput> > </cfoutput> > > Mounting Panel aid: > > 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,---you > get the idea--- > Wallmount Brackets aid: > > 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
