User Guide

ListFind 569
ListFind
Description
Determines the index of the first list element in which a specified value occurs. Case-sensitive.
Returns
Index of the first list element that contains value, with matching case. If not found, returns zero.
The search is case-sensitive.
Category
List functions
Function syntax
ListFind(list, value [, delimiters ])
See also
ListContains, ListFindNoCase
Parameters
Usage
ColdFusion ignores empty list elements; thus, the list "a,b,c,,,d" has four elements.
Example
<!--- Uses ListFind and ListFindNoCase to see if a substring exists in a list -
-->
<form action="./listfind.cfm" method="POST">
<p>Try changing the case in Leary's last name:
<br><input type="Text" size="25" name="myString" value="Leary">
<p>Pick a search type:
<select name="type">
<option value="ListFind" selected>Case-Sensitive
<option value="ListFindNoCase">Case-Insensitive
</select>
<input type="Submit" name="" value="Search Employee List">
</form>
<!--- wait to have a string for searching defined --->
<cfif IsDefined("form.myString") and IsDefined("form.type")>
<cfquery name="SearchEmpLastName" datasource="cfsnippets">
SELECT FirstName, RTrim(LastName) AS LName, Phone, Department
FROM Employees
</cfquery>
<cfset myList = ValueList(SearchEmpLastName.LName)>
Parameter Description
list A list or a variable that contains one
value A string, a 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.
Default: comma.
If this parameter contains more than one character, ColdFusion processes each
occurrence of each character as a delimiter.