Your problem there is the numeric ContactType field - if it is missing, you get an empty item between the two commas, which is invalid SQL syntax.
You can solve it with cfqueryparam by setting the null property based on whether it contains a numeric value or not: <cfqueryparam value="#transferData.ContactType#" cfsqltype="cf_sql_integer" null="#NOT IsNumeric(transferData.ContactType)#" /> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:323536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
