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:

Initiating NewCart (1997) Grant, please help me ... (1997) 2.1 pricing? (1998) SiteEdit NewFile.html ? (1997) Running a store on BOTH http and https (1998) Searchable WebCat (etc.) Docs ? (1997) shipCost formula (1997) Up and running ... at last !! (1997) ie Posting error (2000) IF/THEN, SHOWIF, and/or HIDEIF (2007) Protect vs Authenicate (1997) Pls Remove me from all Lists (1998) [TEXT SECURE=T] (2000) HTML email (2004) authenticating a second user, the sequel (1997) Max Record length restated as maybe bug (1997) Help with sorting search results sorting (1998) Credit card arrangement (2005) WebCat2 several catalogs? (1997) [WebDNA] GREP Question (2009)