User Guide

cfselect 391
Show the selected names. --->
<cfif IsDefined("form.employeeid")>
<!--- The form was submitted. --->
<h4>You Selected the following employees</h3>
<cfif form.employeeid IS "">
<!--- Select All option was selected. Show all employees. --->
<cfoutput query="GetAllEmployees">
#name#<br>
Email: #email#<br><br>
</cfoutput>
<cfelse>
<!--- Use a query of queries to get the data for the selected users.
Form.employeeid is a comma-delimited list of selected employee IDs. --->
<cfquery name = "GetSelectedEmployees" dbtype="query">
SELECT Emp_ID, EMail, Phone, Department, FirstName, LastName, FirstName
+' ' +lastName as Name
FROM GetAllEmployees
WHERE Emp_ID in (#form.employeeid#)
</cfquery>
<!--- Display the names and e-mail addresses from the query. --->
<cfoutput query="GetSelectedEmployees">
#firstName# #lastName#<br>
Email: #email#<br>
<br>
</cfoutput>
</cfif>
</cfif>
<!--- The cfform tag posts back to the current page. --->
<h3>Select one or more employees</h3>
<cfform action = "#CGI.SCRIPT_NAME#">
<!--- Use cfselect to present the query’s LastName column, grouped by
department.
Allow Multiple selections.--->
<cfselect
name = "employeeid"
size = "15"
multiple="yes"
required = "Yes"
message = "Select one or more employee names"
query = "GetAllEmployees"
group="Department"
display ="name"
value ="emp_id"
queryPosition="Below">
<!--- Add an option to select all employees. --->
<option value = "">Select All</option>
</cfselect><br><br>
<input type="Submit">
</cfform>