I thought cfinsert and cfupdate escaped double quotes? SQL Server vchar fields - seems the answer is NOPE. CFINSERT will not accept Bob "Bubba" Jones as input into SQL Server vchar field. No problem with an nTEXT field though.
Any way around this without rewriting all my queries to use SQL inserts instead of cfinsert/cfupdate? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
