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:skuindatemc105/03/200455205/04/200444305/05/200411405/06/200422505/07/200466605/08/200477705/09/2004100Goal: 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:
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:skuindatemc105/03/200455205/04/200444305/05/200411405/06/200422505/07/200466605/08/200477705/09/2004100Goal: 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)