AWESOME - simple, easy fix - thanks Leigh ... I had forgotten that requirement
>>> Leigh <cfsearch...@yahoo.com> 10/22/2009 11:55 AM >>> 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:327503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4