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:

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)