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:

WebCatalog can't find database (1997) Re2: frames & carts (1997) Where's Cart Created ? (1997) Simple Database close connection (2001) What am I missing (1997) Design Help Needed (1998) [OT] Local San Diego SIGs (2003) [WebDNA] TRIM (2008) [TaxableTotal] - not working with AOL and IE (1997) MATH TIME (1997) [WriteFile] problems (1997) Exclude by date - multiple (1997) Its not that weird. (1997) [WebDNA] Barcode (2014) Sample Tearoom Search Error (1997) Hard Questions ? (1997) $Quit, $CloseDatabase corrections (1997) Spell Check (2005) Adding up line items. (2000) Thankyou Ronny (2003)