Re: Sorting by date

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11374
interpreted = N
texte = Trevor I havn't been following your troubles closely so this may not help but here is a snippet of the code I use in my event calendar's Search.tmpl. I use two fields (int3 for start date and int4 for ending date). The user enters in the starting and ending dates of their search and the database returns all relevent records and sorts them in ascending order of ending dates (int4) - so that the events ending sooner are at the top of the list.
ie. 1/27/1997
I'm currently running 2.0b15 and my date preferences are set to %m/%d/%YHope this helps. -marty ____________________________________ | Marty Schmid | | -Artwerks- | | Design/Advertising/Web Publishing | | | | T. 619.274.5029 | | F. 619.274.5656 | | e-mail: marty@artwerks.com | |____________________________________| 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)
Trevor I havn't been following your troubles closely so this may not help but here is a snippet of the code I use in my event calendar's Search.tmpl. I use two fields (int3 for start date and int4 for ending date). The user enters in the starting and ending dates of their search and the database returns all relevent records and sorts them in ascending order of ending dates (int4) - so that the events ending sooner are at the top of the list. [date]> ie. 1/27/1997
I'm currently running 2.0b15 and my date preferences are set to %m/%d/%YHope this helps. -marty ____________________________________ | Marty Schmid | | -Artwerks- | | Design/Advertising/Web Publishing | | | | T. 619.274.5029 | | F. 619.274.5656 | | e-mail: marty@artwerks.com | |____________________________________| Marty Schmid

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:

Problems with totals (1997) convert characters (2003) Lambada for Macintosh is Here! (1996) File Format Validation (2005) Running _every_ page through WebCat ? (1997) problems with 2 tags (1997) Search in 2 or more catalogs (1997) Payment Processors (2005) Online reference (1997) Admin Edit prob. (1997) Simple form with picture upload (2005) BBedit Syntax coloring.... (2000) random sorting broken (was Re[2]: php vs WebCatalog) (2000) ShowIf Question (1998) America Online Issues (1998) [OT] DOD again (2003) exclusive db lock with webcat-3 ? (2000) Re2: AAgghh!! Help, please. SSL strikes again. (1997) WebCatalog2 Feature Feedback (1996) WebCat2 - Getting to the browser's username/password data (1997)