No need at all for the cfloop. When you provide the query to cfmail it does the loop for you.
On Sun, Dec 2, 2012 at 4:35 PM, Eric Bourland <[email protected]> wrote: > > Matt, thanks for that. I made progress. I read up on the query attribute of > CFMAIL. But after doing some research, I did find another way to make this > application work: CFLOOP. This seems to be working fine -- but do you > recommend another way? I could not figure out how the query attribute of > CFMAIL would help me in this case -- I am sure I am just missing something > very obvious. =) Thank you again for your help. Eric > > <!--- is form.doRemind defined? ---> > <cfif IsDefined("FORM.doRemind")> > > <!--- begin to loop through query ---> > <cfloop query="NotPaid"> > > <cfmail > server="#REQUEST.MailingListServer#" > from="[email protected]" > to="#NotPaid.UserEmail#" > subject="NNVAWI Membership Dues Reminder" > username = "username" > password = "#REQUEST.MailingListAdminPass#" > SpoolEnable="No" > type="html"> > > <h1>Greetings, #NotPaid.FirstName# #NotPaid.LastName#.</h1> > > <p>This is a friendly reminder to pay your NNVAWI membership dues for > the current year. You may do so here at the secure authorize.net payment > page: > > </cfmail> > > </cfloop> > <!--- close cfloop ---> > > </cfif> > <!--- / is form.doRemind defined? ---> > > -----Original Message----- > From: Matt Quackenbush [mailto:[email protected]] > Sent: Sunday, December 02, 2012 4:16 PM > To: cf-talk > Subject: Re: question about lists and CFMAIL > > No, not on the right track. Look at the query attribute of <cfmail>. That's > what you want to use. > > > http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e08 > 11cbec22c24-7f8e.html > > HTH > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
