MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX, Reference

Page: 49 / 1108

cfbreak 49
cfbreak
Description
Used within a
cfloop
or
cfswitch
tag. Breaks out of a loop or switch block.
Category
Flow-control tags
Syntax
<cfbreak>
See also
cfabort
,
cfexecute
,
cfif
,
cflocation
,
cfloop
,
cfswitch
,
cfthrow
,
cftry
; “cfloop and
cfbreak” in Chapter 2, “Elements of CFML,” in ColdFusion MX Developer’s Guide
Example
<!--- This shows the use of cfbreak to exit a loop when a condition is met.--->
<!--- Select courses; use cfloop to find a condition; then break the loop. --->
<!--- Check that number is numeric. --->
<cfif IsDefined("form.course_number")>
<cfif Not IsNumeric(form.course_number)>
<cfabort>
</cfif>
</cfif>
<cfquery name="GetCourses" datasource="cfdocexamples">
SELECT *
FROM Courses
ORDER by course_number
</cfquery>
<p> This example uses CFLOOP to cycle through a query to find a value.
(In our example, a list of values corresponding to courses in the Snippets
datasource). When the conditions of the query are met, CFBREAK stops the loop.
<p> Please enter a Course Number, and hit the "submit" button:
<form action="cfbreak.cfm" method="POST">
<select name="courseNum">
<cfoutput query="GetCourses">
<option value="#course_number#">#course_number#
</cfoutput>
</select>
<input type="Submit" name="" value="Search on my Number">
</form>
<!--- If the courseNum variable is not defined,
don't loop through the query.--->
<cfif IsDefined ("form.courseNum") IS "True">
<!--- Loop through query until value found, then use CFBREAK to exit query.--->
<cfloop query="GetCourses">
<cfif GetCourses.course_number IS form.courseNum>
<cfoutput>
<h4>Your Desired Course was found:</h4>
<pre>#course_number# #descript#</pre>
</cfoutput>
<cfbreak>