User Guide

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