The Group functionality built into the <Cfoutput> tag
works something like this:
<!--- CFOUTPUT LOOP 1 (UNIQUE VALUES OF colA) --->
<cfoutput query="myQuery" group="colA">
<p>#colA#</p>
<!--- CFOUTPUT LOOP 2 (all records associated with unique
ColA value)
<cfoutput>
#colB#
</cfoutput>
</cfoutput>
The outer cfoutput block (the one with the group=""
attribute) will loop once for every unique value of the column you
specify in the group attribute (assuming the values are ordered by
ColA). The inner <cfoutput> block will loop for each row in
the table that match that unique value of ColA.
TABLE:
ColA, ColB, ColC
A, 1, 0
A, 2, 0
B, 0, 0
C, 3, 1
Using the code above, you would see an output like this:
<p>A</p>
1
2
<p>B</p>
0
<p>C</p>
3
Hope that helps illuminate the problem. The official CF
documentation can probably give you a little more indepth
explaination.