Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
hoddle10 #1
Encrypt returning strange results
I am using encrypt to hide user passwords while in a mysql database (stored in
a text field although I have also tried varchar). It seems to work fine but
there are some exceptions. I am using the following code -
Encryption before entry to the database
<cfset Encrypted = Encrypt(trim(form.password), Request.PasswordKey)>
<cfset form.password = #Encrypted#>
Decryption
#Decrypt(get_customer.password,Request.PasswordKey )#
I get a problem with password strings that have 5 or 8 characters and end in
the letter t. When decrypted the string reads ok except for the last character
which is replaced with {.
eg trust = trus{
I have changed the seed (passwordkey string) and this solves the current
problem. But my problem now is that this was only found after numerous entries
into the database, so changing the seed will mean I have to re enter all the
passwords (something I would like to avoid). I'm not really sure if this is
even worth doing as I may find that I get a similar problem on different
string. The documentation states that the seed parameter 'Can be any
combination of any number of characters' , so I am unsure why I am getting this
problem.
Any help on what is causing this problem or how to solve it would be greatly
appreciated.
Adrian
hoddle10 Guest
-
Recordset returning inconsistent results
I am developing a php site using mysql and apache. I have finally managed to get a database connection and am trying now to create some... -
SQL Query Not Returning Correct Results
I am trying to pull all records that are set for mailing and are from every state except for Nebraska and some counties in Iowa. It isn't pulling... -
Verity - cfsearch not returning results on subsequentgets
We have no problem returning results from searches with CF server 5. We are now moving to CF Server MX. With an initial search, the result set is... -
returning results in rows
I have a db with the fields Day, Month, Year and Message. How can I select all of the messages for the current week starting with sunday and return... -
Returning results where the match is not always there!!!
Hi All I have two tables that I need to match customer data on. The first table holds all of the customers billing info Title Name Address... -
niko1 #2
Re: Encrypt returning strange results
What version of CF are you using? As for the seed are you using the same seed
to decrypt as you encrypted? Also seeds generally expect a specific length
based on the algorithim. If you are not using CFMX 7 I dont think you have to
worry about that though. Can you create a new seed value and key and replicate
the issue and post the code, the seed value, adn the key?
niko1 Guest



Reply With Quote

