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:
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)