I’m trying to do some basic encryption for a password table in my database. I’m just testing the code right now before I commit. Here it is:`Çquery datasource="XXXXXX" name="q" sql="`
select username, pw from user
";
loop query="q"{
key = generateSecretKey('AES');
echo("Encrypted with ::>[ #key# ] - ")
enc = encrypt(pw, key, 'AES')
echo(enc & "<br><br>")
dec = decrypt(enc, key, 'AES')
echo("Decrypted with ::>[ #key# ] - #dec#<hr>")
}
</cfscript>