You could add a COUNT() to your query...
Once you add a "Scalar/Aggregate" function to your SQL you will need to
specify al the fields in the GROUP BY though.
SELECT
table1.field1,
table2.field1,
COUNT(table2.field1) AS CountField1
FROM
table1 INNER JOIN table2 ON table1.ID=table2.ForeignID
GROUP BY
table1.field1,
table2.field1
That should allow you to output the "CountField1" value inside the CF Group.
> I know this is easy, but I need sleep. How can I easily get the number
of
> records returned per grouping in a cfoutput query?
>
> Eric J Hoffman
> Small Dog Design, LLC
> www.smalldogdesign.com
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
