Re: summarizing multiple fields
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30748
interpreted = N
texte = The only way to do this sort of thing is to summarize on the first category, then within that do a second summary with the first category fixed, etc. out to five fields. Here is some pseudo-code (i.e. will not run in WebCat) to get you started:[search sum on cat1] [founditems] [cat1] [search sum on cat2 with cat1=[cat1]] [founditems] [cat2] [search sum on cat3 with cat1=[cat1] and cat2=[cat2]] [founditems] [cat3] [search sum on cat4 with cat1=[cat1] and cat2=[cat2] and cat3=[cat3]] [founditems] [cat4] [search sum on cat5 with cat1=[cat1] and cat2=[cat2] ... ] [founditems] [cat5] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] You can alter the output of the fields to supress blank lines if need be.HTHJohn Peacock ____________________Reply Separator____________________ Subject: summarizing multiple fields Author:
(WebCatalog Talk) Date: 4/21/2000 2:33 PM I have a products database where each product belongs to a primary category and to up to 4 other secondary categories. The secondary categories can be primary categories of some other products or not be the primary category of any product. I want a list of all the different categories and subcategories without any repetitions.Products.db skuname category1 category2 category3 category4 category5Could someone suggest a seacrh string using what would be a combination summary or something, summarizing on the five category fields? Thanks in advance.Jai Jaishankar Jayaram, Database Programmer, Interactive Ink, Inc. Phone: (614) 221-7089 ext 23 Fax: (614) 221-7098 Email:jai@interactiveink.com http://www.interactiveink.com E-business made Easy ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
| |
- Re: summarizing multiple fields (jpeacock@univpress.com 2000)
|
The only way to do this sort of thing is to summarize on the first category, then within that do a second summary with the first category fixed, etc. out to five fields. Here is some pseudo-code (i.e. will not run in WebCat) to get you started:[search sum on cat1] [founditems] [cat1] [search sum on cat2 with cat1=[cat1]] [founditems] [cat2] [search sum on cat3 with cat1=[cat1] and cat2=[cat2]] [founditems] [cat3] [search sum on cat4 with cat1=[cat1] and cat2=[cat2] and cat3=[cat3]] [founditems] [cat4] [search sum on cat5 with cat1=[cat1] and cat2=[cat2] ... ] [founditems] [cat5] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] You can alter the output of the fields to supress blank lines if need be.HTHJohn Peacock ____________________Reply Separator____________________ Subject: summarizing multiple fields Author: (WebCatalog Talk) Date: 4/21/2000 2:33 PM I have a products database where each product belongs to a primary category and to up to 4 other secondary categories. The secondary categories can be primary categories of some other products or not be the primary category of any product. I want a list of all the different categories and subcategories without any repetitions.Products.db skuname category1 category2 category3 category4 category5Could someone suggest a seacrh string using what would be a combination summary or something, summarizing on the five category fields? Thanks in advance.Jai Jaishankar Jayaram, Database Programmer, Interactive Ink, Inc. Phone: (614) 221-7089 ext 23 Fax: (614) 221-7098 Email:jai@interactiveink.com http://www.interactiveink.com E-business made Easy ------------------------------------------------------------- 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
jpeacock@univpress.com
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:
Ok here is a question? (1997)
Multiple download orders of the same product? (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Question about Webcatalog and Webstar for Mac OS X (1998)
[shownext] and sort (1998)
automating txt downloads for conversion to webcat db (2006)
Discounts (2001)
Dates - Search and Sorting (1999)
Include a big block of text (1997)
[input] context (1999)
Keep away (1997)
searchable list archive (1997)
Webcat Hosting in London or UK (2003)
WebCat2 - [format thousands] (1997)
Hello??? (1997)
Problems appending to database (1997)
Emailer problems. (1998)
Show if time tags (1997)
Webcatalog and IIS4b2 (1997)
WC2.0 Memory Requirements (1997)