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:
Fedora Core 2 - SOLVED (2005)
Share cost of training videos! (1998)
MasterCounter and capitalization (1997)
Secure Server (1999)
Using Plug-In while running 1.6.1 (1997)
[format xs] freeze (1997)
newbie Q: [cart] documentation (1999)
More Applescript (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Change to 5.0 per website licensing (2003)
WebCat2 - [format thousands] (1997)
Generating Report Totals (1997)
Multiple fields on 1 input (1997)
still having search problem, please help :) (2004)
Bug Report, maybe (1997)
Associative lookup style? + bit more (1997)
TCPConnect (2002)
2.0Beta Command Ref (can't find this instruction) (1997)
WebCat and Personal Web Server (1998)
OFF TOPIC: Sendmail problem (2003)