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.
Category List functions, String functions
Function syntax
    ListValueCount(list, value [, delimiters ])
See also ListValueCountNoCase; "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>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>

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