Re: Summ=T Problem

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12542
interpreted = N
texte = >Hi WebCat Techs, >I have a problem with the summ paramater. In the TeaRoom example the >author states that the summ=T parameter will help you to find all unique >values for a specified fieldname in a database. So, in the TeaRoom >example, the Catagory field is summarized to find all of the unique tea >types in the Catagory field. > >After the unique values were listed, I looked at the TeaRoom database >and I found that the Catagory field had no unique values. All of the Teas >in the Catagory field had indentical entries in other records of the >TeaRoom database So, why did WebCat list all of the different type of teas >that were in the Catagory field? Is there an exception to the rule that I >missed?I think you misuderstand the way the author used the term 'unique'.The summary function shows you a single occurrence of every different value in a field, it does NOT show you only the values that have just one occurrence. In other words, if there are three a and two b and one c in the field, WebCat2 will show you one a and one b and one c ...The whole idea is to show you a 'summary' of all the different (or 'unique') entries in that field.Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: Summ=T Problem (Wayne Morishige 1997)
  2. Re: Summ=T Problem (Kenneth Grome 1997)
  3. Re: Summ=T Problem (Grant Hulbert 1997)
  4. Summ=T Problem (Wayne Morishige 1997)
>Hi WebCat Techs, >I have a problem with the summ paramater. In the TeaRoom example the >author states that the summ=T parameter will help you to find all unique >values for a specified fieldname in a database. So, in the TeaRoom >example, the Catagory field is summarized to find all of the unique tea >types in the Catagory field. > >After the unique values were listed, I looked at the TeaRoom database >and I found that the Catagory field had no unique values. All of the Teas >in the Catagory field had indentical entries in other records of the >TeaRoom database So, why did WebCat list all of the different type of teas >that were in the Catagory field? Is there an exception to the rule that I >missed?I think you misuderstand the way the author used the term 'unique'.The summary function shows you a single occurrence of every different value in a field, it does NOT show you only the values that have just one occurrence. In other words, if there are three a and two b and one c in the field, WebCat2 will show you one a and one b and one c ...The whole idea is to show you a 'summary' of all the different (or 'unique') entries in that field.Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Kenneth Grome

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:

Queertrons? (1997) [OT] "Hacker Safe" (2007) WC2f3 (1997) find with exceptions (1997) all db's in one folder and protected (1998) Max connections exceeded clarification please (2002) $Quit, $CloseDatabase corrections (1997) Bad "from" address in sendmail (2004) StoreBuilder UPS/XML code question ... (2003) sort problems....bug or brain fart? (1997) Macos8.6 to X migration problems (2000) Wanted: More Math Functions (or, Can You Solve This?) (1997) Bug or syntax error on my part? (1997) Country & Ship-to address & other fields ? (1997) Running 2 two WebCatalog.acgi's (1996) Summing results of a nested search (2006) WebCat2b15MacPlugin - [protect] (1997) Re:Variable Math (1998) Major problem (1999) WebCat cannot handle compatible search parameters? (1997)