Re: search double negative comparison
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36598
interpreted = N
texte = Yeh, I've thought of that one as well. Though if you had a [numfound], it wouldn't match the results returned.Thanks Anup for the thought. -- Robert Kudrle Coil, Counts, Ford & Cheney rjk27@ccfc.comOn Friday, June 22, 2001 11:33 AM, Anup Setty
wrote: >There is probably One way to do this, unfortunately I don't that, >but I know Another Way to do it :) > >[SEARCH db=db/ggg.db&neFIRSTNAMEdata=john] >[founditems] >[HIDEIF [firstname]=dean] >[firstname]
>[/hideif] >[/founditems] >[/search] >[CLOSEDATABASE db/ggg.db] > >my db is > >GGGID FIRSTNAME LASTNAME > >1 John Doe > >2 John Smith > >3 Dean Doe > >4 Dean Smith > >5 Robert Smith > >6 David Black > >7 Jim Black > >8 Paul Red > > > >Hope this helps You... > >Anup Setty > >----- Original Message ----- >From: Robert Kudrle >To: WebCatalog Talk >Sent: Friday, June 22, 2001 4:22 PM >Subject: search double negative comparison > > >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 > > > >------------------------------------------------------------- >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/ >------------------------------------------------------------- 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:
Yeh, I've thought of that one as well. Though if you had a [numfound], it wouldn't match the results returned.Thanks Anup for the thought. -- Robert Kudrle Coil, Counts, Ford & Cheney rjk27@ccfc.comOn Friday, June 22, 2001 11:33 AM, Anup Setty wrote: >There is probably One way to do this, unfortunately I don't that, >but I know Another Way to do it :) > >[SEARCH db=db/ggg.db&neFIRSTNAMEdata=john] >[founditems] >[HIDEIF [firstname]=dean] >[firstname]
>[/hideif] >[/founditems] >[/search] >[CLOSEDATABASE db/ggg.db] > >my db is > >GGGID FIRSTNAME LASTNAME > >1 John Doe > >2 John Smith > >3 Dean Doe > >4 Dean Smith > >5 Robert Smith > >6 David Black > >7 Jim Black > >8 Paul Red > > > >Hope this helps You... > >Anup Setty > >----- Original Message ----- >From: Robert Kudrle >To: WebCatalog Talk >Sent: Friday, June 22, 2001 4:22 PM >Subject: search double negative comparison > > >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 > > > >------------------------------------------------------------- >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/ >------------------------------------------------------------- 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:
Accessing Server Environment Variables (2003)
Two prices in shoppingcart? (1997)
Exclamation point (1997)
pc (1997)
Country & Ship-to address & other fields ? (1997)
Example Search Form (1997)
Attn iTools / WebCat users.... (2004)
[ConvertChars] problem (1997)
PLEASE REMOVE MY EMAIL ADDRESS (1997)
Referrer field to header field conversion (1997)
Bugs in IE 6.0 ? (2003)
[WriteFile] problems (1997)
Help with searching dates from mysql dump & searching (2006)
Webcatalog error, Plug-in for Webstar (1996)
[OT] Forums - check it out (2005)
Forms Search Questions (1997)
shipcost (1997)
two unique banners on one page (1997)
[/application] error? (1997)
Windows 2.1b2 Append Bug? (1997)