>Next we'll need advice on indexing to speed things up. er, yeah, that would be good. I've already noticed the site slowing down slightly whern it's busy. I was wondering whether it's Access - couldn't be my code, of course ;-)
Ian W ----- Original Message ----- From: "Peter Harrison" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 23, 2004 12:07 PM Subject: RE: [ cf-dev ] cleaning email lists... hehe Like an excited kid in a sweet shop. :D Next we'll need advice on indexing to speed things up. - 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]
