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:

Document Contains No Data! (1997) Sub Totals (2000) PixelPipe for Windows? (2003) Problems appending to database (1997) Permissions (2000) FEA REQ: One .hdr, multiple .db's (2003) Size limit for tmpl editor ? (1997) Server slowing down. (1997) building / customizing stores (2000) Multiple Stores and WebCatalog Prefs (1997) Grant, please help me ... (1997) image magick (2003) Lookup Notfound (1998) WebCatalog for guestbook ? (1997) Problem getting shipping to calculate (2003) Multiple prices (1997) WCS Newbie question (1997) Banner DNA (1997) Lambada for Macintosh is Here! (1996) Whats going on with my SERIAL NUMBER??? (1998)