There is an undocumented cfusion_encrypt() that will only return alpha-numeric values.
-----Original Message----- From: Joel Black [mailto:[email protected]] Sent: Thursday, October 15, 2009 3:54 PM To: cf-talk Subject: Coldfusion Encrypt and Insert quotation mark issue I am using the encrypt function to encrypt passwords going into and out of my database. I ran into an issue on a password that was one of the characters was encrypted to a ", which messed up my insert. "#encrypt(form.password,00000)#" ended up as "19$h#1".y " The extra " ended my string too early, which threw an error. Any idea how to keep this from happening? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

