Date Sorting
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13698
interpreted = N
texte = Can anyone suggest where I'm going wrong on this date sort.I have a database with date information stored in the day/month/year format.It is stored numerically ie 31/9/1997 and the field is called entrydateI want to sort the accompanying records in descending date order based ontheir entry date into the system.I'm using the following sort URL command :/SearchResults.tmpl$search?db=Classifieds.db&entrydatesort=1&datetype=Date&entrydatesdir=de&neUniqueIddata=0&max=15This sort appeared to list the entries the way I wanted, until the end ofthis month. It now sorts all of September in the correct order (Top of page30/9/1997 and 1/9/1997 at the bottom) but it then places the 1/10/1997entries at the very foot of the and list not at the top.I'd appreciate any advice on how to get this to sort correctly.Kind regards,Tim Rignold_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 911180 Berry Street Facsimile + 61 7 3839 5442Spring Hill Queensland email tim@webhost.com.auAUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE
Associated Messages, from the most recent to the oldest:
Can anyone suggest where I'm going wrong on this date sort.I have a database with date information stored in the day/month/year format.It is stored numerically ie 31/9/1997 and the field is called entrydateI want to sort the accompanying records in descending date order based ontheir entry date into the system.I'm using the following sort URL command :/SearchResults.tmpl$search?db=Classifieds.db&entrydatesort=1&datetype=Date&entrydatesdir=de&neUniqueIddata=0&max=15This sort appeared to list the entries the way I wanted, until the end ofthis month. It now sorts all of September in the correct order (Top of page30/9/1997 and 1/9/1997 at the bottom) but it then places the 1/10/1997entries at the very foot of the and list not at the top.I'd appreciate any advice on how to get this to sort correctly.Kind regards,Tim Rignold_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 911180 Berry Street Facsimile + 61 7 3839 5442Spring Hill Queensland email tim@webhost.com.auAUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE
Tim Rignold
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:
PSC recommends what date format yr 2000??? (1997)
OT: Google (2002)
Reverse WHOIS (2003)
Searching multiple fields from one form field (1997)
WCf2 and nested tags (1997)
weird happenings (1997)
no template caching (1997)
Help! WebCat2 bug (1997)
WebDNA 6 (2004)
webcat- multiple selection in input field (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
WC 2.0 frames feature (1997)
Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997)
WebCat2.0 [format thousands .0f] no go (1997)
unique ascending numbers (2003)
WebCatalog can't find database (1997)
The beginning (1997)
Change Subtotal (2000)
WebCat2 Append problem (B14Macacgi) (1997)
Keep away (1997)