If you need to get the count within a group before you
output, how about using ValueList or QuotedValueList
on the column you need to group by and then using
ListValueCount or ListValueCountNoCase as appropriate
to find the number of instances within that group?
For example:
<cfset lCategoryItems = ValueList( qGetItems.Category )>
<cfoutput query="qGetItems" group="Category">
#qGetItems.Category# (#ListValueCountNoCase(lCategoryItems,
qGetItems.Category)# items)<br>
<cfoutput>
....
</cfoutput>
</cfoutput>
Hope this helps,
Colin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
