Macromedia coldfusion 4.5-cfml language reference User Manual

Page of 608
226
CFML Language Reference 
<HEAD>
<TITLE>
CFTREE Example
</TITLE>
</HEAD>
<BODY>
<H3>CFTREE Example</H3>
<!--- Use CFFORM when using other CFINPUT tools --->
<CFFORM ACTION="cftree.cfm" METHOD="POST" ENABLECAB="Yes">
<!--- Use CFSELECT to present the contents of the query by column --->
<H3>CFSELECT Presentation of Data</H3>
<H4>Click on an employee’s last name and hit "see information for
this employee" to see expanded information.</H4>
<CFSELECT NAME="EmployeeNames" MESSAGE="Select an Employee Name"
SIZE="#getEmployees.recordcount#" QUERY="GetEmployees"
    VALUE="LastName" REQUIRED="No">
<OPTION value="">Select All
</CFSELECT>
<INPUT TYPE="Submit" NAME="" VALUE="see information for this employee">
<!--- showing the use of CFTREE --->
<!--- Use CFTREE for an expanded presentation of the data --->
<!--- Loop through the query to create each branch of the CFTREE --->
<H3>CFTREE Presentation of Data</H3>
<H4>Click on the folders to "drill down" and reveal information.</H4>
<P>CFTREEITEM is used to create the "branches" of the tree.
<P>
<CFTREE NAME="SeeEmployees" HEIGHT="150" WIDTH="240" 
FONT="Arial Narrow" BOLD="No" 
ITALIC="No" BORDER="Yes" 
HSCROLL="Yes" VSCROLL="Yes" 
REQUIRED="No" COMPLETEPATH="No" 
APPENDKEY="Yes" HIGHLIGHTHREF="Yes">
<CFLOOP QUERY="GetEmployees">
<CFTREEITEM VALUE="#Emp_ID#" PARENT="SeeEmployees" EXPAND="No">
<CFTREEITEM VALUE="#LastName#" DISPLAY="Name" 
PARENT="#Emp_ID#" QUERYASROOT="No" 
EXPAND="No">
<CFTREEITEM VALUE="#LastName#, #FirstName#" 
PARENT="#LastName#" EXPAND="No" 
QUERYASROOT="No">
<CFTREEITEM VALUE="#Department#" DISPLAY="Department"
PARENT="#Emp_ID#" QUERYASROOT="No" 
EXPAND="No">
<CFTREEITEM VALUE="#Department#" PARENT="#Department#" 
EXPAND="No" QUERYASROOT="No">
<CFTREEITEM VALUE="#Phone#" DISPLAY="Phone" 
PARENT="#Emp_ID#" QUERYASROOT="No" 
EXPAND="No">
<CFTREEITEM VALUE="#Phone#" PARENT="#Phone#"