Apparently though, these are not recommended for use as there is no
guarantee they will be included in the next versions of CF.
on 10/04/01 5:10, Lewis Steven at [EMAIL PROTECTED] wrote:
> You can also use: cfusion_encrypt() and cfusion_decrypt().
>
> cfusion_encrypt() encrypts the text to numbers and it is DB safe.
>
> Steve
>
> Will Swain wrote:
>>
>> 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
