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********************************************* **BEGIN***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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
