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:
Reminder for beta testers (2000)
Document Contains No Data (1998)
Possible Bug in 2.0b15.acgi (1997)
Nested tags count question (1997)
Quit revisited (1997)
Shipping Calculation Problem (1997)
Sorting error (1997)
off topic - dna snipets (1997)
Multiple Pulldowns/Gary (1997)
Using Applescript to process WebCatalog functions (1998)
WC 4? (2001)
Online magazine- monthly updates and such (1999)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
WebCat b13 CGI -shownext- (1997)
[WebDNA] s3cmd (2014)
Secure Web Server (1999)
automatically updating all records, one by one in a db (2000)
Variables for chat (1997)
thisurl & arguments (2000)
Now you see it now you donīt (1997)