
Contents > CFML Reference > ColdFusion Functions > ListValueCountNoCase

ListValueCountNoCase

Counts instances of a specified value in a list. The search is case-insensitive.

The number of instances of value in the list.

List functions

ListValueCountNoCase(list, value [, delimiters ])

ListValueCount

Parameter	Description
list	A list or a variable that contains one.
value	String or number or a variable that contains one. Item for which to search. The search is case-insensitive.
delimiters	A string or a variable that contains one. Character(s) that separate list elements. Default: comma. If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.

Parameter

Description

list

A list or a variable that contains one.

value

String or number or a variable that contains one. Item for which to search. The search is case-insensitive.

delimiters

A string or a variable that contains one. Character(s) that separate list elements. Default: comma.

If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.

<cfquery name = "SearchByDepartment" datasource = "cfsnippets">
SELECT    Department
FROM    Employees
</cfquery>

<h3>ListValueCountNoCase Example</h3>
<p>This example uses ListValueCountNoCase to count employees in a department.

<form action = "listvaluecountnocase.cfm">
<p>Select a department:</p>
   <select name = "departmentName">
         <option value = "Accounting">
            Accounting
         </OPTION>   
         <option value = "Administration">
            Administration
         </OPTION>   
         <option value = "Engineering">
            Engineering
         </OPTION>   
         <option value = "Sales">
            Sales
         </OPTION>                     
   </select>
   </select>
<input type = "Submit" name = "Submit" value = "Search Employee List">
</form>
<!--- wait to have a string for searching defined --->
<cfif IsDefined("FORM.Submit") and IsDefined("FORM.departmentName")>
   <cfset myList = ValueList(SearchByDepartment.Department)>
   <cfset numberInDepartment = ListValueCountNoCase(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>


Contents > CFML Reference > ColdFusion Functions > ListValueCountNoCase

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functb23.htm