User Guide

ManualsBrandsMacromedia ManualsOtherCOLDFUSION MX 61-CFML REFERENCE

ListValueCount 591

<cfif IsDefined("FORM.Submit") and IsDefined("FORM.departmentName")>

<cfset myList = ValueList(SearchByDepartment.Department)>

<cfset numberInDepartment = ListValueCount(myList, FORM.departmentName)>

<cfif numberInDepartment is 0>

<h3>There are no employees in <cfoutput>#FORM.departmentName#</cfoutput></

h3>

<cfelseIf numberInDepartment is 1>

<cfoutput><p>There is only one person in #FORM.departmentName#.

</cfoutput>

<cfelse>

<cfoutput><p>There are #numberInDepartment# people in

#FORM.departmentName#.

</cfoutput>

</cfif>

</cfif>