Professional Web Applications Themes

Problem evaluating text from within a cfmail tag usingthe query parameter - Coldfusion - Advanced Techniques

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 ...

  1. #1

    Default Problem evaluating text from within a cfmail tag usingthe query parameter

    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>

    MikeyMike1981 Guest

  2. #2

    Default Re: Problem evaluating text from within a cfmail tagusing the query parameter

    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


    MikerRoo Guest

Similar Threads

  1. MSDE and Text Query Problem
    By BenDC in forum Coldfusion Database Access
    Replies: 1
    Last Post: August 21st, 09:11 PM
  2. query in cfmail
    By stormnikki98 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: June 30th, 01:14 AM
  3. query results in cfmail
    By Anderson in forum Macromedia ColdFusion
    Replies: 0
    Last Post: June 7th, 05:14 PM
  4. Query string and Parameter Passing Problem
    By Paul Gray via DotNetMonster.com in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: May 14th, 04:00 PM
  5. MS Access d/b saved parameter query problem
    By Larry Rekow in forum ASP Database
    Replies: 3
    Last Post: August 3rd, 07:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139