New item we recently discovered. It wasn't an issue with 7, but is an issue with 8, especially in view of the documentation. We have a password that we 'encrypt'ed into the db, using 6.1. We later 'decrypt' the password for use with a cfexecute call.
In 6.1, the Decrypt() function took two arguments, the encrypted string and the seed needed to decrypt it. CF 7 introduced better encryption features, requiring new optional arguments for the type of encoding and algorithm used. The CF 8 implementation also greatly improved encryption, and the documentation states that the same arguments are still optional. However, this broke for us on CF 8, and only through reviewing the documentation, and a little experimentation, did we discover that an algorithm of 'CFMX_COMPAT' and an encoding of 'Hex' were required in order to properly decrypt the password that had previously been encrypted by 6.1. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com Nathan Wells wrote: > I posted this issue on Adobe's forums a couple of days ago, but I haven't had > any (good) responses. > > I recently started testing our code, which is running on 6.1, on ColdFusion > 8. Almost immediately, I started getting errors. It was quickly obviously > that it was due to a change in the behavior of the QuerySetCell function. > Sure enough, when I check out that function on the livedocs, it says: > > ColdFusion MX 7: Changed the behavior of the function so that it does type > validation. > > Okay, great... A behavioral change in ColdFusion. Everything I've heard > from Adobe and CF user groups is that there are no changes between 6.1, 7.0, > and 8.0. The word was that features have been added and improved, but none > of the existing features were changed. Obviously that isn't true. So what > other changes do I need to be aware of? Is there a conclusive changelog > somerwhere? There should be. I don't want to scan the entire documentation > looking for changes. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4