Re: grouped query - groups in separate columns

2009-07-19 Thread Peter Boughton
Still not certain I understand, but if you want columns of text you can try something like this: cfoutput query=get_members_advanced group=contact_type_id div class=col c6 h2#contact_type# /h2 cfoutput #contact_surname# br /

Re: grouped query - groups in separate columns

2009-07-17 Thread Seamus Campbell
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

grouped query - groups in separate columns

2009-07-16 Thread Seamus Campbell
Hi I have a grouped query which displays fine but in a single column. I want to display each group in a new column, but I can't work out how to do this Any clues please Ta Seamus ~| Want to reach the ColdFusion community

Re: grouped query - groups in separate columns

2009-07-16 Thread David McGuigan
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 coldfus...@boldacious.comwrote: Hi I have a grouped query which displays fine but in a single column. I want to