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:

RE: redirect with more than 256 characters (1999) A little syntax help (1997) [math] oddness .. (2002) Major Security Hole IIS NT (1998) Ram usage (1999) Still having install problems (2000) Adding up line items. (2000) OT: How to get more traffic to a site? (2005) Search results templates (1996) IIS error and webcat (2000) server2003 isolation mode (2004) My X-Mas Wish (1999) Caching pages...again (2001) Stumped (1999) Quit revisited (1997) Emailer setup (1997) emailer settings and control questions (1997) RE: Automatic Forwarding using WebCat (1997) [convertchars] Problem (2000) [WebDNA] Listwords and newline (2011)