ListValueCountNoCase

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

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 --->
<!--- 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="HRApp">
SELECT     Department_ID
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="1">
                Training
            </OPTION>    
            <OPTION VALUE="2">
                Marketing
            </OPTION>    
            <OPTION VALUE="3">
                HR
            </OPTION>    
            <OPTION VALUE="4">
                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_ID)>
    <CFSET numberInDepartment = ListValueCountNoCase(myList, 
form.departmentName)> 

    <CFOUTPUT>
    <P>There are #numberInDepartment# people in
    </CFOUTPUT> 
    <CFIF FORM.DepartmentName Is "1">
    Training.
    <CFELSEIF FORM.DepartmentName Is "2">
    Marketing.
    <CFELSEIF FORM.DepartmentName Is "3">
    HR.
    <CFELSEIF FORM.DepartmentName Is "4">
    Sales.
    <CFELSE>
    Try again.
    </CFIF>
</CFIF>

</BODY>
</HTML>