What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

I'm having trouble using [url][interpret][math] together in lookup (1997) Question about replacing words (1998) [TaxableTotal] - not working with AOL and IE (1997) Not really WebCat - need HTML Grider (1997) Bug Report, maybe (1997) Separate SSL Server (1997) Country & Ship-to address & other fields ? (1997) Version f1 status (1997) Help- WebCat won't parse pages! (2002) how to check for no value while using [URL] to prevent cr (1999) Problems reading files created by WC (1997) Database Program (1997) [OT] Indexing of dynamic web sites (2003) Multiple Users.db Possible? (1997) Problems setting MIME Headers (1998) Search Question (2003) NT IIS number of files limit (2003) off topic - dna snipets (1997) Cart # Starting at 1000 (2000) much help needed NEWBIE alert (2000)