Re: SUMM=T does not summarize by the sort parameters ...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 46594
interpreted = N
texte = Just a thought...[search db=xxx.db&neskudatarq=[blank]&ascategorysort=1&categorysumm=t][founditems] [searchdb=xxx.db&eqcategorydatarq=[category]&depricesort=2&pricetype=num&max=1] [founditems] Highest price in category: [price] [/founditems] [/search][/founditems][/search]-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On BehalfOf Kenneth GromeSent: Thursday, January 02, 2003 9:08 AMTo: WebCatalog TalkSubject: SUMM=T does not summarize by the sort parameters ...I never tried it before, but I thought summ=t extracted the firstunique value in the summ field *after* the matching records had beenretrieved and sorted, but it doesn't work that way ...Instead, it seems to extract the first unique value in the summ fieldbefore any sorting is performed -- as if I had used rankinstead of sorting the results.I wanted to get the highest price in each category, so I did this:[searchdb=xxx.db&neskudatarq=[blank]&ascategorysort=1&depricesort=2&pricetype=num&categorysumm=t]... but it didn't work. It created a list of unique category recordsjust fine, but the records it used to create that list were NOT thehighest priced record in each category.:(Sincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines 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 toWeb Archive of this list is at: http://webdna.smithmicro.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:
Just a thought...[search db=xxx.db&neskudatarq=[blank]&ascategorysort=1&categorysumm=t][founditems] [searchdb=xxx.db&eqcategorydatarq=[category]&depricesort=2&pricetype=num&max=1] [founditems] Highest price in category: [price] [/founditems] [/search][/founditems][/search]-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On BehalfOf Kenneth GromeSent: Thursday, January 02, 2003 9:08 AMTo: WebCatalog TalkSubject: SUMM=T does not summarize by the sort parameters ...I never tried it before, but I thought summ=t extracted the firstunique value in the summ field *after* the matching records had beenretrieved and sorted, but it doesn't work that way ...Instead, it seems to extract the first unique value in the summ fieldbefore any sorting is performed -- as if I had used rankinstead of sorting the results.I wanted to get the highest price in each category, so I did this:[searchdb=xxx.db&neskudatarq=[blank]&ascategorysort=1&depricesort=2&pricetype=num&categorysumm=t]... but it didn't work. It created a list of unique category recordsjust fine, but the records it used to create that list were NOT thehighest priced record in each category.:(Sincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines 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 toWeb Archive of this list is at: http://webdna.smithmicro.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/
Kimberly D. Walls \(Ingram\)
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:
# fields limited? (1997)
Locking up with WebCatalog... (1997)
Rollovers (1999)
WebCat editing, SiteGuard & SiteEdit (1997)
WebCat2 beta 11 - new prefs ... (1997)
Sorting by type=date (1999)
return missing item (was:WebCat Sales) (1997)
WebCatalog Q & A pages (1997)
Stat analyzer (1997)
Checkboxes on forms?? (1998)
japanese characters (1997)
[BULK] [WebDNA] sem_open solved (2012)
WebCat2 - [format thousands] (1997)
POST Datamissing? (1998)
Cookie set browser session. (1998)
WebCat2: Found Items syntax, etc. (1997)
triggers (2003)
unable to launch acgi in WebCat (1997)
[date] BUG! (2002)
WebDNA-Talk Digests (1997)