Re: Sorting Date

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58751
interpreted = N
texte = 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/ -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil® AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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)
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/ -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil® AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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/ "Nitai @ ComputerOil"

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:

Quickie question on the email templates (1997) WebCatalog for guestbook ? (1997) WebCatalog can't find database (1997) your mail (2000) 2.0Beta Command Ref (can't find this instruction) (1997) Stinkin' [Referrer] (1998) Causes Site to Crash... (2000) SetHeader (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) E-mail Attachments (1997) WC1.6 to WC2 date formatting (1997) Using [redirect] in the middle of a page? (1999) Question about replacing words (1998) Trouble with formula.db + more explanation (1997) Associative lookup style? + bit more (1997) WCS Newbie question (1997) Major Security Hole (1998) Accepting credit cards (1997) [addlineitem] (1999) [WebDNA] File permissions on Windows? (2010)