RE: CFMAIL TO param problems with large queries
thats the right track though, i'd loop over your query with a proper email regex. Where it doestn match, output the record key. Then you should be able to make short work of the problem records. DRE -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Wednesday, 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 To: CF-Talk Subject: RE: CFMAIL TO param problems with large queries What if there's an email in your system that looks something like this: My True and Right Name @. Actually, I think your like statement would even match @. If it were me, I'd dump out the email addresses and see if anything looks screwy. -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 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 [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 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 to=#sendnewsletter.email# mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; from=Unisyn Newsletter System [EMAIL PROTECTED] subject=#form.subject##form.body#/cfmail In the query I have specified: and email is not null and email '' and email like '[EMAIL PROTECTED]' But it always gives the error: Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). The error occurred in C:\Inetpub\wwwroot\unisyn\administration\emailnewsletter.cfm: line 107 105 : cfmail 106 :query=sendnewsletter 107 :to=#sendnewsletter.email# 108 :mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; 109 :from=Unisyn Newsletter System [EMAIL PROTECTED] Does anyone know why this isn't working? -Dustin Snell ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138435 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/t.asp?id=2439p=go/dr_text_aff1
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 [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 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 to=#sendnewsletter.email# mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; from=Unisyn Newsletter System [EMAIL PROTECTED] subject=#form.subject##form.body#/cfmail In the query I have specified: and email is not null and email '' and email like '[EMAIL PROTECTED]' But it always gives the error: Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). The error occurred in C:\Inetpub\wwwroot\unisyn\administration\emailnewsletter.cfm: line 107 105 : cfmail 106 :query=sendnewsletter 107 :to=#sendnewsletter.email# 108 :mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; 109 :from=Unisyn Newsletter System [EMAIL PROTECTED] Does anyone know why this isn't working? -Dustin Snell ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138285 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMAIL TO param problems with large queries
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 [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 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 to=#sendnewsletter.email# mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; from=Unisyn Newsletter System [EMAIL PROTECTED] subject=#form.subject##form.body#/cfmail In the query I have specified: and email is not null and email '' and email like '[EMAIL PROTECTED]' But it always gives the error: Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). The error occurred in C:\Inetpub\wwwroot\unisyn\administration\emailnewsletter.cfm: line 107 105 : cfmail 106 :query=sendnewsletter 107 :to=#sendnewsletter.email# 108 :mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; 109 :from=Unisyn Newsletter System [EMAIL PROTECTED] Does anyone know why this isn't working? -Dustin Snell ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138286 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
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 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 output down to size for now. You may also want to output the primary key value so you know which record is causing the problem. Hope this helps, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138288 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
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. Seems that should be impossible with the LIKE email ='[EMAIL PROTECTED]' in the query . The query is ordered by email so I see this entry at the very end. I am disturbed that a blank email is being included in the query, but also disturbed that CF seems to be outputting the text [empty string] when it should just be blank! -Dustin - Original Message - From: Matt Robertson [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 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 being returned, so you can debug the thing. The cfaborts will keep the output down to size for now. You may also want to output the primary key value so you know which record is causing the problem. Hope this helps, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138290 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMAIL TO param problems with large queries
In a previous email, you specified that : In the query I have specified: and email is not null and email '' and email like '[EMAIL PROTECTED]' You don't have an OR clause before the email checks that is letting through that record, do you? Might 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 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 by email so I see this entry at the very end. I am disturbed that a blank email is being included in the query, but also disturbed that CF seems to be outputting the text [empty string] when it should just be blank! -Dustin - Original Message - From: Matt Robertson [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 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 being returned, so you can debug the thing. The cfaborts will keep the output down to size for now. You may also want to output the primary key value so you know which record is causing the problem. Hope this helps, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138292 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
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 the cause. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138294 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
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. Seems that should be impossible with the LIKE email ='[EMAIL PROTECTED]' in the query . The query is ordered by email so I see this entry at the very end. I am disturbed that a blank email is being included in the query, but also disturbed that CF seems to be outputting the text [empty string] when it should just be blank! Don't be disturbed with CF, bet disturbed with the query. ;) You're AND-ing your NULL/blank string checks together instead of OR-ing them. Try switching and see what happens with your query results. Also, you should just be able to do: SELECT emailaddress FROM myTable WHERE emailaddress IS NOT NULL OR TRIM(emailaddress) != '' That should cover all instances of blank or NULL e-mail fields. I don't know if there's a TRIM() function in SQL Server, so you may have to do LTRIM(RTRIM(emailaddress)) to get the same effect (I'm on Oracle, so I just don't know that answer). Regards, Dave. _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138295 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CFMAIL TO param problems with large queries
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 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 Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138296 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CFMAIL TO param problems with large queries
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 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 Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138298 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFMAIL TO param problems with large queries
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 contains 6000 records! Now I have to make sure it has no invalid email addresses - it's enough to make you pull your hair out. -Dustin - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 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. Seems that should be impossible with the LIKE email ='[EMAIL PROTECTED]' in the query . The query is ordered by email so I see this entry at the very end. I am disturbed that a blank email is being included in the query, but also disturbed that CF seems to be outputting the text [empty string] when it should just be blank! Don't be disturbed with CF, bet disturbed with the query. ;) You're AND-ing your NULL/blank string checks together instead of OR-ing them. Try switching and see what happens with your query results. Also, you should just be able to do: SELECT emailaddress FROM myTable WHERE emailaddress IS NOT NULL OR TRIM(emailaddress) != '' That should cover all instances of blank or NULL e-mail fields. I don't know if there's a TRIM() function in SQL Server, so you may have to do LTRIM(RTRIM(emailaddress)) to get the same effect (I'm on Oracle, so I just don't know that answer). Regards, Dave. _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138299 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMAIL TO param problems with large queries
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 contains 6000 records! Now I have to make sure it has no invalid email addresses - it's enough to make you pull your hair out. I understand your frustration. I, too, just migrated from CF 4.5, and I don't recall ever being able to put anything other than a valid e-mail address in the TO attribute. In my experience, CF always failed on an invalid address. But that's neither here nor there. As for compatibility with CF 4.5, well that's always a crap shoot, and I definitely feel your pain on that front. We just migrated our site from CF 4.5 to CFMX 6.0-6.1 and had all sorts of those little quirks to work out. The way I looked at it was that Macromedia claimed compatibility with CF 5 and no earlier, so I just sucked it up and fixed what had to be done. By the way, you didn't mention whether or not the query suggestion worked? Taking care of it at the root instead of len(trim()) tests is more efficient and a cleaner implementation. Regards, Dave. _ Instant message during games with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138300 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFMAIL TO param problems with large queries
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 want to look at on the input side, if its within your control. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138302 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFMAIL TO param problems with large queries
Thank you for your understanding. Empathy always helps a bit :-) 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 these hours now my query will check every possible problem and deliver a perfect set of approx 6000 email addresses to CFMAIL. Why should I have to do this when the mail server would do it for me? Nobody really knows. Thanks for your 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* 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 contains 6000 records! Now I have to make sure it has no invalid email addresses - it's enough to make you pull your hair out. I understand your frustration. I, too, just migrated from CF 4.5, and I don't recall ever being able to put anything other than a valid e-mail address in the TO attribute. In my experience, CF always failed on an invalid address. But that's neither here nor there. As for compatibility with CF 4.5, well that's always a crap shoot, and I definitely feel your pain on that front. We just migrated our site from CF 4.5 to CFMX 6.0-6.1 and had all sorts of those little quirks to work out. The way I looked at it was that Macromedia claimed compatibility with CF 5 and no earlier, so I just sucked it up and fixed what had to be done. By the way, you didn't mention whether or not the query suggestion worked? Taking care of it at the root instead of len(trim()) tests is more efficient and a cleaner implementation. Regards, Dave. _ Instant message during games with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138303 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMAIL TO param problems with large queries
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 these hours now my query will check every possible problem and deliver a perfect set of approx 6000 email addresses to CFMAIL. I'm a little confused. In order to use the QUERY attribute of the CFMAIL tag, you have to pass it a valid CFQUERY name that *that has already run.* So if you fix your AND-ing problem to OR, then you will be passing a query that should only have an e-mail address in it -- no NULLs and no blank strings. Can you post the full code snippet -- query and cfmail usage -- so that I/we can get a better idea of how your template is working (or not working)? Regards, Dave. _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138306 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CFMAIL TO param problems with large queries
No it wouldn't Matt. In his original post, Dustin showed he was trying to use the QUERY parameter of CFMAIL --- where there is no chance to check each row before using it. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:48 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. 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 Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138353 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
RE: CFMAIL TO param problems with large queries
What if there's an email in your system that looks something like this: My True and Right Name @. Actually, I think your like statement would even match @. If it were me, I'd dump out the email addresses and see if anything looks screwy. -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 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 [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 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 to=#sendnewsletter.email# mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; from=Unisyn Newsletter System [EMAIL PROTECTED] subject=#form.subject##form.body#/cfmail In the query I have specified: and email is not null and email '' and email like '[EMAIL PROTECTED]' But it always gives the error: Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). The error occurred in C:\Inetpub\wwwroot\unisyn\administration\emailnewsletter.cfm: line 107 105 : cfmail 106 :query=sendnewsletter 107 :to=#sendnewsletter.email# 108 :mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; 109 :from=Unisyn Newsletter System [EMAIL PROTECTED] Does anyone know why this isn't working? -Dustin Snell ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138355 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 In the beginning ColdFusion shipped with Website. Both have only gotten better http://www.deerfield.com/products/website/
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 To: CF-Talk Subject: RE: CFMAIL TO param problems with large queries What if there's an email in your system that looks something like this: My True and Right Name @. Actually, I think your like statement would even match @. If it were me, I'd dump out the email addresses and see if anything looks screwy. -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 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 [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 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 to=#sendnewsletter.email# mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; from=Unisyn Newsletter System [EMAIL PROTECTED] subject=#form.subject##form.body#/cfmail In the query I have specified: and email is not null and email '' and email like '[EMAIL PROTECTED]' But it always gives the error: Attribute validation error for tag CFMAIL. The value of the attribute TO is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). The error occurred in C:\Inetpub\wwwroot\unisyn\administration\emailnewsletter.cfm: line 107 105 : cfmail 106 :query=sendnewsletter 107 :to=#sendnewsletter.email# 108 :mailerid=Unisyn Software Newsletter System -- http://www.unisyn.com; 109 :from=Unisyn Newsletter System [EMAIL PROTECTED] Does anyone know why this isn't working? -Dustin Snell ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138359 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803