Re: sorting by date

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23378
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:

How long does a cart last? (2002) WebCatalog dying in WebTen Revisited (1998) taxrate - off by 1 cent (1997) [ot] Bluetooth Phones That Allow SSH (2004) WebCat2b15MacPlugin - showing [math] (1997) database paths/names, and a typo (1997) [append] vs. [appendfile] delta + question? (1997) [WebDNA] Search comparisons in 8.6.1 (2019) .html files and Apache AuthUserFile setting (2003) [SearchString] problem with [search] context (1997) Server crash (1997) protect tag on NT (1997) WebCatalog2 Feature Feedback (1996) WebCat2b15MacPlugin - [protect] (1997) Not really WebCat (1997) oops private message leaked into talk list (1997) [referrer] tag (1997) $flushcache causes crash (2000) Support ?? (1997) Include a big block of text (1997)