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:
Introduction/Tutorial/QuickStart (1997)
WC2.0 Memory Requirements (1997)
Authorize net down? (2005)
Re2: frames & carts (1997)
Signal Raised (1997)
SiteGuard Use Question (1997)
Tax Collection for Different Items (2003)
Typhoon Rev. and PCS store problems (1999)
PCS Frames (1997)
RAM variables (1997)
Server Freeze...not always (1998)
HTML encoding in URLs (1997)
summ=T (2003)
Anyone selling out? (2006)
NT BETA BUG???? (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Text data with spaces in them... (1997)
adding up in a db (1997)
2.1.5: Too Many Nested [xxx] (1998)
If Empty ? (1997)