Re: user selectable sort order

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33717
interpreted = N
texte = Thank you for the answer.As for the urban legend. I thought someone from PCS had mentioned once that storing dates as numbers would speed up sorting and comparisons as they would be treated as numbers. Because storing them as real dates causes WC to convert them to numbers first before doing any calculations.For this reason I am planning on converting the dates from the existing format to the text sortable. Could you please verify the above for me and the other here as far as performance goes?Thank youOn Monday, June 26, 2000, WebDNA Support wrote: >>[Search >db=/databases/members.db&eqCountryDatarq=[country]&CountryCase=T&eqCityDatarq=[url][city][/url]&eqstateDatarq=[state]&StateCase=T&max=[max_records]&[sortParam]Sort=1&[sortParam]Type=Date&[sortParam]Sdir=[sortDir]&startAt=[startat]] >> >>The results are not sorted properly. At least not in the way I would >>like them to be sorted. > >You are searching multiple fields, which means WebCatalog sorts by >'best match', meaning that records which match the most criteria will >be sorted to the top, then sub-sorted by date within that >order. > >If you want to disable the 'best match' sorting so that your date >sorting overrides it, add allHit=1 to your search criteria. > >There is no need to convert your dates to some numeric format -- that >is an urban legend. > >Technical Support ********************************** >Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) >16855 West Bernardo Drive, #380 | ------------------------- >San Diego, CA 92127 | Software & Site Development >WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com > Fax: (858) 675-0372 >********************************** > >------------------------------------------------------------- >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: user selectable sort order (WebDNA Support 2000)
  2. Re: user selectable sort order (Dale 2000)
  3. Re: user selectable sort order (WebDNA Support 2000)
  4. Re: user selectable sort order (Nitai @ Eyework 2000)
  5. Re: user selectable sort order (Dale Therio 2000)
  6. Re: user selectable sort order (Nitai @ Eyework 2000)
  7. user selectable sort order (Dale 2000)
Thank you for the answer.As for the urban legend. I thought someone from PCS had mentioned once that storing dates as numbers would speed up sorting and comparisons as they would be treated as numbers. Because storing them as real dates causes WC to convert them to numbers first before doing any calculations.For this reason I am planning on converting the dates from the existing format to the text sortable. Could you please verify the above for me and the other here as far as performance goes?Thank youOn Monday, June 26, 2000, WebDNA Support wrote: >>[Search >db=/databases/members.db&eqCountryDatarq=[country]&CountryCase=T&eqCityDatarq=[url][city][/url]&eqstateDatarq=[state]&StateCase=T&max=[max_records]&[sortParam]Sort=1&[sortParam]Type=Date&[sortParam]Sdir=[sortDir]&startAt=[startat]] >> >>The results are not sorted properly. At least not in the way I would >>like them to be sorted. > >You are searching multiple fields, which means WebCatalog sorts by >'best match', meaning that records which match the most criteria will >be sorted to the top, then sub-sorted by date within that >order. > >If you want to disable the 'best match' sorting so that your date >sorting overrides it, add allHit=1 to your search criteria. > >There is no need to convert your dates to some numeric format -- that >is an urban legend. > >Technical Support ********************************** >Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) >16855 West Bernardo Drive, #380 | ------------------------- >San Diego, CA 92127 | Software & Site Development >WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com > Fax: (858) 675-0372 >********************************** > >------------------------------------------------------------- >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/ Dale

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:

question: webmerchant connection (1997) [showif] not working (2003) Fwd: FW: Purchase Command error (1997) [OT] MacOs IE5 topmargin and leftmargin bug (2000) Credit Card Number checking (1997) Problem with [CART] number (1998) Append (1999) Colors in cart (2002) setheader and retrieve it immediatly (2001) multiple selected Checkboxes (1998) [OT] DOD again (2003) Stinkin' [Referrer] (1998) problems with 2 tags shakur (1997) Error Lob.db records error message not name (1997) WebCat2: multiple currency support (1997) Re:no [search] with NT (1997) Separate SSL Server (1997) Weird Problem (1997) about this server and links to who (1997) Loop to write data? (2003)