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:
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)