User Guide
Chapter 2: ColdFusion Functions 433
ListValueCountNoCase
Returns the number of instances of a specified value in a list. The underlying search
that finds the instances is not case-sensitive.
See also ListValueCount.
Syntax ListValueCountNoCase(
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 ListValueCountNoCase to see how many
employees are in a department --->
<HTML>
<HEAD>
<TITLE>ListValueCountNoCase Example</TITLE>
</HEAD>
<body bgcolor="#FFFFD5">
<CFQUERY NAME="SearchByDepartment" DATASOURCE="cfsnippets">
SELECT Department
FROM Employees
</CFQUERY>
<H3>ListValueCountNoCase Example</H3>
<P>This example uses ListValueCountNoCase to see how many employees
are in a department.
<FORM ACTION="listvaluecountnocase.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