absolutely nothing. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 23 March 2004 13:48 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] cleaning email lists... > > > > 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] >
-- 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]
