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 EagleStarNine Technologieshttp://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 EagleStarNine Technologieshttp://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:
[WebDNA] Anyone using CODA ?? (2012)
PROBLEM (1997)
validatin (1998)
TaxTotal (2003)
Show if file exists (2004)
Hard Questions ? (1997)
PIXO support (1997)
Mac Typhoon, WebCatalog Plugins Work Better With FireSite Now (1998)
Recording size of uploaded file? (2001)
printing twice? and fix (1997)
HomePage Caution (1997)
Solve the Problem, get the code! (2001)
Price setting question (1998)
Backwards list behavior ... (1997)
Webcat and logging (1998)
multiple credit card merchant accounts/processors (1997)
frames & carts (1997)
RE: Automatic thumbnail images (1998)
Upgrading old WebCat Database Files (1997)
Problems appending to database (1997)