Re: advanced sorting

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37768
interpreted = N
texte = You will need to write the results to a temp db and then sort them by searching that db.:-) Alain> Does anyone know how to sort by such things as [numfound] or the sum result > of fields within the same search context.??? > > kinda like > > > eg... > > select name, count(*) from products > where price > 3 > group by name > order by count(*) having count(*) > 6 > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: advanced sorting (Alain Russell 2001)
  2. advanced sorting (Andrew Simpson 2001)
You will need to write the results to a temp db and then sort them by searching that db.:-) Alain> Does anyone know how to sort by such things as [numfound] or the sum result > of fields within the same search context.??? > > kinda like > > > eg... > > select name, count(*) from products > where price > 3 > group by name > order by count(*) having count(*) > 6 > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/ Alain Russell

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:

Cart Question (1998) webCat craps httpd (2005) Maybe off topic but how to charge (1997) Re:Comments Convertion-part2 (1998) So many lookers, hey smith micro (2003) For those of you not on the WebCatalog Beta... (1997) Validation (2000) notification solutions (1997) Help name our technology! (1997) WebMerchant when CC network is down (1998) A quickie question (1997) [Reload mydata.db] (1998) [WebDNA] WebDNA and PHP cohabitating? (2009) Incrementing a number (1998) Catalogs and W* (1996) Shopping Cart Questions (1998) [WebDNA] AutoFill Drop Down Menu (2009) remotely creating and populating a stock inventory db -almost there! (1999) X etc.... (1999) _ in front of field name (1998)