LISTCONTAINSNOCASE  
Description

Determines the index of the first list element that contains a specified substring.

 
Returns

Index of the first list element that contains substring, regardless of case. If not found, returns zero.

 
Category

List functions

 
Function syntax
ListContainsNoCase(list, substring [, delimiters ])
 
See also

ListContains, ListFindNoCase; "Lists" in Chapter 3, "Using ColdFusion Variables," in ColdFusion MX Developer's Guide

 
Parameters

 
Usage

ColdFusion ignores empty list elements; thus, the list "a,b,c,,,d" has four elements.

 
Example
<h3>ListContainsNoCase Example</h3>
<cfif IsDefined("form.letter")>
   <!--- First, query to get some values for our list --->
   <cfquery name="GetParkInfo" datasource="cfdocexamples">
      SELECT PARKNAME,CITY,STATE
      FROM Parks
      WHERE PARKNAME LIKE '#form.letter#%'
   </cfquery>
   <cfset tempList = #ValueList(GetParkInfo.City)#>
   <cfif ListContainsNoCase(tempList, form.yourCity) is not 0>
      There are parks in your city!
   <cfelse>
      <p>Sorry, there were no parks found for your city.
      Try searching under a different letter.
   </cfif>
</cfif>

A list or a variable that contains one.

LIST  

A string or a variable that contains one. The search is case-insensitive.

SUBSTRING  

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.

DELIMITERS