Note that an empty value will cause the IN statement to fail, so depending on the input I sometimes need to do something like this:
SELECT stuff FROM somewhere <cfif listLen(form.listOfIDs)> WHERE id IN (<cfqueryparam list="true" value="#Form.ListOfIds#" cfsqltype="cf_sql_integer"/>) </cfif> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328777 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4