Re: Date Sorting
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12425
interpreted = N
texte = >Dates are stored in a db in the format mm dd. I'll try adding to>geEventData=Jan 01 and see if that does it. I did not use the year in the>date, because it just didn't seem important.That won't work. WebCatalog is not psychic -- it has no idea what Jan 01 means, so it treats it like a simple string of letters. So it will get alphabetized as text, and that means Feb comes before Jan.It does know what 12/7/1997 means, though, because that is a supported date format.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors =====Pacific Coast Software | WebCatalog Pro, WebCommerce Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>Dates are stored in a db in the format mm dd. I'll try adding to>geEventData=Jan 01 and see if that does it. I did not use the year in the>date, because it just didn't seem important.That won't work. WebCatalog is not psychic -- it has no idea what Jan 01 means, so it treats it like a simple string of letters. So it will get alphabetized as text, and that means Feb comes before Jan.It does know what 12/7/1997 means, though, because that is a supported date format.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors =====Pacific Coast Software | WebCatalog Pro, WebCommerce Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/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:
WebCat 5 Intranet Question (2003)
MetaKW tags from databases (2006)
Location of Webcat site in folder hierarchy (1997)
Max Record length restated as maybe bug (1997)
Multiple Carts with Mac IE (2002)
trouble updating records in database (1998)
[WebDNA] Friday's.. WIP thread (2009)
SSL problems (2002)
[WebDNA] sort parameters in search (2015)
Comments in db? (1997)
hiding return characters (2000)
WebCat2 beta 11 - new prefs ... (1997)
functions... (2005)
underscore in variable name (2000)
synching databases on multiple servers (1997)
WebCat/CyberStudio Compatibility (1998)
Checking for pre-existing passwords (1998)
Can I invoke an ssi plugin from within a webcat page (1997)
Forumulas.db & Variables (2002)
Great product and great job ! (1997)