Search from List contents...

["C-Rock"]

I wish to have a list of product ids that I can select the desired info from 
the database on each and it all be part of the same query. How do I do this for 
a list of ids?

 normally it's what I have below, so how can I amend this to take a numeric 
list of products and select all for each id in the list?

 Thanks!


 <cffunction name="test" access="remote" returnType="query">
   <cfargument name="thisId" type="numeric" required="yes">
   <cfquery name="testQuery" datasource="ourProducts" >
        SELECT *
        FROM products
        WHERE id = '#thisId#'
 </cfquery>
   <cfreturn testQuery>
 </cffunction>