ListValueCount

Description

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

Returns

The number of instances of value in the list.

Function syntax

ListValueCount(list, value [, delimiters ])

See also

ListValueCountNoCase; Lists in the Developing ColdFusion Applications

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

delimiters

A string or a variable that contains one. Characters 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>ListValueCount Example</h3> 
<p>This example uses ListValueCount to count employees in a department. 
 
<form action = "listvaluecount.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> 
<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 = ListValueCount(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>