ListValueCount

Returns the number of instances of a specified value in a list. The underlying search that finds the instances is case-sensitive.

Syntax

ListValueCount(list, value [, delimiters ])

list

A list or the name of a list that is to be searched.

value

The string or number that the function is to find and count.

delimiter

Optional. Specify the character(s) used to delimit elements in the list. The default is a comma ( , ).

Example

<!--- This example uses ListValueCount to see how many 
      employees are in a department --->
<HTML>
<HEAD>
<TITLE>ListValueCount Example</TITLE>
</HEAD>

<body  bgcolor="#FFFFD5">

<CFQUERY NAME="SearchByDepartment" DATASOURCE="cfsnippets">
SELECT     Department
FROM     Employees
</CFQUERY>

<H3>ListValueCount Example</H3>
<P>This example uses ListValueCount to see how many employees 
are in a department.

<FORM ACTION="listvaluecount.cfm" METHOD="POST">
<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>

</BODY>
</HTML>

CFML Language Reference
Chapter 2 : ColdFusion Functions