User Guide

408 Chapter 2: ColdFusion Tags

Example

<!--- This example shows the use of cfswitch and cfcase to

exercise a case statement in CFML. --->

SELECT Emp_ID, FirstName, LastName, EMail, Phone, Department

FROM Employees

</cfquery>

<h3>cfswitch Example</h3>

<!--- By outputting the query and using cfswitch, we classify the

output without using a cfloop construct. --->

Each time the case is fulfilled, the specific information is printed;

if the case is not fulfilled, the default case is output

#FirstName# #LastName# is in sales

</cfcase>

#FirstName# #LastName# is in accounting

</cfcase> <cfcase value="Administration">

#FirstName# #LastName# is in administration

</cfcase>

#FirstName# #LastName# is not in Sales, Accounting, or

Administration.

</cfdefaultcase>

</cfswitch>

</cfoutput>