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=2439&p=go/dr_text_aff1