ListValueCountNoCase |
Description
Counts instances of a specified value in a list. The search is case-insensitive.
Returns
The number of instances of value in the list.
Category
List functions
Function 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>

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.