Sorting by type=date

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23912
interpreted = N
texte = Hi folks,I am trying to display my results sorted by date. I am first searching and finding out what categories I have links in, then cycle through and display a total number of links within each category. I then have a link to display all of the links within the selected category.Following is the snippet I am using (without the first search). The code below works as far as dsiplaying the links, they are just not sorted the way I would like (by date).If it matters (I have a feeling this is where the problem is) the dates are stored in the database in mm/dd/yyyy format. These dates were exported from another database program. Do I have to change the way the date is stored to yyyy/mm/dd in order for this to work?------[search db=^databases/links.db&eqCategoryData=[index]]   [showif [index]=1]Business Links[/showif] [showif [index]=1]Organization[/showif] ------ The above seems to work the same with or without the '&Datetype-date' piece.If I need to convert the date information to yyyy/mm/dd format, does anyone have a way to do this (other than manually re-typing the data). Is it possible to maybe use the replace command somehow? Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting by type=date (webcat 1999)
  2. Re: Sorting by type=date (Kenneth Grome 1999)
  3. Sorting by type=date (webcat 1999)
Hi folks,I am trying to display my results sorted by date. I am first searching and finding out what categories I have links in, then cycle through and display a total number of links within each category. I then have a link to display all of the links within the selected category.Following is the snippet I am using (without the first search). The code below works as far as dsiplaying the links, they are just not sorted the way I would like (by date).If it matters (I have a feeling this is where the problem is) the dates are stored in the database in mm/dd/yyyy format. These dates were exported from another database program. Do I have to change the way the date is stored to yyyy/mm/dd in order for this to work?------[search db=^databases/links.db&eqCategoryData=[index]]   [showif [index]=1]Business Links[/showif] [showif [index]=1]Organization[/showif] ------ The above seems to work the same with or without the '&Datetype-date' piece.If I need to convert the date information to yyyy/mm/dd format, does anyone have a way to do this (other than manually re-typing the data). Is it possible to maybe use the replace command somehow? 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:

[WebDNA] error: Permission deny when updating a database (2016) Next X hits (1996) WC2b12: Yes, Formulas.db is for real (1997) Reindexing a db with duplicate numbers... (1999) using showpage and showcart commands (1996) Comments in db? (1997) Duplicate Cart Problem in Netscape (2000) search form problem.. (1997) WCf2 and nested tags (1997) No Wanna Duppys (1998) virtual virtual hosted store.... (1998) Nested vs conditional (1997) Summing fields (1997) WebDNA Solutions ... sorry! (1997) [WebDNA] Stupid question about CentOS v4 and WebDNA v6 (2008) [OT] SQL and Crackers (2000) [WebDNA] annoucement - WebDNA 8.0.2 (2015) flash-wc (2000) [OT] Mac OSX hardware test software (2004) How To question on setting up downloads (1997)