Equivalent to SQL IN operator in CF

[szeiss]

What would be the CF equivalent to the SQL 'IN' operator in coldfusion?

<cfif #variables.location# IN "LO","AU","SL">
<cfelse>
</cfelse>

Thanks,
SZ

 

[r937]

you forgot da parentheses

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[cfSearching]

The closest equivalent would be listFind/listFindNoCase:

<!--- note, no pound signs ie # needed --->
<cfif listFindNoCase("LO,AU,SL", variables.location)>



----------------------------------

http://cfsearching.blogspot.com/