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
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/WSc3ff6d0ea77859461172e0811cbec22c24-7f8e.html
HTH
On Sun, Dec 2, 2012 at 3:03 PM, Eric Bourland e...@ebwebwork.com wrote:
ColdFusion 9.0.2
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
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 e...@ebwebwork.com 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
Eric,
Take a look a the Sending query-based email on this page
http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec14b97-7ffb.html
You specify the query name in the query attribute and the email column as
your To: attribute. Cfmail will then loop over the query
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
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
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
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
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#
i have a table that has two date fields (dateinx and dateoutx) and i need to
find all the results for todays date that both fall between and on that date
for a given customer: cID.
database is msSQL2005
cfserver is 7
if todays date is 12/2/2012examples of vialable entries:
-
i have a table that has two date fields (dateinx and dateoutx) and i
need to find all the results for todays date that both fall between
and on that date for a given customer: cID.
This should be fairly simple to add to your existing query...
AND GETDATE() BETWEEN dateinx AND dateoutx
12 matches
Mail list logo