Re: Sorting by date
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11379
interpreted = N
texte = >I am trying to get a database of events to sort by date, but I am not >having any luck. Am I missing something obvious here? The events seem >to be returned in random order.>Here is a bit of what gets returned. >07/16/1997 >07/11/1997 - 07/13/1997 >07/04/1997 This may be too small of a sample, but it looks like they're getting sorted in descending order. Please post your exact search criteria and some more results.Here is something to note:Sorting is always done _before_ ranking, which means that all the best match items are at the top of the list (sorted within themselves), then the next best match items follow that and are sorted within themselves.So for search for Julie, Fred or Marcia, sorted by date, the results would be:(all records with Julie+Fred+Marcia) sorted by date followed by (all records with Julie+Fred) sorted by date (all records with Julie) sorted by dateIf you want the sort to cross all rankings, then you must force the rankings to be equal: you do this by setting AllHit=1 in your search.In your case, you are searching for woMonthData=july, so I think all the results get ranked exactly the same anyway.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>I am trying to get a database of events to sort by date, but I am not >having any luck. Am I missing something obvious here? The events seem >to be returned in random order.>Here is a bit of what gets returned. >07/16/1997 >07/11/1997 - 07/13/1997 >07/04/1997 This may be too small of a sample, but it looks like they're getting sorted in descending order. Please post your exact search criteria and some more results.Here is something to note:Sorting is always done _before_ ranking, which means that all the best match items are at the top of the list (sorted within themselves), then the next best match items follow that and are sorted within themselves.So for search for Julie, Fred or Marcia, sorted by date, the results would be:(all records with Julie+Fred+Marcia) sorted by date followed by (all records with Julie+Fred) sorted by date (all records with Julie) sorted by dateIf you want the sort to cross all rankings, then you must force the rankings to be equal: you do this by setting AllHit=1 in your search.In your case, you are searching for woMonthData=july, so I think all the results get ranked exactly the same anyway.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
Adding extra coding on the fly? (2005)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Parameter Passing (2000)
WebCat2 beta 11 - new prefs ... (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Multiple Merchant Accounts? (1997)
Setting up the server (1997)
SOP for WebDNA talk - MSNBot Crashing (2004)
Bizarre behavior texta behavior (2004)
Reversed words (1997)
calculating tax rates, mail order solutions and version 2 (1997)
with Link i need to (1997)
Extended [ConvertChars] (1997)
Database Program (1997)
Help name our technology! (1997)
[WebDNA] reply vs. new (2009)
Cart Numbers (1997)
Setting up WebCatalog with Retail Pro data (1996)
Possible Bug in 2.0b15.acgi (1997)
[TaxableTotal] - not working with AOL and IE (1997)