RE: [KCFusion] cfmail

[Ellis, Randy]

Title: Message

If you have static information on the page (like the header and footer), try using CFFILE to help ease the work.  It also makes updating easier.   Example:   <cffile action = "" file = "c:\web\header.html" variable = "Header"> <cffile action = "" file = "c:\web\footer.html" variable = "Footer">   <CFSET EmailBody = variables.Header>   <CFOUTPUT QUERY="Info"> <CFSET EmailBody = EmailBody + "Question: " + Info.Question + " Answer: " + Info.Answer + "<BR>"> </CFOUTPUT>   <CFSET EmailBody = EmailBody + variables.Footer>     Randy Ellis City of Overland Park Senior Programmer Analyst -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Monday, May 24, 2004 2:13 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] cfmail I had actually considered that. Its a tad more complicated cause its and html formatted email so it would be one hell of a concatenated string which I was trying to avoid but I'll try it. I'll foward two examples so you can kind of see what it is supposed to look like. Its basicly a cleaner version of this page http://www.keys.org/1child_resources/perspectives/showtopic.cfm?Question=32     Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will ----- Original Message ----- From: Ellis, Randy To: [EMAIL PROTECTED] Sent: Monday, May 24, 2004 1:59 PM Subject: RE: [KCFusion] cfmail If you emailing a single person or the content of the CFMAIL body contains the same information for everyone, you can build the Body portion of the CFMAIL tag prior to using the CFMAIL tag. Example: <CFSET EmailBody = "">   <--- Perform a query, loop, etc. and add the results to the EmailBody variable: ---> <CFQUERY NAME="Info" DATASOURCE="Test"> SELECT * FROM TEST </CFQUERY> <CFOUTPUT QUERY="Info"> <CFSET EmailBody = EmailBody + "Question: " + Info.Question + " Answer: " + Info.Answer + "<BR>"> </CFOUTPUT>   <CFMAIL TO="" FROM=""> #variables.EmailBody# </CFMAIL>     Randy Ellis City of Overland Park Senior Programmer Analyst -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Monday, May 24, 2004 1:40 PM To: [EMAIL PROTECTED] Subject: [KCFusion] cfmail I am struggling with a work around for the cfmail tag. Im yanking some info that needs to be grouped properly the problem is I can't seem to do it right in a cfmail tag. ive got this   SELECT   table1.Category, table2.question, table3.answer, table4.url, table4.urlText, table2.question_ID FROM      table1, table2, table3, table4 WHERE  table1.cat_num = table2.cat_num AND table2.question_ID = table3.question_ID AND table2.question_ID *= table4.question_ID and table2.question_ID = #url.id#   the information from table1 and table2 only needs to come out once. the information from table3 and table4 need to come out grouped on table2.question_ID   I can't group in a loop and I can't leave the query attribute out of the mail tag and just use cfoutput cause it tosses and error. Im using CFMX on Win2k   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will