Re: Grouping fields help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57718
interpreted = N
texte = Thanks D, I figured it was the "searching the same field twice" scenario, though I thought that's what grouping would bypass. I'll try a multi-search then. Thanks, GK At 10:45 AM 5/10/2004, you wrote: >Gary Krockover wrote: >>Why would this not find any records: >>[search >>db=capture.db&&eqgroup1datarq=11&group1field=mc&eqgroup2datarq=100&group2field=mc&asindatesort=1&indatetype=date&asmcsort=2&mctype=num] >> > >Here you are asking the search to display records where a field has more >than one value. That will never happen. > >>Yet this would find "mc=11": >>[search db=capture.db&rnindatedatarq=[fromdate] >>[todate]&eqgroup1datarq=11&group1field=mc&eqgroup2data=100&group2field=mc&asindatesort=1&indatetype=date&asmcsort=2&mctype=num] >> > >You are requiring "11" to be found so it won't find any other records. > >>i.e., if I rq just one of the groups, it finds that one group but not the >>other, if I rq two or more groups, then it finds no records. > >Yep... this is because you are searching on the same fieldname. > >>Database: >>sku indate mc >>1 05/03/2004 55 >>2 05/04/2004 44 >>3 05/05/2004 11 >>4 05/06/2004 22 >>5 05/07/2004 66 >>6 05/08/2004 77 >>7 05/09/2004 100 >>Goal: to have a check box next to each mc code. IF the box is checked, >>include all records that equal that mc number. > >I don't think so.. I think your goal is to find all records with either >"11" or "100" in the >"mc" field and not dispay anything else.?? am I right? > >I would do two search's that are included in the same form. > >Donovan > > >>TIA, >>GK > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Eucalyptus Design ------------------------------------------------------------- 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)
Thanks D, I figured it was the "searching the same field twice" scenario, though I thought that's what grouping would bypass. I'll try a multi-search then. Thanks, GK At 10:45 AM 5/10/2004, you wrote: >Gary Krockover wrote: >>Why would this not find any records: >>[search >>db=capture.db&&eqgroup1datarq=11&group1field=mc&eqgroup2datarq=100&group2field=mc&asindatesort=1&indatetype=date&asmcsort=2&mctype=num] >> > >Here you are asking the search to display records where a field has more >than one value. That will never happen. > >>Yet this would find "mc=11": >>[search db=capture.db&rnindatedatarq=[fromdate] >>[todate]&eqgroup1datarq=11&group1field=mc&eqgroup2data=100&group2field=mc&asindatesort=1&indatetype=date&asmcsort=2&mctype=num] >> > >You are requiring "11" to be found so it won't find any other records. > >>i.e., if I rq just one of the groups, it finds that one group but not the >>other, if I rq two or more groups, then it finds no records. > >Yep... this is because you are searching on the same fieldname. > >>Database: >>sku indate mc >>1 05/03/2004 55 >>2 05/04/2004 44 >>3 05/05/2004 11 >>4 05/06/2004 22 >>5 05/07/2004 66 >>6 05/08/2004 77 >>7 05/09/2004 100 >>Goal: to have a check box next to each mc code. IF the box is checked, >>include all records that equal that mc number. > >I don't think so.. I think your goal is to find all records with either >"11" or "100" in the >"mc" field and not dispay anything else.?? am I right? > >I would do two search's that are included in the same form. > >Donovan > > >>TIA, >>GK > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Eucalyptus Design ------------------------------------------------------------- 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:

billing system (2003) WebCat B13 Mac CGI -- Frames question (1997) OFF-TOPIC: For Gary Krockover ... (2003) WC 2.0 frames feature (1997) WebCat2: Items xx to xx shown, etc. (1997) TCPConnect (2002) I'm new be kind (1997) POST Datamissing? (1998) WebCat2 as a chat server? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) WebCatalog NT beta 18 problem (1997) Help name our technology! (1997) bug in listwords? (1998) Using Plug-In while running 1.6.1 (1997) Re:quit command on NT (1997) [LOOKUP] (1997) Quit revisited (1997) UPS went bye bye (2006) Faxing orders in place of email (1997) WebCatalog/Mac 2.1b2 - PIXO (1997)