Where is #first_name# coming from?  Your query?  IF so, make sure you're
referencing the query in the CFMAIL tag.  Is it from a form?  IF so, make it
#FORM.first_name#.  Is it from another query?  IF so, reference that query
in the output call.
#QueryName.first_name#

It works for me.

Dave


=================================
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



----- Original Message -----
From: "Lon Lentz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 26, 2000 12:29 PM
Subject: RE: substituting variables in a variable



  I've tried this before with no luck. I use place holders and do replaces
on those values.



Lon Lentz
Applications Developer - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210

-----Original Message-----
From: Neil Peaslee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 10:17 AM
To: cf-talk
Subject: substituting variables in a variable


I am trying to set up a mail system that can grab text from a database and
insert it into a mail message. I also need to customize the text of the
message (e.g. Dear #first_name# evaluates to Dear John). The problem arises
when I insert the mail text variable into the <cfmail> tag. The variables
that are contained in the text message are not evaluated.
<cfmail ..>
#mail_message#
</cfmail>
This will output "Dear #first_name#, ..."

How do I get the sub variable to be evaluated?

Thanks in advance,
Neil

----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to