Re: SUMM=T does not summarize by the sort parameters ...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 46595
interpreted = N
texte = Or this one....[search db=xxx.db&neskudatarq=[blank]&depricesort=1&pricetype=num&ascategorysort=2&c ategorysumm=t]First sorts the price and then summarize the category. (I hope, I didn't test this)Regards, Harmen van EsJambolaya Eisenhowerlaan 37 3844 AS Harderwijk The Netherlands Tel: +31 (0)341 429629 Fax: +31 (0)341 429029 E-mail: helpdesk@jambolaya.com Internet: www.jambolaya.com > -----Oorspronkelijk bericht----- > Van: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] Namens > Kimberly D. Walls (Ingram) > Verzonden: donderdag 2 januari 2003 15:40 > Aan: WebCatalog Talk > Onderwerp: Re: SUMM=T does not summarize by the sort parameters ... > > Just a thought... > > [search db=xxx.db&neskudatarq=[blank]&ascategorysort=1&categorysumm=t] > [founditems] > [search > db=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 Behalf > Of Kenneth Grome > Sent: Thursday, January 02, 2003 9:08 AM > To: WebCatalog Talk > Subject: SUMM=T does not summarize by the sort parameters ... > > > 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 > &c > ategorysumm=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/ > > > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web 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:
Or this one....[search db=xxx.db&neskudatarq=[blank]&depricesort=1&pricetype=num&ascategorysort=2&c ategorysumm=t]First sorts the price and then summarize the category. (I hope, I didn't test this)Regards, Harmen van EsJambolaya Eisenhowerlaan 37 3844 AS Harderwijk The Netherlands Tel: +31 (0)341 429629 Fax: +31 (0)341 429029 E-mail: helpdesk@jambolaya.com Internet: www.jambolaya.com > -----Oorspronkelijk bericht----- > Van: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] Namens > Kimberly D. Walls (Ingram) > Verzonden: donderdag 2 januari 2003 15:40 > Aan: WebCatalog Talk > Onderwerp: Re: SUMM=T does not summarize by the sort parameters ... > > Just a thought... > > [search db=xxx.db&neskudatarq=[blank]&ascategorysort=1&categorysumm=t] > [founditems] > [search > db=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 Behalf > Of Kenneth Grome > Sent: Thursday, January 02, 2003 9:08 AM > To: WebCatalog Talk > Subject: SUMM=T does not summarize by the sort parameters ... > > > 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 > &c > ategorysumm=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/ > > > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web 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/
Helpdesk - Jambolaya
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:
[WebDNA] FedEx Web Services (2012)
[WebDNA] sem_open bugfix for os x version 6.2 (2012)
ImageMagick (2005)
Fwd: Handling Charges (1999)
Can't load tmpl files (1997)
[WebDNA] Triggers not working (2011)
This is a Test, sorry (1999)
Blasted shownext (request for 4.0) (1998)
webcat in the subject line - SMSI (2002)
SiteGuard Admin Feature ? (1997)
time and welcome (1999)
NT b19 sends extra MIME headers (1997)
Reversed words (1997)
trouble updating records in database (1998)
[shownext] and descending order (1997)
WebCat2final1 crashes (1997)
Dates and Math - Simple Subtraction (2004)
WebCatalog Q & A pages (1997)
TaxTotal Problem (1997)
Saving/Looking Up customer numbers (1998)