Re: search double negative comparison
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36584
interpreted = N
texte = Robert Kudrle wrote: > > 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.comYou are currently testing neTHIS or neTHATbut you want to test neTHIS and neTHATso add rq to the test terms, ala &neMAINSITEDATABASEdatarq=...&neMAINSITEDATABASEdatara=...Study the manual section on And vs. Or under Searching.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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:
Robert Kudrle wrote: > > 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.comYou are currently testing neTHIS or neTHATbut you want to test neTHIS and neTHATso add rq to the test terms, ala &neMAINSITEDATABASEdatarq=...&neMAINSITEDATABASEdatara=...Study the manual section on And vs. Or under Searching.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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/
John Peacock
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:
CommandSecurity? (1997)
replace using &append=T (2007)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Emailer port change (1997)
Configuration Q (1998)
[WebDNA] WebDNA crash and now emailer not working (2009)
NT 4.0/IIS WebCat Installation (1998)
File upload to database ? (2001)
WebCatalog for guestbook ? (1997)
Middle problem (2005)
F3 crashing server (1997)
Question about links (1999)
Week # problem (1998)
New Plug-in and Type 11 errors (1997)
Site Search Concepts (2003)
lookups (2000)
Protect folder (2005)
Multiple SSL Keys (1998)
Date search - yes or no (1997)
Multiple catalog databases and showcart (1997)