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
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
>
>
&
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
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
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
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
>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
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
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
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* 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 w
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
>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
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
-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
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
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
18 matches
Mail list logo