Hi, Have an interesting problem. I'm using Encrypt() to store sensitive user data in SQL Server. On some strings, the function is encrypting with a single quote as one of the chars. This is causing a SQL error when I'm trying to either enter or retrieve the data with cfquery.
Has anyone run across this problem? Can anyone offer a workaround? Thanks, James ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
