in my experience with email addresses everything's gonna be wrong with them, not just missing @ symbols. You need to run an regex against them to filter out the bads.
> -----Original Message----- > From: Ian Westbrook (BT account) [mailto:[EMAIL PROTECTED] > Sent: 23 March 2004 12:31 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] cleaning email lists... > > > >Oh, by the way, add in a condition which removes and scrubs > me from the > spam list too. :) > > not spam. Opt-in, people who have signed up for emails: but > some of them are a little, er, _challenged_ when it comes to > computers and stuff, so don't always enter their address > correctly. For example, what prompted my email was noticing > that someone had entered their address as > firstname.lastname'aol.com - ie hit the wrong key for the @ sign... > > Ian W > > > ----- Original Message ----- > From: "Peter Harrison" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 23, 2004 12:24 PM > Subject: RE: [ cf-dev ] cleaning email lists... > > > Oh, by the way, add in a condition which removes and scrubs > me from the spam list too. :) > > Thanks. > > - Peter > > -----Original Message----- > From: Ian Westbrook (BT account) [mailto:[EMAIL PROTECTED] > Sent: 23 March 2004 11:58 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] cleaning email lists... > > > > SELECT id FROM email > > WHERE charindex('@', email) = 0 > > ooh, that looks good too ;-) > > Ian W > > ----- Original Message ----- > From: "Rich Wild" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 23, 2004 11:34 AM > Subject: RE: [ cf-dev ] cleaning email lists... > > > > SELECT id FROM email > > WHERE charindex('@', email) = 0 > > > > > -----Original Message----- > > > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > > > Sent: 23 March 2004 11:23 > > > To: [EMAIL PROTECTED] > > > Subject: Re: [ cf-dev ] cleaning email lists... > > > > > > > > > Heh heh, well at least one person had to come up with > something that > > > wasn't "NOT LIKE"... ;) > > > > > > > Clever clogs :-P > > > > > > > > -----Original Message----- > > > > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > > > > Sent: 23 March 2004 11:22 > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: [ cf-dev ] cleaning email lists... > > > > > > > > SELECT ID FROM Email > > > > WHERE Locate('@',email) = 0 > > > > > > > > Probably more efficient than NOT LIKE '[EMAIL PROTECTED]', but no idea if > > > it'll work > > > > in access... Definitely ok in mySQL..... > > > > > > > > You can probably find an equivalent... > > > > > > > > Ian Westbrook (FDM) wrote: > > > > > > > >>got a bit of a mental block this morning - can anyone > throw me the > > > > > > > > code > > > > > > > >>to select emails from a field where the email _doesn't_ > > > contain an '@' > > > > > > > > > > > >><mailto:'@'> symbol? > > > >> > > > >>something like > > > >> > > > >>SELECT id FROM email > > > >>WHERE email does not contain '@' <mailto:'@'> > > > >> > > > >>TIA > > > >> > > > >>Ian W > > > >> > > > >> > > > > > > > > > > > > > > -- > > > These lists are syncronised with the CFDeveloper forum at > > > http://forum.cfdeveloper.co.uk/ > > > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > CFDeveloper Sponsors and contributors:- > > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > > > provided by activepdf.com* > > > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by > > > proworkflow.com* > > > *Tutorials provided by helmguru.com* :: *Lists > hosted by > > > gradwell.com* > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > > provided > by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
