Fun with Dates - finally resolved but....

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12345
interpreted = N
texte = Hey guys thanks for all the help and advice. This thing really had me stumped because all my non-[math], non-[date] methods of searching and restricting by date range worked fine. But anytime I tried the math/date combination it all went no where. Now, I hadn't really thought about it but somewhere along the lines I realizd that the fact that this code was embedded in my index.html as opposed to a .tmpl could be the problem. So I moved everything over to a index.tmpl file and everything is singing (well almost - more about that in a second).Now, I had my suffix mapping set so that WC processes both .html and .tmpl suffixes. Shouldn't that give me identical functionality regardless of whether my code is in my index.html file versus index.tmpl? And yes the code is completely identical. Is there something specific to the date/math combo that requires that that code reside in a .tmpl file??? If not I must have a problem with my .html suffix mapping.Also I've happened upon an anomoly ('cause I would never cry BUG knowing that Grant would just make me look foolish after showing me the errors of my ways...). Anyway here's my code which works for the most part: days.
And here's the problem: As I test the various pull-down options everthing appears to work fine - I get a small number of records with start dates in the next month, a greater number in the next 2 months etc. until I hit the 6 month/180 days option. For whatever reason it coughs and only gives me only 2-3 records instead of all the records that had been found with the earlier options as it should... Any ideas??-marty Associated Messages, from the most recent to the oldest:

    
  1. Re: Fun with Dates - finally resolved but.... (Christer Olsson 1997)
  2. Re: Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
  3. Re: Fun with Dates - finally resolved but.... (Kenneth Grome 1997)
  4. Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
Hey guys thanks for all the help and advice. This thing really had me stumped because all my non-[math], non-[date] methods of searching and restricting by date range worked fine. But anytime I tried the math/date combination it all went no where. Now, I hadn't really thought about it but somewhere along the lines I realizd that the fact that this code was embedded in my index.html as opposed to a .tmpl could be the problem. So I moved everything over to a index.tmpl file and everything is singing (well almost - more about that in a second).Now, I had my suffix mapping set so that WC processes both .html and .tmpl suffixes. Shouldn't that give me identical functionality regardless of whether my code is in my index.html file versus index.tmpl? And yes the code is completely identical. Is there something specific to the date/math combo that requires that that code reside in a .tmpl file??? If not I must have a problem with my .html suffix mapping.Also I've happened upon an anomoly ('cause I would never cry BUG knowing that Grant would just make me look foolish after showing me the errors of my ways...). Anyway here's my code which works for the most part: days.
And here's the problem: As I test the various pull-down options everthing appears to work fine - I get a small number of records with start dates in the next month, a greater number in the next 2 months etc. until I hit the 6 month/180 days option. For whatever reason it coughs and only gives me only 2-3 records instead of all the records that had been found with the earlier options as it should... Any ideas??-marty marty@artwerks.com (Marty Schmid)

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:

[WebDNA] Manual install on Manjaro and MariaDB (2017) Question About XML Style Syntax (2000) Assigning new CART number (1997) Spiders (2000) Bug Report, maybe (1997) [OT] Industry standard for missing orders (2003) Generating Searches on the fly? (1999) PSC recommends what date format yr 2000??? (1997) Sorting by date (1997) Possible Bug in 2.0b15.acgi (1997) Problems with [Applescript] (1997) Summing fields (1997) Grep and removing text (2002) 2.0Beta Command Ref (can't find this instruction) (1997) E-mailer error codes (1997) Shopping Cart Problem (1998) WebCatalog Hosting (1996) Dark Horse Comics success story (1997) Single Link browsing (1997) Comments in db? (1997)