Re: <fieldname>summ=T
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54786
interpreted = N
texte = From the docs... Note: it is important to sort by the same field you wish to summarize -- this sorting enables WebDNA to easily see when a field changes from one value to another in the sequence of found items. I'm not sure if this will help, but you could try adding the following to your search, and removing one-at-a-time to see if it still works: [/!]neCOLOURSdata=[blank]&[!] [/!]COLURSsort=1&[!] [/!]COLOURSsdir=as&[!] Btw, you spelled colors wrong:-) Andy On Tuesday, December 9, 2003, at 04:14 PM, Brian Fries wrote: > COLORSsumm=T will take all the founditems and only return one item > with each discrete value of COLOURS - e.g. one "BLUE" item, one > "GREEN" item, one item with no value in COLOURS, etc. > > Perhaps this is too restrictive for your results? Can you give an > example of what you get with COLOURSsumm=T vs. without it? > > - brian > > On Dec 9, 2003, at 12:57 PM, Donovan Brooke wrote: > >> I have this search: >> [search db=admin/products.db[!] >> [/!]&neIDdatarq=[the_ID][!] >> [/!]&nePRODUCT_IDdatarq=[ProdID][!] >> [/!]&eqCATEGORYdata=[theCATEGORY][!] >> [/!]&eqBRANDdata=[theBRAND][!] >> [/!]&grNO_INVENTORYdatarq=0[!] >> [/!]&NO_INVENTORYtype=num&max=4] >> >> When I append: >> ..."COLOURSsumm=T"] >> >> after the max=4 peram my results go from >> almost there to not even close ;-) >> >> Any idea? >> Thanks, >> Donovan >> >> >> >> Donovan Brooke wrote: >> >>> Hi, >>> This seems to be messing up my results.?? >>> I'm trying to display only one of each of this field type. >>> Maybe I don't know exactly how the summ=T works? >>> Thx, >>> Donovan >>> > -- Brian Fries, BrainScan Software -- > http://www.brainscansoftware.com -- ------------------------------------------------------------- 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:
From the docs... Note: it is important to sort by the same field you wish to summarize -- this sorting enables WebDNA to easily see when a field changes from one value to another in the sequence of found items. I'm not sure if this will help, but you could try adding the following to your search, and removing one-at-a-time to see if it still works: [/!]neCOLOURSdata=[blank]&[!] [/!]COLURSsort=1&[!] [/!]COLOURSsdir=as&[!] Btw, you spelled colors wrong:-) Andy On Tuesday, December 9, 2003, at 04:14 PM, Brian Fries wrote: > COLORSsumm=T will take all the founditems and only return one item > with each discrete value of COLOURS - e.g. one "BLUE" item, one > "GREEN" item, one item with no value in COLOURS, etc. > > Perhaps this is too restrictive for your results? Can you give an > example of what you get with COLOURSsumm=T vs. without it? > > - brian > > On Dec 9, 2003, at 12:57 PM, Donovan Brooke wrote: > >> I have this search: >> [search db=admin/products.db[!] >> [/!]&neIDdatarq=[the_ID][!] >> [/!]&nePRODUCT_IDdatarq=[ProdID][!] >> [/!]&eqCATEGORYdata=[theCATEGORY][!] >> [/!]&eqBRANDdata=[theBRAND][!] >> [/!]&grNO_INVENTORYdatarq=0[!] >> [/!]&NO_INVENTORYtype=num&max=4] >> >> When I append: >> ..."COLOURSsumm=T"] >> >> after the max=4 peram my results go from >> almost there to not even close ;-) >> >> Any idea? >> Thanks, >> Donovan >> >> >> >> Donovan Brooke wrote: >> >>> Hi, >>> This seems to be messing up my results.?? >>> I'm trying to display only one of each of this field type. >>> Maybe I don't know exactly how the summ=T works? >>> Thx, >>> Donovan >>> > -- Brian Fries, BrainScan Software -- > http://www.brainscansoftware.com -- ------------------------------------------------------------- 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/
Andy Mowrey
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:
New WebDNA Solutions ... (1997)
WebCat2b12 - nesting [tags] (1997)
WebDNA for Dummies (2004)
boldwords funky (1998)
Test, sorry (2004)
Need help with emailer- 2 issues (1997)
multiple search commands (1997)
Unix line endings (2003)
[WebDNA] Sorry WebDNA server not running (2015)
Any problem with using a g4 with WebCat (2000)
BBEdit WedDNA Codeless Language Module (2004)
$Replace with [founditems] (1997)
[shownext] and descending order (1997)
truncating email part II (1997)
Weird happenings when viewing in IE 3.02 (1998)
Search multiple fields (1997)
[/application] error? (1997)
Secure server question (1997)
Strange intermittent WebDNA problems (2008)
5.0 feature request: (2001)