Re: Grouping fields help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57728
interpreted = N
texte = Ok, this is the answer, thanks Brian! The grouping works - until I throw in a rndateindatarq (or not rq) into it, then it's finding all the records as I reported earlier). With this code, the date range search, plus the search on the one field works. Thanks again! GK At 11:36 AM 5/10/2004, you wrote: >Speaking from a logic standpoint, that is an "or". You want 11 *or* 100 >and nothing else (mc can't be equal to 11 *and* 100 at the same time). > >Thus a required Word Or (wo) comparison would be your answer, with a >Whole Word match so you that 11 doesn't match 110 (which contains 11). >No grouping necessary, since you are only testing one field. > >womcdatarq=11+100&mcword=ww > >- brian ------------------------------------------------------------- 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: Grouping fields help ( Gary Krockover 2004)
  2. Re: Grouping fields help ( Gary Krockover 2004)
  3. Re: Grouping fields help ( Gary Krockover 2004)
  4. Re: Grouping fields help ( Brian Fries 2004)
  5. Re: Grouping fields help ( Donovan Brooke 2004)
  6. Re: Grouping fields help ( Donovan Brooke 2004)
  7. Re: Grouping fields help ( Rob Marquardt 2004)
  8. Re: Grouping fields help ( Gary Krockover 2004)
  9. Re: Grouping fields help ( Gary Krockover 2004)
  10. Re: Grouping fields help ( Rob Marquardt 2004)
  11. Re: Grouping fields help ( Donovan Brooke 2004)
  12. Re: Grouping fields help ( Gary Krockover 2004)
  13. Re: Grouping fields help ( Donovan Brooke 2004)
  14. Grouping fields help ( Gary Krockover 2004)
Ok, this is the answer, thanks Brian! The grouping works - until I throw in a rndateindatarq (or not rq) into it, then it's finding all the records as I reported earlier). With this code, the date range search, plus the search on the one field works. Thanks again! GK At 11:36 AM 5/10/2004, you wrote: >Speaking from a logic standpoint, that is an "or". You want 11 *or* 100 >and nothing else (mc can't be equal to 11 *and* 100 at the same time). > >Thus a required Word Or (wo) comparison would be your answer, with a >Whole Word match so you that 11 doesn't match 110 (which contains 11). >No grouping necessary, since you are only testing one field. > >womcdatarq=11+100&mcword=ww > >- brian ------------------------------------------------------------- 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/ Gary Krockover

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:

Mozilla/4. and Browser Info.txt (1997) is sku a REQUIRED field on NT (1997) [WebDNA] XML Help (2009) Country & Ship-to address & other fields ? (1997) [newcart] (1998) [OT] .htaccess & SSL (2004) WebCatalog 4.0.2b5 available (2000) page redirect in webDNA (1997) Email notification to one of multiple vendors ? (1997) WebDelivery downloads alias, not original ? (1997) Appending Information from one db to another (1998) refreshing IE with posted .tmpl (1997) WebCat2b13MacPlugIn - [include] (1997) WebCat2 several catalogs? (1997) 2nd WebCatalog2 Feature Request (1996) sort problems....bug or brain fart? (1997) [FEATURE REQUEST] (2004) gateway application timeouts (1998) RE: WebCat and image maps (1997) What really killed WebDNA? (2007)