User Guide

438 Chapter 2: ColdFusion Tags
Usage
This tag requires the client to download a Java applet. Downloading an applet takes time;
therefore, using this tag might be slightly slower than using an HTML form element or the
cfinput tag to get the same information.
For this tag to work properly. the browser must be JavaScript-enabled.
If you do not use a query to populate this tag, it creates a single tree item. If you do use a query, it
creates multiple items; each row of the query creates a hierarchically nested set of items with one
item per column.
Example
The following example creates a simple tree using a single cftreeitem tag and a query:
<cfform action = "#cgi.script_name#">
<cftree name = "Employees" height = "400" width = "200">
<cftreeitem value="LastName, FirstName, Emp_ID" query="getEmployees"
queryAsRoot="False">
</cftree>
</cfform>
The following example creates a tree that shows the basic information about all employees in an
organization, organized by department. The departments are expanded to show all employees.
You can click the + signs to display additional information. If you click the employee name,
ColdFusion links back to the same page and displays the selected employee’s ID.
<!--- Query the datasource to get employee information.--->
<!--- Group the output by Department.
(All fields are required in Group By clause.) --->
<cfquery name = "GetEmployees" dataSource = "cfdocexamples">
SELECT Emp_ID, FirstName, LastName, EMail, Phone, Department
FROM Employees
GROUP BY Department, Emp_ID, FirstName, LastName, EMail, Phone
</cfquery>
queryAsRoot Optional;
All
Yes Applies only if you specify a
query attribute. Defines the query
as the root level for all items generated by this tag. This
attribute enables you to avoid creating a parent
cftreeitem.
• Yes: generates a parent (root) item for all other items
generated by the tag, with the query name as its value; if you
specify a
parent attribute, the root item is a child of the
specified parent.
• No: uses the item specified by the
parent attribute as the
immediate parent of all items generated by this tag. If there is
no
parent attribute, use the query as the parent.
• A string: creates a root item and uses the specified string as
the item name; if you specify a
parent attribute, the root item
is a child of the specified parent.
expand Optional;
All
Yes • Yes: expands tree to show tree item children.
• No: keeps tree item collapsed.
Attribute Req/Opt;
Format
Default Description