Chapter 1: ColdFusion Tags
211
Example
<!--- This example illustrates the use of CFSWITCH and
CFCASE to exercise a case statement in CFML --->
<!--- query to get some information --->
<CFQUERY NAME="GetEmployees" DATASOURCE="cfsnippets">
SELECT Emp_ID, FirstName, LastName, EMail,
Phone, Department
FROM Employees
</CFQUERY>
<HTML>
<HEAD>
<TITLE>
CFSWITCH Example
</TITLE>
</HEAD>
<BODY bgcolor=silver>
<H3>CFSWITCH Example</H3>
<!--- By outputting the query and using CFSWITCH,
we can classify the output without using a CFLOOP construct.
--->
<CFOUTPUT QUERY="GetEmployees">
<CFSWITCH EXPRESSION=#Department#>
<!--- each time the case is fulfilled, the specific
information is printed; if the case is not fulfilled,
the default case is output --->
<CFCASE VALUE="Sales">
#FirstName# #LastName# is in <B>sales</B><BR><BR>
</CFCASE>
<CFCASE VALUE="Accounting">
#FirstName# #LastName# is in <B>accounting</B><BR><BR>
</CFCASE>
<CFCASE VALUE="Administration">
#FirstName# #LastName# is in <B>administration</B><BR><BR>
</CFCASE>
<CFDEFAULTCASE>#FirstName# #LastName# is not in Sales,
Accounting, or Administration.<BR>
</CFDEFAULTCASE>
</CFSWITCH>
</CFOUTPUT>
</BODY>
</HTML>
Summary of Contents for COLDFUSION 4.5-CFML LANGUAGE
Page 1: ...Allaire Corporation CFML Language Reference ColdFusion 4 5...
Page 207: ...Chapter 1 ColdFusion Tags 183 CFCATCH CFTRY BODY HTML...
Page 224: ...200 CFMLLanguageReference CFOUTPUT P Text within CFOUTPUT is always shown CFOUTPUT BODY HTML...
Page 336: ...312 CFMLLanguageReference CFIF BODY HTML...
Page 404: ...380 CFMLLanguageReference DE It is morning CFOUTPUT P BODY HTML...
Page 413: ...Chapter 2 ColdFusion Functions 389 Customer BalanceDue BR CFOUTPUT CFIF BODY HTML...
Page 483: ...Chapter 2 ColdFusion Functions 459 CFOUTPUT CFLOOP BODY HTML...
Page 584: ...560 CFMLLanguageReference...
Page 594: ...570 CFMLLanguageReference...
