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:
WebCatalog stalls (1998)
WebCat on Alpha? (1997)
database freeze (1997)
upgrading (1997)
Formvariables + Netscape + Frame Set = Confusion (1999)
unable to launch acgi in WebCat (1997)
[WebDNA] path traversal (2020)
Frames (1997)
WCS Newbie question (1997)
A question on sub-categories (1997)
Upload Progress Bar (2003)
Clearing orders and database help! (1997)
writefile on OSX (2004)
Protect tag for large groups? (1999)
WebDNA + SQL Server (2003)
RE: [input] formating (1998)
WebCat2 several catalogs? (1997)
World Address Info (2003)
Here we go again...WebDNA - SQL- Clustering (2006)
Running _every_ page through WebCat ? (1997)