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:

No luck with taxes (1997) WebCatalog2 for NT Beta Request (1997) Email...Thanks (1997) can WC render sites out? (1997) linetiems in thankyou.tpl (1997) About the + sign (2002) WebCommerce: Folder organization ? (1997) locking variables? (2000) Old Topic - [OT] - server speeds. (2002) form data submission gets truncated (1997) Tron? (2008) setting line item numbers (1998) WebCat2 - [format thousands] (1997) Internet Advancement (2003) Alternative to Authorize.net (2002) WebCatalog can't find database (1997) F3 crashing server (1997) WebCat with WebTen (1998) A quickie question (1997) Authorize.net, SIM, tcpconnect and applescript (2003)