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:

    
  1. RE: ANother SHOWIF problem (Michael Winston 1997)
  2. RE: ANother SHOWIF problem (Marc Eagle 1997)
  3. Re: ANother SHOWIF problem (Michael Winston 1997)
  4. Re: ANother SHOWIF problem (Kenneth Grome 1997)
  5. Re: ANother SHOWIF problem (Kenneth Grome 1997)
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:

Superfilous Characters (1998) [shownext] and sort (1998) PIXO (1997) Shop till you drop dead on the avenue ... (1997) results in a table (2000) A dynamic database. (1997) [DOS] (1999) OLD PROBLEM (1997) how do we turn off staticpages page creation? (2003) Jimmy Houssen (1998) [WebDNA] return missing db number (2010) WebCat2 - Getting to the browser's username/password data (1997) Adding up weights (1998) RE: [WebDNA] Ubuntu 18.04 & Apache2 & WebDNA fcgi - File upload error (2019) Search/sort in URL Was: GuestBook example (1997) Nested Loops and SHOWIFs (1997) Looking for WebCatalog Linux experience/comments. (2001) can WC render sites out? (1997) Fax Broadcast (1998) Cold Fusion Buster (1997)