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:

    
  1. 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:

Modifying order output (1997) Help! WebCat2 bug (1997) WebCatalog for Postcards ? (1997) Applescript error (1998) [format 40s]text[/format] doesn't work (1997) [countwords] (2002) [WebDNA] Function "libraries" (2009) Database (2002) Re:no [search] with NT (1997) Dubble Sku's in a Database (1999) Re1000002: Setting up shop (1997) Some Questions (1997) Looking for WebCatalog Linux experience/comments. (2001) BBEdit and WebCatalog 2.0? (1997) Help name our technology! I found it (1997) HomePage Caution (1997) DATES (2004) [format 40s]text[/format] doesn't work (1997) question: back button prevention (1997) WebCatalog2 Feature Feedback (1996)