Hi people,
Is there a / what is the way to query a list of values ?
some_list = '1,2,3,4,5'
some_list could also be null or any length.
<cfif some_list IS NOT NULL>
SELECT some_id, some_name
FROM some_table
WHERE some_id = any of the list values of some_list
</cfif>
So that that query would return five rows in this case ?
I can do a cfml-loop around the query according to the list length for each
value but that means a I do an x number of queries instead of just one.
??,
Aarni
--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------