Re: Sorting Date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58746
interpreted = N
texte = 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/-- Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOil® AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://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:
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/-- Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOil® AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://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:
One .hdr, multiple .db's? (2003)
[WriteFile] problems (1997)
Need help with emailer- 2 issues (1997)
Re:[off] Promotions Co? (1997)
Random Links (2004)
Reversed words (1997)
Opinion: [input] should be called [output] ... (1997)
Another issue with [Date format] (1998)
Make sure I understand this??? (1997)
AD Error Msg (1997)
HTML Editors (1997)
I try hard to think positively (1998)
BGcolor (1997)
Database Strategy - more... (1998)
Dynamic Lists (2005)
Email within tmpl ? (1997)
unable to launch acgi in WebCat (1997)
[addlineitems] (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
WebDNA module - Automated database archiving (1997)