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:

Mailer (2006) Search/sort in URL Was: GuestBook example (1997) Looking for 24x7 ISP for WebCatalog (1998) notification solutions (1997) Credit Card Verification.... (1998) Sorry, WebDNA Server Not Running! (2005) webcat NT (1998) WebCatalog on Windows 98 (2000) Sorting a Search... (1998) [input] [/input] (1997) Search Question (2000) Dubble Sku's in a Database (1999) why is this line in GeneralStore? (1998) &fieldsdir=ra truely random?? (2000) why won't this work, please tell me??? (2001) WebCat B13 Mac CGI -- Frames question (1997) WCf2 and nested tags (1997) Web Catalog Instability (2000) Limiting user access to .tmpl files (1997) What is WebDNA (1997)