Re: Search the same field twice?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 60557
interpreted = N
texte = search the results, write them to a table and then search the table. If you have a large DB and lots of traffic, using the table rather than a nested search will be less overhead. Brian ----- Original Message ----- From: To: "WebDNA Talk" Sent: Tuesday, December 21, 2004 4:51 AM Subject: Search the same field twice? > I'm using the following search but it is not working as expected: > > [search > db=article.db&woBLURBdata=[keywords]&wnBLURBdata=[blockwords]&max=[stories]] > > I want to include all articles that match one or more of a list of > "keywords" but then I want to exclude those articles that have any > "blockwords." > > The above is not working because it seems that the blockwords portion is > not being applied. Is it possible to search the same field twice? If > not, how can I get the same effect in the search, i.e. match these but not > those? > > I'm trying a hideif as a workaround, but it doesn't match up the max value > since some matches are excluded. > > Any insight appreciated. > > Thanks, > Bill > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search the same field twice? ( Donovan Brooke 2004)
  2. Re: Search the same field twice? ( Rob Marquardt 2004)
  3. Re: Search the same field twice? ( "Brian Boegershausen" 2004)
  4. Re: Search the same field twice? ( Donovan Brooke 2004)
  5. Re: Search the same field twice? ( Terry Wilson 2004)
  6. Re: Search the same field twice? ( John Peacock 2004)
  7. Re: Search the same field twice? ( "Nitai @ ComputerOil" 2004)
  8. Search the same field twice? ( devaulw@onebox.com 2004)
search the results, write them to a table and then search the table. If you have a large DB and lots of traffic, using the table rather than a nested search will be less overhead. Brian ----- Original Message ----- From: To: "WebDNA Talk" Sent: Tuesday, December 21, 2004 4:51 AM Subject: Search the same field twice? > I'm using the following search but it is not working as expected: > > [search > db=article.db&woBLURBdata=[keywords]&wnBLURBdata=[blockwords]&max=[stories]] > > I want to include all articles that match one or more of a list of > "keywords" but then I want to exclude those articles that have any > "blockwords." > > The above is not working because it seems that the blockwords portion is > not being applied. Is it possible to search the same field twice? If > not, how can I get the same effect in the search, i.e. match these but not > those? > > I'm trying a hideif as a workaround, but it doesn't match up the max value > since some matches are excluded. > > Any insight appreciated. > > Thanks, > Bill > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ "Brian Boegershausen"

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:

[isfile] ? (1997) How can I do (2000) FlushDatabase Suggestion (1998) WebCAT has the devil in it! (2003) Bug Report, maybe (1997) [OT] MS Security Flaw (2000) Emailer update for Mac? (1998) Setting up shop (1997) corrupted jpgs (2003) Problems with [Applescript] (1997) Problems w/ heavy use of cart header fields? (1998) Is using [URL] recommended even on an email address? (1999) Nav. 4 probs with cart (1997) all records returned. (1997) Web Logs (1998) WebCatalog Use Question (1997) Emailer setup (1997) Problems with [Search] param - Mac Plugin b15 (1997) RE: [WebDNA] Circumnavigate Browser Timeout On Lengthy WebDNA Operations (2014) WebMerchant when CC network is down (1998)