Grouping fields help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57716
interpreted = N
texte = 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] 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] 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. Database: skuindatemc 105/03/200455 205/04/200444 305/05/200411 405/06/200422 505/07/200466 605/08/200477 705/09/2004100 Goal: to have a check box next to each mc code. IF the box is checked, include all records that equal that mc number. TIA, GK ------------------------------------------------------------- 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)
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] 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] 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. Database: skuindatemc 105/03/200455 205/04/200444 305/05/200411 405/06/200422 505/07/200466 605/08/200477 705/09/2004100 Goal: to have a check box next to each mc code. IF the box is checked, include all records that equal that mc number. TIA, GK ------------------------------------------------------------- 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:

WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) when is date system date or order date? (1997) Web Catalog vs. ICAT (1997) RE: boldwords funky (1998) Cookies (1998) totals (1997) Requiring that certain fields be completed (1997) WebCat/Typhoon Status under Windows (1998) randomness (1997) [WebDNA] WebDNA programmers for hire? (2010) More news on 5.0 (2003) [addlineitems] (1997) Nested tags count question (1997) ISAPI WC6a and Windows 2003 Web Edition (2006) Format question WC Mac f3 (1997) OBDC Support (1997) WebMerchant Only reads 1.4 order files error (1997) test (2001) Help me choose an upgrade path to 5.0 (2003) Password and Allow commands (1998)