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:
[WebDNA] Databases not staying open (2010)
[WebDNA] Converting | to TAB (2010)
Re:quit command on NT (1997)
graphics server, SSL, Netscape 4.0 (off topic) (1998)
interesting (2003)
Major Security Hole (1998)
[isfolder] and [filename] (1997)
newbie question about zip code search (2003)
Date format (2000)
Errata: WCS Newbie question (1997)
Multiple Merchant Accounts? (1997)
Sharing DBs across domains (2001)
Formatting a .txt file (1998)
WebDNA Writer Needed (1997)
Shipping charges depending on tax rate? (1997)
Location of Webcat site in folder hierarchy (1997)
Re:trouble (1997)
Version f1 status (1997)
It just Does't add up!!! (1997)
Fwd: Problems with Webcatalog Plug-in (1997)