Certainly :-)
<cfoutput query="YourQ" group="Department">
#Department#
<cfoutput group="Manager">
#Manager#
<cfoutput>
#Worker#
</cfoutput>
</cfoutput>
</cfoutput>
The "Group" attribute of CFOUTPUT works great. You can use it to reference
any fields from a query that appear in either a "GROUP BY" or "ORDER BY" in
your query.
> I'm not sure if this is the right approach either. Is there a way either
> in SQL or Coldfusion to have it only show the department and and manager
> the first time the value appears?
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
