Re: Laying an egg.
This WebDNA talk-list message is from 1998
numero = 20640
interpreted = N
texte = On 10/23/98 8:59 AM The Mooseman wrote > > >[showif [math date]{11/22/96}+{00/00/000}[/math]<[date]] >
Bingo! >[/showif] >What version of webcat are you using?If it 3.01 then its possible you have bad prefs templates. Here is a note from our sponsor:>We have discovered a bug in the Admin templates for WebCatalog 3.0 and >3.0.1 that causes dates to be interpreted incorrectly. The Administration >Preferences template has a popup for Read Date Format which puts >uppercase values MDY into the ReadDateFormat preference, instead of the >correct mdy. This causes date sorting and date math to perform incorrect >date comparisons. > >You can solve this problem by replacing the following 3 lines in your >WebCatalog/Admin/AdminPrefs.tpl file: > >
db=[PrefsDB]&lookInField=preference&value=ReadDateFormat&returnField=value >¬Fo >und=mdy]]selected[/ShowIf]>Month/Day/Year (American) > db=[PrefsDB]&lookInField=preference&value=ReadDateFormat&returnField=value >¬Fo >und=mdy]]selected[/ShowIf]>Day/Month/Year (European) > db=[PrefsDB]&lookInField=preference&value=ReadDateFormat&returnField=value >¬Fo >und=mdy]]selected[/ShowIf]>Year/Month/Day (Text-Sortable) Robert Minor _________________________________________________________________________ Cybermill Communications webmaster@cybermill.com 8616 Joseph Ave. http://www.cybermill.com St. Louis, MO 63144 (314) 962-4024 _________________________________________________________________________ Purveyors of fine websites and high bandwith. Colocation and domain hosting available.
Associated Messages, from the most recent to the oldest:[date] ] >Bingo! >[/showif] >What version of webcat are you using?If it 3.01 then its possible you have bad prefs templates. Here is a note from our sponsor:>We have discovered a bug in the Admin templates for WebCatalog 3.0 and >3.0.1 that causes dates to be interpreted incorrectly. The Administration >Preferences template has a popup for Read Date Format which puts >uppercase values MDY into the ReadDateFormat preference, instead of the >correct mdy. This causes date sorting and date math to perform incorrect >date comparisons. > >You can solve this problem by replacing the following 3 lines in your >WebCatalog/Admin/AdminPrefs.tpl file: > > db=[PrefsDB]&lookInField=preference&value=ReadDateFormat&returnField=value >¬Fo >und=mdy]]selected[/ShowIf]>Month/Day/Year (American) > db=[PrefsDB]&lookInField=preference&value=ReadDateFormat&returnField=value >¬Fo >und=mdy]]selected[/ShowIf]>Day/Month/Year (European) > db=[PrefsDB]&lookInField=preference&value=ReadDateFormat&returnField=value >¬Fo >und=mdy]]selected[/ShowIf]>Year/Month/Day (Text-Sortable) Robert Minor _________________________________________________________________________ Cybermill Communications webmaster@cybermill.com 8616 Joseph Ave. http://www.cybermill.com St. Louis, MO 63144 (314) 962-4024 _________________________________________________________________________ Purveyors of fine websites and high bandwith. Colocation and domain hosting available.
Bob Minor
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:
Problems with [Search] param - Mac Plugin b15 (1997) Order not created error (1997) WebCat2b12--[searchstring] bug (1997) Hosts who have upgraded to v5.0? (2003) Ampersand is breaking search context (1999) Emailer setup (1997) FEW QUESTIONS (1997) Thanks ! (1997) CGI Request Time Out (1997) Include Files (1998) WebCat2: multiple currency support (1997) Error Log.db --however (1997) form image (2000) Instructions for Digest (1997) [WebDNA] Major grep/convertchars linux issues when writing to db (2010) shipping costs (1998) Cold Fusion Warm and Fuzzy? (1999) WebCat2 - Getting to the browser's username/password data (1997) Updating one table with another (1998) creator code (1997)