Trying to evaluate a cf variable from a text field

[minotaur77]

I am trying to add a personal touch to emails using the cfmail tag. What I want to do is include in the header of the newletter the persons first name and/or company. I want to be able to evaluate the text field replacing all cf variable listed in it with the corresponding values from the query. Here is the code:
<cfloop query=&quot;GetEmails&quot;>
<cfquery name=&quot;GetEmail&quot;>
SELECT *
FROM LogixNewsletter
WHERE HTML <> 0
AND Subscribed <> 0
AND Email = '#Email#'
</cfquery>


<CFMAIL query=&quot;GetEmail&quot; TO=&quot;#GetEmail.Email#&quot; FROM=&quot;#Form.From#&quot;
SUBJECT=&quot;#Form.Subject#&quot; TYPE=&quot;HTML&quot;>
#FORM.nltext#</CFMAIL>
</cfloop>

I want to evaluate the variable #form.nltext# so that an instance of #FirstName# in the text value of the field would be replaced with the persons name.

 

[iza]

use cfreplace then !

 

[minotaur77]

Huh? I don't know what version you are using, but I don't have that tag.

 

[minotaur77]

I did end up getting it to work, and this is how:

<cfloop query=&quot;GetEmails&quot;>
<cfquery name=&quot;GetEmail&quot; datasource=&quot;TAGSQL&quot; username=&quot;cfuser&quot; password=&quot;jallaire&quot;>
SELECT *
FROM LogixNewsletter
WHERE HTML <> 0
AND Subscribed <> 0
AND EmailID = #GetEmails.EmailID#
</cfquery>
<cfset SearchItem = &quot;##&quot;>
<cfloop query=&quot;GEtEmail&quot;>
<cfset Location = 1>
<cfset TempText = #form.nltext#>
<cfloop CONDITION=&quot;#Location# gt 0&quot;>
<cfset Location = Find(#SearchItem#,#TempText#, #Location#)>
<cfif Location gt 0>
<cfset Start = Location>
<cfset Location = Find(#SearchItem#,#TempText#, #Start#+1)>
<cfset End = Location + 1>
<cfset FieldName = Mid(#TempText#, #start#, Evaluate(&quot;#End# - #Start#&quot)>
<cfset ValueForField = evaluate(#FieldName#)>
<cfset TempText = Replace(#TempText#, #FieldName#, #ValueForField#, &quot;ALL&quot>
<cfset Location = Find(#ValueForField#, #TempText#, #start#)>
</cfif>
</cfloop>
<CFMAIL query=&quot;GetEmail&quot; TO=&quot;#GetEmail.Email#&quot; FROM=&quot;#Form.From#&quot;
SUBJECT=&quot;#Form.Subject#&quot; TYPE=&quot;HTML&quot;>
#TempText#</CFMAIL>
</cfloop>
</cfloop>

 

[ded]

Try #Evaluate('#FORM.nltext#')#

 

[minotaur77]

In response to ded's message: I tried that at first, but will not work due to the text present before and after. The evaluate results in an error, for example, #Evaluate(&quot;Hi #firstname# #lastname#, how are you?&quot# generates errors due to the &quot;Hi &quot; in the beginning. The evaluate tag wants to do more than just replace the fields values, it wants to evaluate it as an expression, which the text field is not.