Problem evaluating text from within a cfmail tag usingthe query parameter

[MikeyMike1981]

Hi

I'm trying to decrypt a string using text returned from a query and wondered
if anyone knows what I need to do...

I've tried adding <pre> tags and using the #Evaluate# function but I don't
seem to be getting it right....

Anyone got any ideas?

Cheers

Michael




<cfmail query="Q_GetUserDetails"
from="person@email.co.uk>"
to="#EmailAddress#"
subject="A title"
type="html"
failto="failto@email.co.uk">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif;
font-weight:bold; font-size:14pt; color:##0066CC">
A Title</div>
<BR>
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12pt;
color:##0066CC">
Dear #firstName# #surname#
<BR><BR>
Some text.
<BR>
<BR>
To access these areas of the site, please go to:
<BR><BR>
<a href="http://www.websiteurl.co.uk/login.cfm" target="_blank" name="url
Site">http://www.websiteurl.co.uk/login.cfm</a>
<BR><BR>
Your username: #EmailAddress#
<BR><BR>
Your password: #Evaluate(Decrypt(WebPassword, EmailAddress))#
</div>
</cfmail>

[MikerRoo]

You're using the email address as the encrytion key?

If that is so, then all you need for the password line is this:

Your password: #Decrypt (WebPassword, EmailAddress)#

If that is not so, then please show the code you use to Encrypt the the
password.

If it is still not working, please show the results or error message that you
get.

Also, are you specifying an algorithm or using the default?
What is the size of your database column for the password? It is possible
that the encrypted value is getting truncated.

-- MikeR