>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]
