Pass encrypted text to SQL database from a form.

[steveh1234]

Move the key and 3 encyption lines to directly above your CFQUERY tag and
encypt the form values

<CFSET key = "98q34jt">
<CFSET encrypted1 = encrypt(form.name, key)>
<CFSET encrypted2 = encrypt(form.number, key)>
<CFSET encrypted3 = encrypt(form.question, key)>

Then, inside your query, insert the encrypted values like
<cfif IsDefined("FORM.name") AND #FORM.name# NEQ "">
'#encrypted1#'
<cfelse>
NULL
</cfif>

Just make sure that your DB columns are large enough to hold the new encrypted
values.

[JanSke]

That worked perfectly!! Thank you so much!!