Re: Date sorting

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26482
interpreted = N
texte = >How do I sort the results descending by date based on a field where >the date has been recorded as day.month.year (01.01.2000)?First, change the name of your 'date' field to something other than 'date' -- such as 'itemDate' for example. You should never use webdna tags names as db field names.Then, assuming your date preferences match your date format, just add &itemDateType=date to your search parameters:&db=../data/classifieds.db &cart=[cart] &neUniqueIddata=0 &eqcountrydatarq=n &neUniqueIddata=0 &eqsexdatarq=female &has_photosort=1 &has_photosdir=de &itemDatesort=2 &itemDatesdir=de &itemDateType=date <-- add this parameter &searchtitle=[url]female[/url] &max=10 &language_id=[language_id] &country_id=[country_id]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Date sorting ( charles kline 2004)
  2. Re: Date sorting ( Tim Robinson 2004)
  3. Re: Date sorting ( Jesse Proudman 2004)
  4. Date sorting ( charles kline 2004)
  5. Re: Date sorting (Kenneth Grome 2000)
  6. Date sorting (Bjørn Are Solstad 2000)
  7. Re: Goofy Date Sorting (Michael Winston 1998)
  8. Re: Goofy Date Sorting (Peter Ostry 1998)
  9. Goofy Date Sorting (The Mooseman 1998)
  10. Re: date sorting and 'template (Grant Hulbert 1997)
  11. date sorting and 'template (Dan Keldsen 1997)
  12. Re: Date Sorting (Kenneth Grome 1997)
  13. Date Sorting (Tim Rignold 1997)
  14. Re: Date sorting (Kenneth Grome 1997)
  15. Re: Date sorting (Britt T. 1997)
  16. Date sorting (Britt T. 1997)
  17. Re: Date Sorting (Grant Hulbert 1997)
  18. Re: Date Sorting (Glenn Davis 1997)
  19. Re: Date Sorting (Grant Hulbert 1997)
  20. Date Sorting (Glenn Davis 1997)
>How do I sort the results descending by date based on a field where >the date has been recorded as day.month.year (01.01.2000)?First, change the name of your 'date' field to something other than 'date' -- such as 'itemDate' for example. You should never use webdna tags names as db field names.Then, assuming your date preferences match your date format, just add &itemDateType=date to your search parameters:&db=../data/classifieds.db &cart=[cart] &neUniqueIddata=0 &eqcountrydatarq=n &neUniqueIddata=0 &eqsexdatarq=female &has_photosort=1 &has_photosdir=de &itemDatesort=2 &itemDatesdir=de &itemDateType=date <-- add this parameter &searchtitle=[url]female[/url] &max=10 &language_id=[language_id] &country_id=[country_id]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to 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:

Multiple serial numbers (1997) [defined]ish (1997) Help name our technology! (1997) adding up in a db (1997) carriage returns in data (1997) WebMerchant 1.6 and SHTML (1997) Out of the woodwork (2007) RE: Web Logs (1998) Subject: Any Newsletters out there (1998) WebCat2 - Getting to the browser's username/password data (1997) [UPPERCASE] (1997) IE4.5 bug FYI (1999) WebCat2b12 forgets serial # (1997) PSC recommends what date format yr 2000??? (1997) Escape the Root! (2002) [WebDNA] WebDNA 7 (2011) WebCat2b15MacPlugin - showing [math] (1997) How To question on setting up downloads (1997) Upgrading old WebCat Database Files (1997) setting values (1998)