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