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:
>>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)