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:

One more time (1997) Semi-OT: [Mimeheader] and flash (2002) updating with ProductEditor (1998) [OT] XServe networking PITA (2004) Replace context (1998) GD Scumbucket Spammer (2004) WebCat2b13MacPlugIn - more [date] problems (1997) creating a ShipCosts database (1997) webcat- multiple selection in input field (1997) date sorting and 'template (1997) Phonetic Search (2001) WebCatalog for NT (1999) WebDNA 5.0 freeBSD?!!? (2003) Showif for mulitple variations (1997) writing checkboxes to a database (2000) [SearchString] problem with [search] context (1997) 2 questions (2000) question: back button prevention (1997) WebCat2b13MacPlugIn - [include] (1997) New Command prefs ... (1997)