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:
Date search - yes or no (1997)
Changing price for a SLU based on options (size, etc.) (1997)
Re:Emailer and encryption (1997)
requiring form fields? (2000)
RE: [BULK] RE: [WebDNA] [BULK] Web Merchant Authorize net issues (2011)
Database Fields (1997)
[WebDNA] HTML/OS vs. WebDNA ? (2008)
Convertchars Problem (2004)
More on the email templates (1997)
[WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (2012)
can WC render sites out? (1997)
emailer (1997)
RE: Multiple Stores and WebCatalog Prefs (1997)
Re:Review comparison by PC Magazine: Open for On-line Business (1997)
Help! WebCat2 bug (1997)
WebCat2.0 acgi vs plugin (1997)
small hairball -- stuck on [showif] for related db (1998)
Weird G3 Happenings. (1998)
WebCatalog - Mac vs Linux (2000)
(1997)