the query is this... select emailAddress from Table where emailAddress like '[EMAIL PROTECTED]'
now, i know this doesnt validate, but at least weeds out the malformed, or n/a or whatevers... there is a regex that removes the invalids after the sql filter is applied... i just didnt show that code... thats all :) but, i got it working now, all is well! :) thank ya tw On Fri, 11 Feb 2005 10:49:43 -0500, Joe Eugene <[EMAIL PROTECTED]> wrote: > > the problem is that there is an invalid email address in there > > , not in its form, or whatever, it'll validate just fine > > What are you using to validate the email address, i dont see where > are validating the email address comming out of the DB Query. > > > > > > <cfmail to="[EMAIL PROTECTED]" from="TheWebsite" subject="Email > Manager > > the from is invalid... have you tried [EMAIL PROTECTED] ? > > HTH > Joe > > ----- Original Message ----- > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Thursday, February 10, 2005 10:00 PM > Subject: Re: cftry/cfcatch around cfmail > > > joe, > > > > this isnt the problem... > > > > the problem is that there is an invalid email address in there > > , not in its form, or whatever, it'll validate just fine, its just that > > the mail server rejects it... the email address is local to the mail > > server that they cfmx server uses... > > > > tw > > > > > > On Thu, 10 Feb 2005 21:41:55 -0500, Joe Eugene <[EMAIL PROTECTED]> > wrote: > > > 1. Write a simple method to validate emails.... boolean return type. > > > isEmailAddress(String emAddr){} > > > i cant remember but there is a good regular expresssion out there. > > > > > > 2. Develop a concrete method to send emails instead of having reduntant > code > > > all over the place to send emails. > > > sendEmail(){} > > > Within the sendEmail, you can invoke isEmailAddress and boolean > return > > > type, if the validation fails, > > > You can also send an errMessage back to the view - > "Your email > address > > > is Invalid, please correct" > > > > > > The above is a working solution. > > > > > > HTH. > > > Joe > > > > > > > > > ----- Original Message ----- > > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[email protected]> > > > Sent: Thursday, February 10, 2005 9:08 PM > > > Subject: Re: cftry/cfcatch around cfmail > > > > > > > the problem is, its a bad email address, so i dont know until the > > > > email tries to go out... and its like i get an IMMEDIATE no-go from > > > > the mail server (all the emails for this test, are local to the mail > > > > server that im sending through, so it knows RIGHT AWAY). > > > > > > > > man this is strange... > > > > > > > > tw > > > > > > > > > > > > On Thu, 10 Feb 2005 19:15:17 -0600, Dawson, Michael > <[EMAIL PROTECTED]> > > > wrote: > > > > > I've seen this before. I can't remember if I ever found a > work-around > > > > > or not. You can set a variable in the catch block, then call the > cfmail > > > > > tag after you are done looping. > > > > > > > > > > It would make a little more sense to send a single email with all > the > > > > > errors than an email for each error. Just as Matt said previously. > > > > > > > > > > -----Original Message----- > > > > > From: Tony Weeg [mailto:[EMAIL PROTECTED] > > > > > Sent: Thursday, February 10, 2005 7:09 PM > > > > > To: CF-Talk > > > > > Subject: Re: cftry/cfcatch around cfmail > > > > > > > > > > sup barney... thats what ive got... > > > > > > > > > > <cfquery name="GetPartnerEmailAddresses" > datasource="#usersDatasource#"> > > > > > select email from regions where email like '[EMAIL PROTECTED]' > > > > > </cfquery> > > > > > > > > > > <cfloop query="GetPartnerEmailAddresses"> > > > > > > > > > > <cftry> > > > > > > > > > > <cfmail to="[EMAIL PROTECTED]" from="[EMAIL PROTECTED]" > > > > > subject="Test, please disregard" spoolenable="No">This is a test, > please > > > > > disregard.</cfmail> > > > > > > > > > > This worked! > > > > > > > > > > <cfcatch type="Any"> > > > > > > > > > > <cfmail to="[EMAIL PROTECTED]" from="TheWebsite" subject="Email > Manager > > > > > Error" spoolenable="No">This error happened on > > > > > #DateFormat(Now(),'mm/dd/yyyy')# Here is what happened: > > > > > Message: #cfcatch.message# > > > > > Detail: #cfcatch.detail# > > > > > </cfmail> > > > > > > > > > > This didnt work. > > > > > > > > > > </cfcatch> > > > > > > > > > > </cftry> > > > > > > > > > > </cfloop> > > > > > > > > > > and what happens is... it looks like its worked, as i see 10 "This > > > > > worked" on the screen, and only one "This didnt work", but @ the > bottom > > > > > of the screen in the debugging output, and exception error... > > > > > and no emails go out at all :( ? > > > > > > > > > > tw > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194413 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
