Search from List contents...
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?
<cffunction name="test" access="remote" returnType="query">
<cfargument name="thisId" type="numeric" required="yes">
<cfquery name="testQuery" datasource="ourProducts" >
WHERE id = '#thisId#'