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; "Lists" in Chapter 3, "Using ColdFusion Variables," in ColdFusion MX Developer's Guide
Parameters
Example
    <cfquery name = "SearchByDepartment" datasource = "cfdocexamples">
    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. The default value is comma.

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