question about lists and CFMAIL

2012-12-02 Thread Eric Bourland
ColdFusion 9.0.2 MS SQL Server 2005 Greetings. I have a question about lists and CFMAIL. I need to send an email message to all email addresses in a data table that are not marked PaidDues. First, I query the data table to find all records with PaidDues = False (or 0). !--- ask for userIDs

Re: question about lists and CFMAIL

2012-12-02 Thread Matt Quackenbush
MS SQL Server 2005 Greetings. I have a question about lists and CFMAIL. I need to send an email message to all email addresses in a data table that are not marked PaidDues. First, I query the data table to find all records with PaidDues = False (or 0). !--- ask for userIDs who have not paid

RE: question about lists and CFMAIL

2012-12-02 Thread Eric Bourland
[mailto:quackfu...@gmail.com] 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

Re: question about lists and CFMAIL

2012-12-02 Thread Matt Quackenbush
payment page: /cfmail /cfloop !--- close cfloop --- /cfif !--- / is form.doRemind defined? --- -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Sunday, December 02, 2012 4:16 PM To: cf-talk Subject: Re: question about lists and CFMAIL

Re: question about lists and CFMAIL

2012-12-02 Thread Dean Lawrence
? --- -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] 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

RE: question about lists and CFMAIL

2012-12-02 Thread Eric Bourland
No need at all for the cfloop. When you provide the query to cfmail it does the loop for you. Well, I believe you. At first I did try: cfmail query=NotPaid server=#REQUEST.MailingListServer# from=i...@nnvawi.org to=#NotPaid.UserEmail# /cfmail ... ColdFusion sends to only the first email

Re: question about lists and CFMAIL

2012-12-02 Thread Matt Quackenbush
Try scoping the to email: cfmail query=NotPaid ... to=#NotPaid.UserEmail[currentRow]# HTH On Sun, Dec 2, 2012 at 4:53 PM, Eric Bourland e...@ebwebwork.com wrote: No need at all for the cfloop. When you provide the query to cfmail it does the loop for you. Well, I believe you. At first

Re: question about lists and CFMAIL

2012-12-02 Thread Matt Quackenbush
Also, where is #FirstName# and #LastName# coming from? I am assuming they are also part of the query. If so, scope them as well. #NotPaid.FirstName[currentRow]# #NotPaid.LastName[currentRow]# On Sun, Dec 2, 2012 at 4:59 PM, Matt Quackenbush quackfu...@gmail.comwrote: Try scoping the to

RE: question about lists and CFMAIL

2012-12-02 Thread Eric Bourland
I take it all back. It is working: cfmail query=NotPaid server=#REQUEST.MailingListServer# from=i...@nnvawi.org to=#NotPaid.UserEmail# /cfmail Why did it not work before? Very like, user error. =) Thank you all again for your help. This is a success. Eric

RE: question about lists and CFMAIL

2012-12-02 Thread Eric Bourland
Matt, yep -- I scoped the variables. Seems to be working now. =) Eric -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Sunday, December 02, 2012 6:00 PM To: cf-talk Subject: Re: question about lists and CFMAIL Also, where is #FirstName# and #LastName