CFMail

Hey all,

So I have a app working on a site that allows the clients to send out mass html e-mail to their clients/employees, etc.

I just inputed the list of almost 2000 e-mail addys into the database, and we went for a test...so we hit the "email this crazy huge list of people" button, and it bombed...it bombed because one of the email addys were something@something somethingelse.com

the problem was obviously the space, so, the CF mail server bombed at that entry.

My question is, is there a way that I can tell CF to disregard any email addys that don't follow the pattern of something@something.something

I know, garbage in garbage out, but I had to change a comma delimited file from a mac into an sql database and I wasn't about to go looking at every entry, I assumed they were fine, and I know what assuming does =0p

No, you'll need to validate the email addresses before you feed them into cfmail. In fact, an invalid email address should never even make it into the database in the first place, everything should be validated before it is inserted.

I know...but in the words of Han Solo "it's not my fault!"

I won't chastise you too much, but I've heard the "it's not my fault" excuse too many times. Fine, someone else did it. That's over. Take responsibility, write a small app that loops through the database and check the emails, and either deletes them or at least logs them. Then modify the insertion code to validate the address so that the problem doesn't happen in the future. Don't be the excuse person, be the solution person!

Aww man, that's exactly what I was coming on here to talk about! I was too slow...

So, I suppose you answered my question of...

Can I make a small app to loop through the e-mail addys and compare it against a mask of some sort to then tell me which id's do not follow *@*.*

?

Alright, so I'm running into wildcard problems, at least figuring out how to use a wildcard in an if statment with "is"...if I figure it out i'll post here, if not, can anyone help me out?

nevermind, SQL is my friend