Are you sure that the problem isn't that you are using <input type="text"> instead of <textarea>?
I just ran a test on cfinsert with quoted values in CF7 against SQL Server 2000 and it inserted the quoted values without any problem. If you load values with quotes into an input box, then the value will be loaded into an attribute of the tag and the browser will interpret the value as the end of the attribute value. You might use HTMLEditFormat() or replace the quote with ". Steve Bryant 918-449-9440 Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ >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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
