Where I am using 'group' in my cfquery. So I think - yes to your question. I originally had this - <cfoutput query="get_members_advanced" group="contact_type_id"> <h2>#contact_type# </h2> <cfoutput> #contact_surname# <br /> </cfoutput> </cfoutput> But this gave me a single column - I want each new contact_type to display in a new column so if 4 different contact_types - 4 columns. And the number of columns will vary from 1 - 6 depending on the search criteria. Hope this makes sense? ta Seamus
>What do you mean by grouped query? > >Like a two column query where the values of one of the columns match across >multiple rows? > > > >On Thu, Jul 16, 2009 at 6:21 PM, Seamus Campbell ><[email protected]>wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
