esday, 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 1
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
-Original Message-
From: Dustin Snell [Unisyn 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 err
AM
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.
Not a true solution, but it'll get your app running instantly while you
puzzle over
>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
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 be
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 w
>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
>
ptember 24, 2003 10:50 AM
Subject: Re: CFMAIL 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.
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
Just to add on to Matt's suggestion:
-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 the source of the problem, and
>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 ordere
Well, at least you now know the source of the problem, and that its
solution is a simple one.
Not a true solution, but it'll get your app running instantly while you
puzzle over the cause.
Matt Robertson [EMAIL PROTECTED]
MSB Design
ht be best to post the complete 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
t;[EMAIL PROTECTED]>
To: "CF-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
>
>
>uh oh
>
>#sendnewsletter.email#
&g
Wrap your cfmail statement in a recordcount test
uh oh
#sendnewsletter.email#
The first block will isolate whether you have a problem with your query
syntax. The second will output the email address, if one is being
returned, so you can debug the thing. The cfaborts will keep the outpu
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:
and email like '[EMAIL PROTECTED]'
Still get the error below. Isn't it impossible then with this in my query
that any records could be included that have 0 length in the email field as
the error states?
Dustin Snell
- Original Message -
From: "Dustin Snell
18 matches
Mail list logo