Re: searching by part of the date information

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23724
interpreted = N
texte = >>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]] > >Looks like you're missing at least an '&' and maybe some more syntax: >[Search db=../~dev/databases/today_news.db&eqDATEdata=[date $d >%b]&DATEType=date]]Thanks, I worked on it some more last night and got it working. In addition to what you pointed out, I think there was an issue with my date formast, but it is working now!>>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. > >All database paths are relative to your template. If you need 'global' >databases that are accessed by multiple subdomains, you can put them up in >the WebCatalog/Global/ folder, and access them with [search >db=^databases/today_news.db], which looks in /Globals/databasesThe files only need to be accessed by one site, I might end up putting them in the globals directory. I would be nice to figure this out though. It might be an with how I have FireSite configured. Thanks! 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)
>>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]] > >Looks like you're missing at least an '&' and maybe some more syntax: >[Search db=../~dev/databases/today_news.db&eqDATEdata=[date $d >%b]&DATEType=date]]Thanks, I worked on it some more last night and got it working. In addition to what you pointed out, I think there was an issue with my date formast, but it is working now!>>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. > >All database paths are relative to your template. If you need 'global' >databases that are accessed by multiple subdomains, you can put them up in >the WebCatalog/Global/ folder, and access them with [search >db=^databases/today_news.db], which looks in /Globals/databasesThe files only need to be accessed by one site, I might end up putting them in the globals directory. I would be nice to figure this out though. It might be an with how I have FireSite configured. Thanks! 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:

absolute paths for databases? (1997) Problems with WebCat 4.01 (2000) Freeze (2003) Webcatalog and IIS4b2 (1997) Webcatalog, Webstar and Crasharama (1999) using showpage and showcart commands (1996) Shopping cart problem (2003) Re:Has this happened to you? (1997) [WebDNA] WebDNA code displaying on page (2012) TRAINING videos - Prove IT. (1998) [WebDNA] Emailer breaking format (2015) WebCatalog stalls (1998) Word search (1997) Problem with Formulas.db (1998) WC Database Format (1997) [LOOKUP] (1997) credit card authorization question (1997) weird G3 happenings (1998) Special characters & [sendmail] (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)