MACROMEDIA COLDFUSION 5-DEVELOPING, Develop Manual

Page: 168 / 438

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, Fir ’ ’ + 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.