Re: SUMM=T does not summarize by the sort parameters ...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 46596
interpreted = N
texte = No, it doesn't work that way, it summarizes then sorts. In general, the searching always finds the found records then sorts them.>I never tried it before, but I thought summ=t extracted the first unique value in the summ field *after* the matching records had been retrieved and sorted, but it doesn't work that way ... > >Instead, it seems to extract the first unique value in the summ field before any sorting is performed -- as if I had used rank instead of sorting the results. > >I wanted to get the highest price in each category, so I did this: > >[search db=xxx.db&neskudatarq=[blank]&ascategorysort=1&depricesort=2&pricetype=num&categorysumm=t] > >... but it didn't work. It created a list of unique category records just fine, but the records it used to create that list were NOT the highest priced record in each category. > >:( > > >Sincerely, >Kenneth Grome > >--------------------------------------------------- >WebDNA Professional Training and Development Center >175 J. Llorente Street +63 (32) 255-6921 >Cebu City, Cebu 6000 kengrome@webdna.net >Philippines http://www.webdna.net >--------------------------------------------------- > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list
. >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
No, it doesn't work that way, it summarizes then sorts. In general, the searching always finds the found records then sorts them.>I never tried it before, but I thought summ=t extracted the first unique value in the summ field *after* the matching records had been retrieved and sorted, but it doesn't work that way ... > >Instead, it seems to extract the first unique value in the summ field before any sorting is performed -- as if I had used rank instead of sorting the results. > >I wanted to get the highest price in each category, so I did this: > >[search db=xxx.db&neskudatarq=[blank]&ascategorysort=1&depricesort=2&pricetype=num&categorysumm=t] > >... but it didn't work. It created a list of unique category records just fine, but the records it used to create that list were NOT the highest priced record in each category. > >:( > > >Sincerely, >Kenneth Grome > >--------------------------------------------------- >WebDNA Professional Training and Development Center >175 J. Llorente Street +63 (32) 255-6921 >Cebu City, Cebu 6000 kengrome@webdna.net >Philippines http://www.webdna.net >--------------------------------------------------- > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
John Hill
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:
Triggers (2003)
listing [text] variables? (1999)
Press Release hit the NewsWire!!! (1997)
Cart Number sequence (1997)
RE: format problem on NT? (1997)
WebCatalog NT beta 18 now available (1997)
Redirect to _parent? (2002)
WebCatalog Eating 200% of the CPU (2002)
remove line item (2000)
AccountAuthorizer doesn't seem to work (1997)
Bcc in sendmail tag (2000)
Include Not Including (2000)
syntax question, not in online refernce (1997)
AuthorizeNet & StoreBuilder (2002)
[WebDNA] To Commitdatabase or Not to Commitdatabase (2012)
possible, WebCat2.0 and checkboxes-restated (1997)
OSX Jaguar (2002)
[WebDNA] Record click-thrus (2008)
Internet Explorer and caching (2000)
SQL Query Question (2001)