ListValueCountNoCase

Description

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

Return value

The number of instances of value in the list.

Category

List functions

Syntax

ListValueCountNoCase(list, value [, delimiters ]) 

See also

ListValueCount

Parameters

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.

Example

<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>

Comments