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:
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)