Re: user selectable sort order
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33699
interpreted = N
texte = >[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/
Associated Messages, from the most recent to the oldest:
>[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/
WebDNA Support
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:
Date format problems (1997)
Sales Tax Rates 10/01/01 (2001)
Text data with spaces in them... (1997)
PCS search results page (1998)
Using Applescript to process WebCatalog functions (1998)
Search returns all, not 20 (1997)
Refering page (1998)
japanese characters (1997)
Limiting user access to .tmpl files (1997)
WebMerchant - MacAuthorize (1999)
WebCat2b13MacPlugIn - More limits on [include] (1997)
appending to my last post (1999)
Claris HomePage messes up the code (1997)
Chatroom (2000)
Database Security Rev., (2002)
[OT] 'Email this story to a friend' (2003)
Draft Manual, Tutorial, and more (1997)
emailer w/F2 (1997)
Press Release hit the NewsWire!!! (1997)
SetLineItem (1997)