Re: sorting by date

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23379
interpreted = N
texte = >I need to show a search sorted by date. > >the date in the database is 11/11/98 etc. > >I'm getting a sort on the first digits first. >not on the entire date. >11/01/98 >11/12/98 >12/13/98 > >etc. > >Do I need to convert this date structure to something else first in order to >do this right???Yes, the dateformat pref must match the date format in your db fields.Sincerely, Ken Grome Associated Messages, from the most recent to the oldest:

    
  1. Re: sorting by date Y2K mix up (Brian B. Burton 2000)
  2. Re: sorting by date Y2K mix up (Kenneth Grome 2000)
  3. sorting by date Y2K mix up (Laurent Pladys 2000)
  4. Re: sorting by date (PCS Technical Support 1999)
  5. Re: sorting by date (Kenneth Grome 1999)
  6. Re: sorting by date (Kenneth Grome 1999)
  7. sorting by date (Richard 1999)
  8. Re: Sorting by date (Trevor Crist 1997)
  9. Re: Sorting by date (Trevor Crist 1997)
  10. Re: Sorting by date (Trevor Crist 1997)
  11. Re: Sorting by date (marty@artwerks.com (Marty Schmid) 1997)
  12. Re: Sorting by date (Grant Hulbert 1997)
  13. Re: Sorting by date (Marty Schmid 1997)
  14. Sorting by date (Trevor Crist 1997)
  15. Re: Sorting by date (Grant Hulbert 1997)
>I need to show a search sorted by date. > >the date in the database is 11/11/98 etc. > >I'm getting a sort on the first digits first. >not on the entire date. >11/01/98 >11/12/98 >12/13/98 > >etc. > >Do I need to convert this date structure to something else first in order to >do this right???Yes, the dateformat pref must match the date format in your db fields.Sincerely, Ken Grome 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:

Whats going on with my SERIAL NUMBER??? (1998) Re2: frames & carts (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Summary search -- speed (1997) math on date? (1997) back button loses cart (2000) [cart] not being interpreted inside [founditems] (1997) textarea inputs and returns - sending HTML email (1999) Database Field Additions (2000) Problems with Price field (1997) html being uncooperative (2000) Okay, I give up... (1999) I'm new be kind (1997) New Plug-in and Type 11 errors (1997) A Global Variable (1997) WebCatalog and Macromedia Flash (1998) RE: Emailer Set Up (1997) How do I get Google to crawl a WebCat site? (2003) [quantity] within formulas (1997) Deleting with contexts (2001)