Totally ignoring the data/distinct question for a moment, when using cfoutput
"group" the query data must be sorted correctly, or you will not get the right
results.
You need to ORDER the query results by the same column you're using in your
"group". If you are grouping by "audit_org_type_id", your query must be ordered
by that column as well.
<cfquery ...>
SELECT ....
ORDER BY audit_org_type_id
</cfquery>
<cfoutput name="..." group="audit_org_type_id">
....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327502
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
