date sorting and 'template

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 14382
interpreted = N
texte = Well, I've tried searching the starnine archives and my own, and can't find anything that works for me. I'm trying to sort in descending order, the entries I've made in the whatsnew.db to make notification of new stuff on our site easier to deal with. It spits out the proper data, but refuses to sort - please tell me I missed a character somewhere! Hop down a few paragraphs to jump to the details of this puzzle.Also, the following URLs are acting strange - previous WebCat pages I've done are working fine, organized as: web*/wc/store/... (change WebCatalog to wc to make shorter URLs). This works fine, and I haven't had any problems with Welcome (Virtual hosting plug-in) and WebCat up until this point.If you try the URL below, it doesn't work. Suffix mapping and such is set up correctly, as other WebCat .tmpl files work fine. If I change the URL to www.delphigroup.com/WEB_SITE/whatsnew/index.tmpl - then it works fine.I'm beginning to use virtual hosting quite heavily, and I can't just shut it off at this point. I've read hints of problems with virtual hosting and WebCat, but couldn't trace back to any specifics... please enlighten me. You might also notice that the URL www.delphigroup.com/whatsnew/whatsnew.db lets you SEE the database - which shouldn't be possible.On to the sorting problem:template - www.delphigroup.com/whatsnew/index.tmpl:

What's New On The Delphi Site?

[Search db=whatsnew.db&geEntry_Datedata=[math]{[date]}-90[/math]&Entry_Datesort=1&Entry_Datetype=date&Entry_Datedir=de][FoundItems][showif [index]\2][/showif][hideif [index]\2][/hideif][/FoundItems]

Date	Description
[format days_to_date %B %d, %Y][math]{[Entry_Date]}[/math][/format]	[showif [URL_Empty]=F][/showif][description][showif [URL_Empty]=F][/showif]

[/Search]

---

[thisurl] - [date] / [time]db - www.delphigroup.com/whatsnew/whatsnew.db:Entry_Date,Description,URL,URL_Empty09/12/1997,The Delphi Group, Inc. today announced the release of its Knowledge Management Report,including the results of the first detailed survey into corporate perceptions of this rapidly emerging discipline.,/pressreleases/1997-PR/09121997-KMReport.html,F08/29/1997,The Delphi Group announced the Delphi Awards in Workflow, the only objective, market research-based set of industry honors recognizing companies with demonstratedsuperior performance in the production workflow applications arena.,/pressreleases/1997-PR/08291997WFAwards.html,F08/13/1997,The schedule and information for our full Fall 1997 Seminar line-up is now online - get up to speed on Intranets, Document Management, Knowledge Management, Workflow, Simulation and Modeling, and a host of other technologies!,,T---Dan Keldsen - djk@delphigroup.comDirector, I.S./Webmaster - webmaster@delphigroup.comDelphi Consulting Group, Inc. - http://www.delphigroup.com/100 City Hall Plaza - ph: 617-247-1511Boston, MA 02108-2106 - fax:617-247-4957 Associated Messages, from the most recent to the oldest:

date sorting and 'template (Dan Keldsen 1997)

Well, I've tried searching the starnine archives and my own, and can't find anything that works for me. I'm trying to sort in descending order, the entries I've made in the whatsnew.db to make notification of new stuff on our site easier to deal with. It spits out the proper data, but refuses to sort - please tell me I missed a character somewhere! Hop down a few paragraphs to jump to the details of this puzzle.Also, the following URLs are acting strange - previous WebCat pages I've done are working fine, organized as: web*/wc/store/... (change WebCatalog to wc to make shorter URLs). This works fine, and I haven't had any problems with Welcome (Virtual hosting plug-in) and WebCat up until this point.If you try the URL below, it doesn't work. Suffix mapping and such is set up correctly, as other WebCat .tmpl files work fine. If I change the URL to www.delphigroup.com/WEB_SITE/whatsnew/index.tmpl - then it works fine.I'm beginning to use virtual hosting quite heavily, and I can't just shut it off at this point. I've read hints of problems with virtual hosting and WebCat, but couldn't trace back to any specifics... please enlighten me. You might also notice that the URL www.delphigroup.com/whatsnew/whatsnew.db lets you SEE the database - which shouldn't be possible.On to the sorting problem:template - www.delphigroup.com/whatsnew/index.tmpl:

What's New On The Delphi Site?

[Search db=whatsnew.db&geEntry_Datedata=[math]{[date]}-90[/math]&Entry_Datesort=1&Entry_Datetype=date&Entry_Datedir=de][founditems][showif [index]\2][/showif][hideif [index]\2][/hideif][/FoundItems]

Date	Description
[format days_to_date %B %d, %Y][math]{[Entry_Date]}[/math][/format]	[showif [URL_Empty]=F][url]>[/showif][description][showif [URL_Empty]=F][/showif]

[/Search]

---

[thisurl] - [date] / [time]db - www.delphigroup.com/whatsnew/whatsnew.db:Entry_Date,Description,URL,URL_Empty09/12/1997,The Delphi Group, Inc. today announced the release of its Knowledge Management Report,including the results of the first detailed survey into corporate perceptions of this rapidly emerging discipline.,/pressreleases/1997-PR/09121997-KMReport.html,F08/29/1997,The Delphi Group announced the Delphi Awards in Workflow, the only objective, market research-based set of industry honors recognizing companies with demonstratedsuperior performance in the production workflow applications arena.,/pressreleases/1997-PR/08291997WFAwards.html,F08/13/1997,The schedule and information for our full Fall 1997 Seminar line-up is now online - get up to speed on Intranets, Document Management, Knowledge Management, Workflow, Simulation and Modeling, and a host of other technologies!,,T---Dan Keldsen - djk@delphigroup.comDirector, I.S./Webmaster - webmaster@delphigroup.comDelphi Consulting Group, Inc. - http://www.delphigroup.com/100 City Hall Plaza - ph: 617-247-1511Boston, MA 02108-2106 - fax:617-247-4957 Dan Keldsen

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:

WebCatalog2 Feature Feedback (1996) carriage returns in data (1997) emptying shopping carts and orders folder (2004) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Separate SSL Server (1997) Ruby on Rails (was Looping Search) (2006) select menus & database design (1998) Protecting webdelivery (1997) emailer w/F2 (1997) Search/sort in URL Was: GuestBook example (1997) RE: OK, here goes... (1997) Pop-up menu (1998) multi-paragraph fields (1997) F*** you (1998) RE: [redirect] w/o showing args? (1999) Pass a form (2003) page chokes on hideif when false and ignored (1998) Nesting FoundItem Context (1997) Speaking of... (1999) WebCat2final1 crashes (1997)