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:

Upgrade to wsV (2004) Re:PCS Customer submissions ? (1997) Searching multiple fields from one form field (1997) problem: mail changed (1997) Fwd: Handling Charges (1999) Format of Required fields error message (1997) Generating Report Totals (1997) Cart Number sequence (1997) [WebDNA] What is faster ? (2013) [!] not working? (1999) I give up!! (1997) Creditcard verification with WebCat (1998) Buying sans cart (1997) Append error (2002) Practice runs ? (1997) WebCat on Alpha? (1997) [WebDNA] 30 Minute Cookies (2016) The & Problem (1998) Email notification to one of multiple vendors ? (1997) Document Contains No Data! (1997)