Yeah, thanks Jason... I've run into that and set a condition on running the query
>>> "Jason Fisher" <ja...@wanax.com> 12/2/2009 10:25 AM >>> 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:328779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
