searching by part of the date information

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23691
interpreted = N
texte = Hi,I am working on a 'today' database and my data currently has the date information in one of two formats, either 01-JAN or 01/01 (day / month) (I have tried both).I have tried [Search db=../~dev/databases/today_news.db&eqDATEdata=[date %m]Type=date]] and [Search db=../~dev/databases/today_news.db&eqDATEdata=[date $d %b]Type=date]] and [Search db=../~dev/databases/today_news.db&eqDATEdata=[date $d/%b]Type=date]] To no avail. I only need to match the 1-31 date and the month as the years will of course not match as they are in the past.What am I doing wrong?Also I seem to be having some troulbe getting the database to load. My Webcatalog folder is in the WS root, then my test site is in a folder called /`dev/ t work with my multi-homing software (FireSite). I am then wanting to put all my databases in a sub folder named databases. It appears the only way I can load the database is to include the site folder name as well. I would prefer to find a way around this to make the code more portable, if possible.Thank you for any suggestions. Associated Messages, from the most recent to the oldest:

    
  1. Re: searching by part of the date information (webcat 1999)
  2. Re: searching by part of the date information (PCS Technical Support 1999)
  3. searching by part of the date information (webcat 1999)
Hi,I am working on a 'today' database and my data currently has the date information in one of two formats, either 01-JAN or 01/01 (day / month) (I have tried both).I have tried [Search db=../~dev/databases/today_news.db&eqDATEdata=[date %m]Type=date]] and [Search db=../~dev/databases/today_news.db&eqDATEdata=[date $d %b]Type=date]] and [Search db=../~dev/databases/today_news.db&eqDATEdata=[date $d/%b]Type=date]] To no avail. I only need to match the 1-31 date and the month as the years will of course not match as they are in the past.What am I doing wrong?Also I seem to be having some troulbe getting the database to load. My Webcatalog folder is in the WS root, then my test site is in a folder called /`dev/ t work with my multi-homing software (FireSite). I am then wanting to put all my databases in a sub folder named databases. It appears the only way I can load the database is to include the site folder name as well. I would prefer to find a way around this to make the code more portable, if possible.Thank you for any suggestions. webcat

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 (1997) Date fun with MySQL (2004) Multiple prices (1997) Re:WebCatalog f2 Installation (1997) Previous and Next Solution (2004) Copyright ? (1997) Email notification to one of multiple vendors ? (1997) can WC render sites out? (1997) WebSite and *NO* Authentication Dialog Box!!? (1998) Locking up with WebCatalog... (1997) Replace with Producteditor.tpl (2000) RE: WebCat and image maps (1997) [WebDNA] paypal (2009) Micro-managing External Links (2006) REALLY need a hand (1999) Sort Order on a page search (1997) WebDNA Solutions ... sorry! (1997) Erotic Sites (1997) shipcost (1997) extending webDNA (2004)