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:

Statistics... (2004) math on date? (1997) [WebDNA] Just drop the Server version (2015) creator code (1997) Separate SSL Server (1997) setlineiems and UnitShip Cost (2000) no global [username] or [password] displayed ... (1997) [WebDNA] OT, environment variables os x (2012) [WebDNA] [PROTECT] - Log Out (2011) List Address Changed! (1998) cart info (1998) Problem (1997) WebCatalog Use Question (1997) WebSTAR 2.1 freezes my Mac (1997) cookies and [returnraw] (1997) MasterCounter Weirdness -Resolved! (1997) [format 40s]text[/format] doesn't work (1997) pc (1997) More NT encyption!! (1999) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)