, September 24, 2003 4:54 PM
To: CF-Talk
Subject: RE: CFMAIL TO param problems with large queries
FYI, I posted this BEFORE I saw Dustin's say there were 6000 emails in his
list! Yikes!
-Original Message-
From: J E VanOver [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 11:33 AM
Hello All,
I am trying to use CFMAIL in 6.1 to email a large list that worked in CF
4.5. Apparently MM has added additional restrictions to what can be used in
the TO parameter.
Basically I have a query that gets about 6000+ records
I then use the tag as such:
cfmail
query=sendnewsletter
[Unisyn Software] [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:34 AM
Subject: CFMAIL TO param problems with large queries
Hello All,
I am trying to use CFMAIL in 6.1 to email a large list that worked in CF
4.5. Apparently MM has added additional
Perhaps you should cfdump the query results and look?
-Original Message-
From: Dustin Snell [Unisyn Software] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 12:43 PM
To: CF-Talk
Subject: Re: CFMAIL TO param problems with large queries
Another note -
I also, tried
Wrap your cfmail statement in a recordcount test
cfif sendnewsletter.recortcount lt 1
uh ohcfabort
cfelse
cfoutput#sendnewsletter.email#cfoutputcfabort
/cfif
The first block will isolate whether you have a problem with your query
syntax. The second will output the email address, if one is
-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:13 AM
Subject: RE: CFMAIL TO param problems with large queries
Wrap your cfmail statement in a recordcount test
cfif sendnewsletter.recortcount lt 1
uh ohcfabort
cfelse
cfoutput#sendnewsletter.email#cfoutputcfabort
/cfif
query code too.
-Original Message-
From: Dustin Snell [Unisyn Software] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 1:36 PM
To: CF-Talk
Subject: Re: CFMAIL TO param problems with large queries
Oddly it seems that I am getting all the records but at the end
Well, at least you now know the source of the problem, and that its
solution is a simple one.
cfif len(sendnewsletter.email)
cfmail...
/cfif
Not a true solution, but it'll get your app running instantly while you
puzzle over the cause.
Matt
Oddly it seems that I am getting all the records but at the end there is
what seems to be a blank email address. When I cfoutput the results it
outputs the text [empty string] at the end. Seems that should be impossible
with the LIKE email ='[EMAIL PROTECTED]' in the query . The query is ordered
Just to add on to Matt's suggestion:
cfif len(trim(sendnewsletter.email))
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 12:48 PM
To: CF-Talk
Subject: RE: CFMAIL TO param problems with large queries
Well, at least you now know
I am passing the query parameter to the CFMAIL tag directly. So I can't do
this for each one.
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:48 AM
Subject: RE: CFMAIL TO param problems with large queries
TO param problems with large queries
Oddly it seems that I am getting all the records but at the end there is
what seems to be a blank email address. When I cfoutput the results it
outputs the text [empty string] at the end. Seems that should be
impossible
with the LIKE email ='[EMAIL PROTECTED
I *am* disturbed with CF because this new attribute validation is
*breaking*
code that worked before in 4.5. This validation is unnecessary and is
better to be left for the mail server to handle. It is especially a hassle
when you are passing the query parameter to the CFMAIL tag the query
Dustin Snell wrote:
I am passing the query parameter to the CFMAIL tag directly. So I can't
do
this for each one.
Then as was pointed out, you'll need to fix your SQL (or the apparently
unvalidated data; or both) straight up before you go anywhere. Data
validation rules might be something you
help.
Dustin
- Original Message -
From: Dave Carabetta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 11:17 AM
Subject: Re: CFMAIL TO param problems with large queries
I *am* disturbed with CF because this new attribute validation is
*breaking
As for your suggestion, as long as my code is using the QUERY param of the
CFMAIL (instead of doing it one at a time) this will not work. Now in my
query I am having to add all sorts of checks to make sure the address is
valid. I have wasted my whole morning playing games with this tag. One of
To: CF-Talk
Subject: RE: CFMAIL TO param problems with large queries
Well, at least you now know the source of the problem, and that its
solution is a simple one.
cfif len(sendnewsletter.email)
cfmail...
/cfif
Not a true solution, but it'll get your app running instantly while you
puzzle over
Software] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:43 AM
To: CF-Talk
Subject: Re: CFMAIL TO param problems with large queries
Another note -
I also, tried:
and email like '[EMAIL PROTECTED]'
Still get the error below. Isn't it impossible then with this in my query
that any
FYI, I posted this BEFORE I saw Dustin's say there were 6000 emails in his
list! Yikes!
-Original Message-
From: J E VanOver [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 11:33 AM
To: CF-Talk
Subject: RE: CFMAIL TO param problems with large queries
What if there's
19 matches
Mail list logo
