> OK... so, just to verify what we're looking for here > (again 8^>): The data > is submitted to CF Server in clear text, CF encrypts the > data and inserts it > into the DB. At some later point, an external app queries > the DB, decrypts > the data, and writes it to a flat file. Is that right?
hehe... No, the 2nd app is SQL Server. :) Although if the encryption software has a command-line interface, I can probably use that from SQL Server. > The solution, IMO, is to use an encryption algorithm that > is available to > both CF and this external app. Again, not being a > practiced COM guy, I'm > not going to get into COM (since I like to sound halfway > intelligent when I > write). But you could try finding another external app > that allows > encryption decryption from the command-line. CF could use > CFEXECUTE to call > this app to encrypt the data and the other application > could call it for > decryption. Or, find an algorithm that is supported via a > CF_tag and has a > "sibling" that can be called from your other app. You'd > just have to make > sure that both CF and the other app are using the same > encryption/decryption > keys. Yep, that's the thinking. :) > For example: > Blowfish > http://devex.macromedia.com/developer/gallery/info.cfm?ID= > CA347367-2830-11D4 > -AA9700508B94F380&method=Full > > Rijndael or 3DES > http://devex.macromedia.com/developer/gallery/info.cfm?ID= > 67CBD343-A003-11D5 > -83F600508B94F85A&method=Full > > You're on your own for finding the non-CF versions though > 8^). Good luck. Thanks. :) Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
