Re: Grouping fields help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57734
interpreted = N
texte = FYI: If I specify mctype=num, it will only find the first number. I assume that this is because we are searching it as a word search, not a number. If I remove mctype=num, then it will find all the marketing codes separated by the plus sign. Kills my sorting, but I can live with it. 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)
FYI: If I specify mctype=num, it will only find the first number. I assume that this is because we are searching it as a word search, not a number. If I remove mctype=num, then it will find all the marketing codes separated by the plus sign. Kills my sorting, but I can live with it. 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:

[WebDNA] Inline email images (2011) Sherlock and WebCat-2 (1998) Moment of Thanks (1997) formula??? (2000) Lost Field (1998) Make sure I understand this??? (1997) Beta 3.0.3 fix for serial# problem (Mac) (1998) possible, WebCat2.0 and checkboxes-restated (1997) PCS Frames (1997) WebTen and WebCat (1997) CMSBuilder (2004) Summ=T Problem (1997) Frames and WebCat (1997) For you expert WebDNA coders (was Interesting speed (2003) Help name our technology! (1997) Opinion: [input] should be called [output] ... (1997) WebCat2b12--[searchstring] bug (1997) Running 2 two WebCatalog.acgi's (1996) searching for items that begin with a number (2004) can WC render sites out? (1997)