Adobe ColdFusion 8

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 the ColdFusion Developer's Guide

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. The default value is comma.

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

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>