Re: Sorting Date

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58753
interpreted = N
texte = I think I will have a play about once I have our new site live ... I still have loads to do and deadlines are looming ;-) Thanks Again Alan Nitai @ ComputerOil wrote: > When you store dates as numbers you can do a lot of fancy stuff with > it:-) No, seriously imagine selling your code to someone who hosts > many websites with WebDNA and they DON'T use Sandboxes. This leaves > you with many different settings or wishes from customers how they > would like to show dates. European, USA Format etc. > > When you store dates as number you just wrap the format tag around > them, that's it. Also doing calculations is very easy. Stuff like > that.... > > Check the archives, many of us have given very good reasons to store > dates as numbers. :-) > > Alan White wrote: > >> Bingo... that sorted it... >> >> Can I ask why you never store dates as dates? I don't have the >> requirement for anything other that about a months worth of news >> posts so this is why I have done it like this. >> >> Thanks Nitai >> >> Alan >> >> Nitai @ ComputerOil wrote: >> >>> I am never storing dates as dates, but maybe it helps if you use >>> postDatessort=1 within your search? >>> >>> Alan White wrote: >>> >>>> Hi Everyone... (long time no post) >>>> >>>> I am trying to do a very basic news section on our new site, I am >>>> having problems when it comes to sorting the date and I can't see >>>> why. I have the date set in webdna prefs as dd/mm/yyyy and the >>>> dates are entered as 07/07/2004 etc.. you can see the sort order >>>> here http://css.hanon-shop.com (in the latest news section) >>>> >>>> [search >>>> db=news.db&nenewsIDdatarq=find_all&postDatesdir=de&postDatetype=date] >>>> [founditems] >>>>

[postDate] | [newsTitle]

>>>>

[convertchars][newsItem][/convertchars]

>>>>

Go Now!

>>>>
>>>> [/founditems] >>>> [/search] >>>> >>>> Hope someone can help (brain hasn't kickin in yet or something...) >>>> >>>> Regards >>>> -Alan >>>> >>>> >>>> >>>> ------------------------------------------------------------- >>>> 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 >>>> >>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >>> >>> >>> >> >> >> ------------------------------------------------------------- >> 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 >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting Date ( Alan White 2004)
  2. Re: Sorting Date ( "Nitai @ ComputerOil" 2004)
  3. Re: Sorting Date ( Alan White 2004)
  4. Re: Sorting Date ( "Erol Guneri" 2004)
  5. Re: Sorting Date ( Matthew A Perosi 2004)
  6. Re: Sorting Date ( Alan White 2004)
  7. Re: Sorting Date ( "Nitai @ ComputerOil" 2004)
  8. Sorting Date ( Alan White 2004)
  9. Re: Sorting Dates in a search (Nico 2000)
  10. Re: Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  11. Re: Crazy dates (was: Re: sorting dates) (Martin Bech 1999)
  12. Re: Crazy dates (was: Re: sorting dates) (John Hill 1999)
  13. Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  14. Re: sorting dates (Kenneth Grome 1999)
  15. Re: sorting dates (bradeisenberg@iname.com 1999)
  16. Re: sorting dates (Bill Heissenbuttel 1999)
  17. Re: sorting dates (Bill Heissenbuttel 1999)
  18. Re: sorting dates (PCS Technical Support 1999)
  19. Re: sorting dates (bradeisenberg@iname.com 1999)
  20. Re: sorting dates (PCS Technical Support 1999)
I think I will have a play about once I have our new site live ... I still have loads to do and deadlines are looming ;-) Thanks Again Alan Nitai @ ComputerOil wrote: > When you store dates as numbers you can do a lot of fancy stuff with > it:-) No, seriously imagine selling your code to someone who hosts > many websites with WebDNA and they DON'T use Sandboxes. This leaves > you with many different settings or wishes from customers how they > would like to show dates. European, USA Format etc. > > When you store dates as number you just wrap the format tag around > them, that's it. Also doing calculations is very easy. Stuff like > that.... > > Check the archives, many of us have given very good reasons to store > dates as numbers. :-) > > Alan White wrote: > >> Bingo... that sorted it... >> >> Can I ask why you never store dates as dates? I don't have the >> requirement for anything other that about a months worth of news >> posts so this is why I have done it like this. >> >> Thanks Nitai >> >> Alan >> >> Nitai @ ComputerOil wrote: >> >>> I am never storing dates as dates, but maybe it helps if you use >>> postDatessort=1 within your search? >>> >>> Alan White wrote: >>> >>>> Hi Everyone... (long time no post) >>>> >>>> I am trying to do a very basic news section on our new site, I am >>>> having problems when it comes to sorting the date and I can't see >>>> why. I have the date set in webdna prefs as dd/mm/yyyy and the >>>> dates are entered as 07/07/2004 etc.. you can see the sort order >>>> here http://css.hanon-shop.com (in the latest news section) >>>> >>>> [search >>>> db=news.db&nenewsIDdatarq=find_all&postDatesdir=de&postDatetype=date] >>>> [founditems] >>>>

[postDate] | [newsTitle]

>>>>

[convertchars][newsItem][/convertchars]

>>>>

Go Now!

>>>>
>>>> [/founditems] >>>> [/search] >>>> >>>> Hope someone can help (brain hasn't kickin in yet or something...) >>>> >>>> Regards >>>> -Alan >>>> >>>> >>>> >>>> ------------------------------------------------------------- >>>> 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 >>>> >>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >>> >>> >>> >> >> >> ------------------------------------------------------------- >> 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 >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Alan White

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:

record locking (2000) back button problem (1999) NetForms for email (1998) How to Sort Summ data ? (1997) Zipcodes (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCat templates for TyphoonPro admin (1999) Server crashes and triggers . . . are they linked? (2001) WebCat2final1 crashes (1997) Separate SSL Server (1997) mass mailing (1998) WebCat2b15MacPlugin - showing [math] (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) Attn: Bug in GeneralStore example b15 (1997) unable to launch acgi in WebCat (1997) YACBQ.....(Yet another checkbox question) (2000) Associative lookup style? + bit more (1997) frames & carts (1997) [format xs] freeze (1997) Another StoreBuilder Question (2003)