Re: Dates - Search and Sorting

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23036
interpreted = N
texte = >Speaking of date sorting issues, I am having trouble myself. I am trying to >set up a template so that it only displays an article between a StartDate >and EndDate. >My search is: >[search >db=articles.db&eqSectiondata=[Section]>EndDatedata=[date]&EndDatetype=date ><StartDatedata=[date]&StartDatesort=1&StartDatesdir=as&StartDatetype=date]This doesn't work because you made a simple syntax error. WebCat doesn't have gt and lt as comparison operators, it has gr and ls. This is in the HTML docs at:WebCatalog/WebCatReference/SearchComparisons.htmlSincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  2. Re: Dates - Search and Sorting (Mike_Davis 1999)
  3. Re: Dates - Search and Sorting (PCS Technical Support 1999)
  4. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  5. Re: Dates - Search and Sorting (RH Prouty 1999)
  6. Re: Dates - Search and Sorting (RH Prouty 1999)
  7. Re: Dates - Search and Sorting (RH Prouty 1999)
  8. Re: Dates - Search and Sorting (Howard Wolosky 1999)
  9. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  10. Re: Dates - Search and Sorting (RH Prouty 1999)
  11. Re: Dates - Search and Sorting (RH Prouty 1999)
  12. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  13. Dates - Search and Sorting (RH Prouty 1999)
>Speaking of date sorting issues, I am having trouble myself. I am trying to >set up a template so that it only displays an article between a StartDate >and EndDate. >My search is: >[search >db=articles.db&eqSectiondata=[Section]>EndDatedata=[date]&EndDatetype=date ><StartDatedata=[date]&StartDatesort=1&StartDatesdir=as&StartDatetype=date]This doesn't work because you made a simple syntax error. WebCat doesn't have gt and lt as comparison operators, it has gr and ls. This is in the HTML docs at:WebCatalog/WebCatReference/SearchComparisons.htmlSincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

one item in several different categories? (2000) [SearchString] usage (1997) remove.htm from result (2005) [isfile] ? (1997) What am I missing (1997) newcart (1997) Sample Tearoom Search Error (1997) autosensing lanague selection (1997) Every other record deleted (2005) Wireless WebDNA available today! (2000) Multiple edits/replacementsd to db. Possible? (1997) show all problem (1997) Location of Browser Info.txt file (1997) WebDelivery downloads alias, not original ? (1996) Professional WebDNA Hosting Solutions (2005) User can't change a password (2002) [WebDNA] [OT] Merchant Provider Suggestions (2008) shipCost (1998) SQL db type (2006) [WebDNA] Cookie Enabled/Disabled (2013)