Re: Date sorting
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13126
interpreted = N
texte = Some more info to add to my last question on date sorting...To set the stage a little more, in the search args I have&datesort=1&datetype=Date&Datesdir=de and when I use this with numerictype dates (ie: 08/20/1997) it sorts dates correctly. But that is not whatwe really wanted.So I changed all the dates in the db to the textual style with full monthname to try it out (ie: August 20, 1997) - that did not work.Then I went in and changed all those to abreviated month names like in thedocs (ie: Aug 20, 1997),- that didn't work either, which it says in thedocs that it will sort dates like that.Has anyone else had problems or successes with sorting dates in the textualformat?TIA.>In the docs it says that the when using fieldnameTYPE=date comparison that>it will sort textual dates like Jan 1, 1997 but will it also work with>dates that are not aberviated like January 1, 1997?>>And does the field with the dates all have to be the same way, all>numerical or all textual to work correctly?>>>Britt T.>-------------------------------------------------------->|| Britt@fishingworld.com || Britt@easttexas.com ||>-------------------------------------------------------->|| World Masters - || P.O. Box 1989 ||>|| Graphic Designs, || Lindale, TX 75771 ||>|| Web Site Development, || Phone: (903) 882-8877 ||>|| Web Site Hosting. || Fax: (903) 882-3110 ||>--------------------------------------------------------Britt T.--------------------------------------------------------|| Britt@fishingworld.com || Britt@easttexas.com ||--------------------------------------------------------|| World Masters - || P.O. Box 1989 |||| Graphic Designs, || Lindale, TX 75771 |||| Web Site Development, || Phone: (903) 882-8877 |||| Web Site Hosting. || Fax: (903) 882-3110 ||--------------------------------------------------------
Associated Messages, from the most recent to the oldest:
Some more info to add to my last question on date sorting...To set the stage a little more, in the search args I have&datesort=1&datetype=Date&Datesdir=de and when I use this with numerictype dates (ie: 08/20/1997) it sorts dates correctly. But that is not whatwe really wanted.So I changed all the dates in the db to the textual style with full monthname to try it out (ie: August 20, 1997) - that did not work.Then I went in and changed all those to abreviated month names like in thedocs (ie: Aug 20, 1997),- that didn't work either, which it says in thedocs that it will sort dates like that.Has anyone else had problems or successes with sorting dates in the textualformat?TIA.>In the docs it says that the when using fieldnameTYPE=date comparison that>it will sort textual dates like Jan 1, 1997 but will it also work with>dates that are not aberviated like January 1, 1997?>>And does the field with the dates all have to be the same way, all>numerical or all textual to work correctly?>>>Britt T.>-------------------------------------------------------->|| Britt@fishingworld.com || Britt@easttexas.com ||>-------------------------------------------------------->|| World Masters - || P.O. Box 1989 ||>|| Graphic Designs, || Lindale, TX 75771 ||>|| Web Site Development, || Phone: (903) 882-8877 ||>|| Web Site Hosting. || Fax: (903) 882-3110 ||>--------------------------------------------------------Britt T.--------------------------------------------------------|| Britt@fishingworld.com || Britt@easttexas.com ||--------------------------------------------------------|| World Masters - || P.O. Box 1989 |||| Graphic Designs, || Lindale, TX 75771 |||| Web Site Development, || Phone: (903) 882-8877 |||| Web Site Hosting. || Fax: (903) 882-3110 ||--------------------------------------------------------
Britt T.
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:
Include remote? (1998)
[WebDNA] mac osx permissions problem (2010)
Emailer setup (1997)
setting cookies for another domain? (2002)
MacAuthorize order data fields WAS:How To question... (1997)
Date and Time Math (1997)
RE: Still Learning (1997)
[WebDNA] Webdna error on plain html site - Update (2013)
how to use WebCat w. SSL & CyberCash (1998)
Items XX to XX shown (1997)
[encrypt] without seed (2004)
WebCat2 beta 11 - new prefs ... (1997)
[ot] Still Interested In Acquiring Hosting Companies (2006)
Menu Syntax on Edit/Add templates (1998)
Webmerchant quitting (1998)
WC2f3 (1997)
Speaking of () Emailer not working (1998)
PSC recommends what date format yr 2000??? (1997)
Attn: Bug in GeneralStore example b15 (1997)
WebCommerce: Folder organization ? (1997)