Re: searching by part of the date information

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23719
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]]>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/databasesTechnical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ 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]]>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/databasesTechnical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

Sort Order on a page search (1997) A Couple Photos from the SmithMicro Booth at MacWorld (2000) Need relative path explanation (1997) 2nd WebCatalog2 Feature Request (1996) [OT] Quick Java Help (2004) Database Erroe (2000) NT error logs (1997) NEW INFO: I'm stuck: Can't open order file.Ignoring[OrderFile] context (2000) question... no field names? (2002) Me know logical no need (2002) WebCat b13 CGI -shownext- (1997) Signal Raised (1997) Providing hard copy of database to client (1997) Major bug report on rootbeer (1997) WCS Newbie question (1997) Another Large Database Questions (1997) Surprise x and y post args (1998) How far do [showif]s go? (1997) [isfile] ? (1997) Exclamation point (1997)