Hi All. I have what may be a dumb question.
I am going through the process of encrypting passwords in an existing database but I am doing it via a CF template where I retrieve the top 50000 records, loop over them and update each record with an encrypted value. I know, I know.... I am doing it this way because I received some sort of HEAP error when I tried to update all of the records at once. I have been at this for 2 days now (there are millions of records) My question is, if I do the encryption via SQL, can I use CF to decrypt successfully when the user logs? Will the 2 match or will this be two totally different types of encryption? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm