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:

Emailer 1.01 bombs (1997) multi-paragraph fields (1997) Merging databases (1997) Emailer (WebCat2) (1997) Date Question (2002) Generating unique SKU from [cart] - FIXED! (1997) Sort Order on a page search (1997) using cookies to prevent access (2000) Snippet for finding unused Header Fields in the Orders.db (2003) WebCatalog stalls (1998) Error Lob.db records error message not name (1997) form data submission gets truncated (1997) ConvertChars (Emailer file formats) (1998) HELP! Search finding too much! (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Setting up shop (1997) WebCatalog NT beta 18 problem (1997) Spawning Holdup? (2000) Q: old cart serial problem (2000) Caching [include] files ... (1997)