Re: search double negative comparison
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36585
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Jay Van Vark
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:
Suggestions on best way to work with yyyy/mm/dd (1997)
charge.com (2005)
[WebDNA] Is the AutoCommit preference still supported? (2010)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
using showpage and showcart commands (1996)
Re1000001: Setting up shop (1997)
Exclude by date - multiple (1997)
checkbox results written to a database (1999)
Q: Japanese Kanji code support? (2000)
5.0 Preview Promotion Extension (2003)
SiteGuard Admin Feature ? (1997)
Buying sans cart (1997)
2.1 pricing? (1998)
[WebDNA] hide [DOS] command strings on resulting page (2016)
WebCat2b13MacPlugIn - [include] (1997)
choice of images (2000)
Help! WebCat2 bug (1997)
Search/sort in URL Was: GuestBook example (1997)
Please, no more comparisons between operating systems (1998)
Emailer again & again (1997)