Thanks Zach,
I'll have a look at that
Cheers
Will
-----Original Message-----
From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 19:26
To: CF-Talk
Subject: RE: encrypt/decrypt
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The values that the CF Encrypt function creates usually aren't safe to
put into a database -- they're binary values if my memory serves
correctly. The error you're getting is because Decrypt throws an error
if the value it gets isn't a valid value made by the Encrypt functions.
Before you put your values into the DB, you need to convert them to text
only values. URLEncodedFormat() would work. ToString() would probably
work too. Then when you pull the value back out of the DB, you just
URLDecode() it. I'm not sure how you turn ToString() back to it's
original form. I thought it was ToBinary() or something, but I don't
see that in my quickref book....
To guard against crashes b/c of modified, corrupted values, just
surround your Decrypt() function call in a CF Try block & handle it
accordingly.
<!--- Encryption: --->
<Cfset Gibberish = URLEncodedFormat(Encrypt(Secrect, Password)>
<cfquery name="DontTellAnyone" blah>
INSERT INTO Table (Secret) VALUES( '#Gibberish#'
</cfquery>
<!--- Decryption: --->
<Cfquery name="GetSecret" blah>
SELECT Secret
FROM Table
WHERE ...
</cfquery>
<Cftry>
<cfset Secret = Decrypt(URLDecode(GetSecret.Secret), Password)>
<cfset DecryptOK = True>
<Cfcatch type="any">
<cfset DecryptOK = false>
</cfcatch>
</cftry>
<cfif DecryptOk>
<Cfoutput>The secret word is: #Secret#</cfoutput>
<cfelse>
<cfoutput>Something broke...</cfoutput>
</cfif>
Hope that's helpful.
Best regards,
Zac Bedell
> -----Original Message-----
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 7:16 AM
> To: CF-Talk
> Subject: encrypt/decrypt
>
>
> Hi guys,
>
> Got an interesting one here. I am encrypting some details
> before entering
> them in a databse, then decrypting them as the authorised views them.
>
>
> However, I am getting this error on decryption:
>
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
>
>
> decryptednumber = decrypt(encryptednumber, numberkey)
>
>
>
> Error near line 25, column 8.
> --------------------------------------------------------------
> --------------
> ----
>
> The value to be decrypted is not valid
>
>
> This is the code I have in that location. Interestingly,
> decrtypting the
> name doesn't seem to cuase a problem:
>
> <cfset numberkey = "eagles">
>
> <cfset namekey = "selhurst">
>
> <cfset encryptedname = #getdetails.name#>
>
> <cfset encryptednumber = #getdetails.number#>
>
> <cfset decryptednumber = decrypt(encryptednumber, numberkey)>
>
> <cfset decryptedname = decrypt(encryptedname, namekey)>
>
>
> This is the code on another page that encrypts the values:
>
> <cfset numberkey = "eagles">
>
> <cfset namekey = "selhurst">
>
> <cfset encryptednumber = encrypt(value_number, numberkey)>
>
> <cfset encryptedname = encrypt(value_name, namekey)>
>
> Any ideas on this anyone??
>
> TIA
>
> Will Swain
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
