Re: Grouping fields help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57717
interpreted = N
texte = 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 <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =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 ------------------------------------------------------------- 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)
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 <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =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 ------------------------------------------------------------- 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/ Donovan Brooke

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:

Proper file locations (1997) Progress !! WAS: Trouble with formula.db (1997) Upgrading old WebCat Database Files (1997) Quitting WebMerchant ? (1997) pc (1997) How do you cause a new window to appear behind the current (1999) Separate SSL Server (1997) URL problem (2007) Bug alert! (1997) Date sorting (1997) New Featured Site (1999) [WebDNA] Authorize.net and [tcpconnect] (2016) Likelihood of a duplicate (2005) this year (2000) Frames and [cart] (1998) [ShowIf] and empty fields (1997) typhoon... (1997) Date Calulation (1997) Webdna sends your serial number on Internet (2003) [WebDNA] DB help (2011)