Compare Encrypted String Using SQL

i have data encrypted in sql.

 

i want use command in sql compare submitted form value encrypted value in table.

 

how can this?

 

<cfquery>

select *

from table

where decrypt(name,key) = '#form.name#'

</cfquery>

 

of course decrpyt not work in example above gives error. how can achieve results without error?

 

thanks.

 

chuck

your encryption/decryption needs happen entirely in database

layer work. because didn't database are

using:

- far know ms sql doesn't have encryption functions;

- mysql can encrypt using des algorithm (maybe others also, you'll

need check manual).

 

mack

More discussions in Advanced Techniques

adobe