What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

    
  1. Re: SUMM=T does not summarize by the sort parameters ... (John Hill 2003)
  2. Re: SUMM=T does not summarize by the sort parameters ... (Helpdesk - Jambolaya 2003)
  3. Re: SUMM=T does not summarize by the sort parameters ... (Kimberly D. Walls \(Ingram\) 2003)
  4. SUMM=T does not summarize by the sort parameters ... (Kenneth Grome 2003)
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:

WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Using Japanesse text with webcat. (1998) b12 cannot limit records returned and more. (1997) New public beta available (1997) cart (1997) updating with ProductEditor (1998) [HIDEIF] inside [FOUNDITEM] (1997) Can I invoke an ssi plugin from within a webcat page (1997) triggering an update of two frames (1998) Success Stories (1997) HTML editing and webcatalog (2000) changing boxes (2008) Store results of GetChars? (2003) Return records from another (1997) Intel WebDNA, FYI (2006) Date search bug (1997) OT: Please set your computer's clock (1997) RE: Shopping Cart Questions (1998) Only charge card when product shipped ? (1997) WCS Newbie question (1997)