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