Making progress on this task. I'm getting an error about decoding. Here is my current insert statement:
CreditCardNumber = <cfqueryparam cfsqltype="cf_sql_varchar" value="#encrypt(form.CreditCardNumber,request.encryptionkey,"AES","UU")#"> When I submit my update form, I get this error: An error occurred while trying to encrypt or decrypt your input string: '' Can not decode string "(string value from request.encryption key)" So, in application.cfc, I think I need to set up a value for #request.encryption# that the AES / UU method is able to decode. What do you think is a good way for me to derive a value for #request.encryption# that the AES / UU method will understand? I hope this question makes sense. Thank you again for your advice. Eric -----Original Message----- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Sunday, November 04, 2012 9:58 PM To: cf-talk Subject: Re: encrypt / decrypt question Eric, A while back I was testing all the encryption and decryption types and wrote a short cfm page that let me do the testing. The code there is a good example of how it all works. Instead of trying to write it up and post here I created a very short and sweet blog post about this. http://www.trunkful.com/index.cfm/2012/11/4/Encryption-and-Decryption-in-Col dFusion I hope this helps. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm