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 inthe WebCatalog/Global/ folder, and access them with [searchdb=^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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 inthe WebCatalog/Global/ folder, and access them with [searchdb=^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 | Typhoon619/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)