Re: Summarizing on two fields
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18359
interpreted = N
texte = I am trying to sort and sum on two fields. One field is a date field, the other is a field with a company name. The db contains data for the past 7 days. Ideally it should contain one line for each company for each day, but in reality, a few companies is missing every day.I wanted to display a search result where I searched the database, reporting the most current data for every company. I tried something like:[search db=company.db&gecompanydata=[blank]&companysort=1&datesort=2&companysumm=t]So essentially I want the result to be summarized by company, but instead of returning first entry for the company, and thereby the oldest information, I wanted it to return the most recent entry. But it always returned the oldest information.If I could do this, I would be VERY happy.BTW, Ill be offline for 2 weeks now so I will not be able to respond further until then.And, I will once again use the opportunity to thank all you guys on PCS for excellent and friendly support every time I have contacted you.Per Christian Lied
Since I am used to PERL, one thing I really would like to see in a future WebCat is an equivalent to 'split'. >>Yes you can only summarize one field at a time. >No, this is not correct. > >You can certainly summarize two fields in a search. What sort of results >were you getting? > >John. > > > > John A. Hill, V.P. Marketing > Pacific Coast Software >eCommerce / Web Developer Tools > http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
I am trying to sort and sum on two fields. One field is a date field, the other is a field with a company name. The db contains data for the past 7 days. Ideally it should contain one line for each company for each day, but in reality, a few companies is missing every day.I wanted to display a search result where I searched the database, reporting the most current data for every company. I tried something like:[search db=company.db&gecompanydata=[blank]&companysort=1&datesort=2&companysumm=t]So essentially I want the result to be summarized by company, but instead of returning first entry for the company, and thereby the oldest information, I wanted it to return the most recent entry. But it always returned the oldest information.If I could do this, I would be VERY happy.BTW, Ill be offline for 2 weeks now so I will not be able to respond further until then.And, I will once again use the opportunity to thank all you guys on PCS for excellent and friendly support every time I have contacted you.Per Christian Lied
Since I am used to PERL, one thing I really would like to see in a future WebCat is an equivalent to 'split'. >>Yes you can only summarize one field at a time. >No, this is not correct. > >You can certainly summarize two fields in a search. What sort of results >were you getting? > >John. > > > > John A. Hill, V.P. Marketing > Pacific Coast Software >eCommerce / Web Developer Tools > http://www.smithmicro.com
Per Christian Lied
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:
Re:[ShowIf] and empty fields (1997)
Tab Charactor (1997)
Test (2003)
YACBQ.....(Yet another checkbox question) (2000)
WebCatalog can't find database (1997)
problem: type 2 errors (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
Re:affiliate marketing program (1998)
Multiple prices (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Text vs. Math (2000)
Stuck - Figured out?? (2003)
Site Test Please [OT] (2005)
Server Load (2000)
all records returned. (1997)
WebCat2: Items xx to xx shown, etc. (1997)
[WriteFile] problems (1997)
Whats wrong with this code? (1998)
Email notification to one of multiple vendors ? (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)