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:
HTML Editors (1997) Migrating From One Server To Another (2003) reserved characters for field names? (1998) Webcatalog error, Plug-in for Webstar (1996) Getting total number of items ordered (1997) Normalizing Dates and Phone numbers (2000) Re:Realtime Transaction Processing (1999) Searchable WebCat (etc.) Docs ? (1997) [WebDNA] Needing a new host.... (2013) Migrating to NT (1997) Examples of cross-selling with WebCatalog? (1998) setting taxable to true (1997) WebCatalog NT beta 18 now available (1997) formulas.db ?? (1998) WebCatalog Install Problem (2005) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [ConvertChars] problem (1997) PIXO (1997) You *can!!* overwrite username/password using an HTML form. Also, experts *please* see Q at end (2000) Summing fields (1997)