Thank you for your question. Here is a better picture of the code ...
Look for the *-*for my comments*-*
<CFLOOP QUERY="blast_going_out">
<!--- SEND OUT E-MAILED LOOP --->
<cfmail to="[EMAIL PROTECTED]" from="XTZ COMPANY" subject="My Subscription:
#FORM.blast_name_form#">
#blast_going_out.embl_email#
Dear #blast_going_out.embl_name#,
email_id=#blast_going_out.email_blas_id#
*-*THE ABOVE VARIABLE PARSES CASUE IT'S HARDCODED*-*
#FORM.blast_text_form#
*-*THE SAME VARIABLE THAT'S COMING FROM A FORM TEXT FIELD DOESN'T PARSE*-*
*-*INSTEAD I GET THE EXTACT TEXT #blast_going_out.email_blas_id#*-*
*-*ANY ADVICE WOULD BE GREAT !!! *-*
</cfmail>
</CFLOOP>
>Is the call to the template containing the <CFMAIL> tag in the same
>request as the <CFLOOP> running the query. If so are you doing either
>a redirect <CFLOCATION> or an abort before the <CFMAIL> code runs?
>
>Kind Regards - Mike Brunt
>Original Message -----------------------
>All,
>
>INTRODUCTION:
>
>I have an mass e-mail tool that I created and within the outgoing text
>
>of the blast, there are hyperlinks. (displayed in a text field - admin
>tool)
>
>In these hyperlinks are #queryname_1.column_name# values. Queryname_1
>is
>the name of the quey I'm looping through to send out all the e-mails.
>
>PROBLEM:
>Within CFLOOP, I loop through each e-mail address from my e-mail
>database
>query. If I hardcode the variables within the hyperlink within the
>cfmail
>tag the value=#queryname_1.column_name# get's parsed and I can see the
>query
>values. However, when the same value=#queryname_1.column_name# is
>inserted in
>the CFMAIL tag, after retreiving the text form field from the database,
>
>the values are NOT parsed and I only get extact text ...
>
>value=#queryname_1.column_name# instead.
>
>How can I get the variables to parse out their values?
>
>The code within the CFMAIL tag ...
>
>FORM.blast_text_form IS THE TEXT BOX FORMNAME FROM THE FORM
>THAT GENERATES THE SENDING OF THE MASS EMAIL
>
>*****CODE***LEVEL*********************************************
>
>
>Dear #blast_going_out.embl_name#,
>
>blast_id=#check_BLAST_SENT_b4_sending_email.
>email_blast_sen_id#&email_id=#blast_
>going_out.email_blas_id#
>
>#FORM.blast_text_form#
>
>
>**END***CODE***LEVEL*********************************************
>
**B>EGIN***EMAIL***GENERATED*********************************************
>
>Dear Ralph Pill,
>
>blast_id=8&email_id=8785
>
>blast_id=#check_BLAST_SENT_b4_sending_email.
>email_blast_sen_id#&email_id=#blast_
>going_out.email_blas_id#
>
>
>*****EMAIL***GENERATED*********************************************
>
>Thanks
>
>-D
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
