what can/do you do against muppets like: [EMAIL PROTECTED] ?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Rich Wild <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> go.com> cc: Subject: RE: [ cf-dev ] cleaning email lists... 23/03/2004 12:33 Please respond to dev 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] -- 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]
