RE: ANother SHOWIF problem
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13473
interpreted = N
texte = Michael ->In my database, I have divided the on sale date of an item into month >(1-12), day (1-31), and year (01-99) fields (for a number of reasons). >If the current date is before the on sale date, I'd like to display some >info (so anything past September 16th will display the on sale date). >For some reason, the following code (which is inside a [SEARCH] context) >*always* displays the on sale date. >[SHOWIF [MATH][DATE][/MATH]<[MATH]{[MTH]/[DAY]/[YR]}[/MATH]]
On sale >[MTH]/[DAY]/[YR][/SHOWIF] >My date pref is set to %m/%d/%Y >I've tried it with WebCat 2.0 and 2.01. >The clock on the web server is correct.Try this instead:[SHOWIF {[DATE]}<{[MTH]/[DAY]/[YR]}]
On sale [MTH]/[DAY]/[YR][/SHOWIF]It appears to work for me.Hope this helps,Marc Eagle StarNine Technologies http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Michael ->In my database, I have divided the on sale date of an item into month >(1-12), day (1-31), and year (01-99) fields (for a number of reasons). >If the current date is before the on sale date, I'd like to display some >info (so anything past September 16th will display the on sale date). >For some reason, the following code (which is inside a
[search] context) >*always* displays the on sale date. >[SHOWIF
[math][date][/MATH]<
[math]{[MTH]/[DAY]/[YR]}[/MATH]]
On sale >[MTH]/[DAY]/[YR][/SHOWIF] >My date pref is set to %m/%d/%Y >I've tried it with WebCat 2.0 and 2.01. >The clock on the web server is correct.Try this instead:[SHOWIF {
[date]}<{[MTH]/[DAY]/[YR]}]
On sale [MTH]/[DAY]/[YR][/SHOWIF]It appears to work for me.Hope this helps,Marc Eagle StarNine Technologies http://www.smithmicro.com/
Marc Eagle
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:
Email within tmpl ? (1997)
loops (2000)
Formulas.db not working (2006)
Using [showif] (2000)
block serving .db files (2002)
Netscape Communicator 4 chops off URLs (was No Data) (1997)
Re:2nd WebCatalog2 Feature Request (1996)
carts on MacOS X Server (2000)
OT - SE robot question (2003)
CSS and SSI books (2004)
Need relative path explanation (1997)
Happy New Year (2008)
4.0.1 behavior question (2000)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Multiple catalog databases and showcart (1997)
PCS Frames (1997)
filemaker - orderfile (1997)
Warning: 50 [MATH] Variable Limit per page (1998)
RE: Web*SSL and WebCatalog (1997)
Loop into field (1998)