How to count grouped records ?

[olmos]

I have a cfoutput query using a Group = "" . I need to be able to count just the number of groups and place the count number beside the start of a new group in a table.
How do I do this ?

Thanks,
olmos.

 

[GunJack]

Hey Olmos,

Something like this will give you the group count.

<cfquery ...
select * from my table
order by myGroup asc
</cfquery>

<cfset groupCount=0>
<cfoutput query=&quot;q1&quot; group=&quot;myGroup&quot;>
<cfset groupCount=groupCount+1>
<cfoutput></cfoutput>
</cfoutput>

<cfoutput>
<table><tr>
<td>(#groupCount#) New Group</td>
</tr></table>
</cfoutput>

Hope this helps,
GJ

 

[olmos]

Thank you GunJack, it worked GREAT!

Olmos.