Re: search double negative comparison

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 36599
interpreted = N
texte = thanks, that's the answere I was scouring the archives for. I'll give it a try. -- Robert Kudrle Coil, Counts, Ford & Cheney rjk27@ccfc.comOn Friday, June 22, 2001 11:46 AM, Jay Van Vark wrote: >you need to make those rq -- and you need to make the second one a >groupfield -- you can't have two comparisons on the same >field... > >ie > >[Search >db=databases/search.db&neMAINSITEDATABASEdatarq=[url]professionalsdatabase.db[/url]&group1field=MAINSITEDATABASE&neGroup1datarq=[url]doctorsdatabase.db[/url]] > > >>I'm trying to search for all records which has a field >>MAINSITEDATABASE that doesn't contain the values >>professionalsdatabase.db or doctorsdatabase.db. >> >>For some reason my DNA statement returns all records. It works >>correctly if I take out one of the variables but not when I have >>both. Anyone have an idea. >> >>[Search >>db=databases/search.db&neMAINSITEDATABASEdata=[url]professionalsdatabase.db[/url]&neMAINSITEDATABASEdata=[url]doctorsdatabase.db[/url]] >> >>Thanks to anyone who can help. Otherwise maybe I should take the >>afternoon off. >> >> >>-- >>Robert Kudrle >>Coil, Counts, Ford & Cheney >>rjk27@ccfc.com >> >-- > >Jay Van Vark *********************************** >Fax (801) 659-7952 >*********************************** > >Even if you are on the right track, you'll get run over if you just sit there! > >--Roy Rogers > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://search.smithmicro.com/ >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: search double negative comparison (Robert Kudrle 2001)
  2. Re: search double negative comparison (Robert Kudrle 2001)
  3. search double negative comparison (Robert Kudrle 2001)
  4. Re: search double negative comparison (Jay Van Vark 2001)
  5. Re: search double negative comparison (John Peacock 2001)
  6. Re: search double negative comparison (Anup Setty 2001)
thanks, that's the answere I was scouring the archives for. I'll give it a try. -- Robert Kudrle Coil, Counts, Ford & Cheney rjk27@ccfc.comOn Friday, June 22, 2001 11:46 AM, Jay Van Vark wrote: >you need to make those rq -- and you need to make the second one a >groupfield -- you can't have two comparisons on the same >field... > >ie > >[Search >db=databases/search.db&neMAINSITEDATABASEdatarq=[url]professionalsdatabase.db[/url]&group1field=MAINSITEDATABASE&neGroup1datarq=[url]doctorsdatabase.db[/url]] > > >>I'm trying to search for all records which has a field >>MAINSITEDATABASE that doesn't contain the values >>professionalsdatabase.db or doctorsdatabase.db. >> >>For some reason my DNA statement returns all records. It works >>correctly if I take out one of the variables but not when I have >>both. Anyone have an idea. >> >>[Search >>db=databases/search.db&neMAINSITEDATABASEdata=[url]professionalsdatabase.db[/url]&neMAINSITEDATABASEdata=[url]doctorsdatabase.db[/url]] >> >>Thanks to anyone who can help. Otherwise maybe I should take the >>afternoon off. >> >> >>-- >>Robert Kudrle >>Coil, Counts, Ford & Cheney >>rjk27@ccfc.com >> >-- > >Jay Van Vark *********************************** >Fax (801) 659-7952 >*********************************** > >Even if you are on the right track, you'll get run over if you just sit there! > >--Roy Rogers > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://search.smithmicro.com/ >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Robert Kudrle

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

SiteGuard Use Question (1997) Appending Information from one db to another (1998) WebCatalog not recognizing ShoppingCarts folder (2000) autocommit problem (1998) WebCat for mass emailings (1997) emailer setup (1997) BreadCrumb Trails (2001) RAM variables (1997) [OT] What is your favorite Javascript forum? (2006) For Sale: WebTen 2.x and WebCat 2.x (2000) WebCat2 Append problem (B14Macacgi) (1997) MySQL UPDATE (2007) For those of you not on the WebCatalog Beta... (1997) WebCatalog for guestbook ? (1997) [WebDNA] Base 64 (2010) block serving .db files (2002) need help with [sendmail] and [showif]s (1998) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) email program problem (1998) [WebDNA] New problem with [ShowNext] (2010)