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 valuein a field, it does NOT show you only the values that have just oneoccurrence. In other words, if there are three a and two b and one cin 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 GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
>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 valuein a field, it does NOT show you only the values that have just oneoccurrence. In other words, if there are three a and two b and one cin 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 GromeWebDNA Solutionshttp://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)