Querying a list of values

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
--------------