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:
[search] in formulas.db (1997)
[WebDNA] Date: header on emails - timezone problem perhaps (emai)
Taxes rates based on item and State (1998)
HELP WITH DATES (1997)
More on the email templates (1997)
Cart questions (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
WebCatalog for Postcards ? (1997)
Summarising on two fields (1998)
Question about replacing words (1998)
missing records (1998)
I give up!! (1997)
Help w/Multi User Admins (1997)
bye bye tax rate (1998)
SSL (1998)
Re1000001: Setting up shop (1997)
Add a field to the error log? (1997)
Shipping charge question (2003)
unitshipcost vs shipcosts (1997)
2.0 Info (1997)