Re: Summ
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17897
interpreted = N
texte = >Hello, >Is there a possibility to summarise a values of a certain field of a >database, even if this field is not [price]? >I mean I have database which contains numeric field >I search the database using certain parameter and get all the records >fitting this parameter. >I want to summarise values of this numeric field, which appear in all >the records that were found by search.Hi Natalie,Summ=T works on all fields, but it looks for an exact match, and I believe it's looking for a *text string* match. So even if you define the field as a numeric field (fieldNameType=num), it may not work if you're trying to retrieve only one summary record out of several records which have values such as 4.00 and 4 and 0004, for example.I've made a habit of formatting all my numeric db values with the same number of digits and decimal points on a field by field basis, and this insures that Summ=T will work in my situation, but if some of your values are numerically equivalent but they don't look the same, it may not work.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>Hello, >Is there a possibility to summarise a values of a certain field of a >database, even if this field is not [price]? >I mean I have database which contains numeric field >I search the database using certain parameter and get all the records >fitting this parameter. >I want to summarise values of this numeric field, which appear in all >the records that were found by search.Hi Natalie,Summ=T works on all fields, but it looks for an exact match, and I believe it's looking for a *text string* match. So even if you define the field as a numeric field (fieldNameType=num), it may not work if you're trying to retrieve only one summary record out of several records which have values such as 4.00 and 4 and 0004, for example.I've made a habit of formatting all my numeric db values with the same number of digits and decimal points on a field by field basis, and this insures that Summ=T will work in my situation, but if some of your values are numerically equivalent but they don't look the same, it may not work.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
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:
Trouble with Netscape (1998)
PSC recommends what date format yr 2000??? (1997)
Some Questions (1997)
WebCatalog 4.0.1b1 is now available (2000)
triggering an update of two frames (1998)
Digest for 4/18/97 (1997)
WebDNA Solutions ... sorry! (1997)
What am I missing (1997)
[listfiles] anomaly (2003)
Users.db corrupted (2002)
Rotating Banners ... (was LinkExchange) (1997)
Merging databases (1997)
[WebDNA] ONLY the FIRST continuous run of numeric chars? (2008)
URGENT: WebCatalog 2.0 (1998)
Summary search -- speed (1997)
Problems with cybercash (2000)
Nested tags count question (1997)
Anyone have an invoicing system? (1999)
TRAINING videos - Prove IT. (1998)
More on [purchase] (1998)