User Guide

148 Chapter 9 Building Dynamic Forms
Grouping output from a query
In a query that you display using a cftree control, you might want to organize your
employees by the department. In this case, you separate column names with
commas in the
cftreeitem value attribute.
To organize the tree based on ordered results of a query:
1 Open a new file named tree2.cfm in ColdFusion Studio.
2 Modify the page so that it appears as follows:
<!--- CFQUERY with an ORDER BY clause --->
<cfquery name="deptquery" datasource="CompanyInfo">
SELECT Dept_ID, FirstName + ’ ’ + LastName
AS FullName
FROM Employee
ORDER BY Dept_ID
</cfquery>
<!--- Build the tree control --->
<cfform name="form1" action="submit.cfm"
method="Post">
<cftree name="tree1"
hscroll="No"
border="Yes"
height="350"
required="Yes">
<cftreeitem value="Dept_ID, FullName"
query="deptquery"
queryasroot="Dept_ID"
img="cd,folder">
</cftree>
<br>
<br><input type="Submit" value="Submit">
</cfform>
3 Save the page and view it in your browser.