Re: Sorting Date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58748
interpreted = N
texte = or better yet give this a try:dePOSTDATEsort=1Nitai @ 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/
Associated Messages, from the most recent to the oldest:
or better yet give this a try:dePOSTDATEsort=1Nitai @ 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/
Matthew A Perosi
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:
WCS Newbie question (1997)
Serving images from databases (1998)
Some Advise needed (1997)
A Couple Photos from the SmithMicro Booth at MacWorld (2000)
[WebDNA] Cookie behavior (2010)
[OT] Bad Hard Drive? (2003)
WCS Newbie question (1997)
shoppingcart reload qty (1997)
Shownext! (1998)
[WebDNA] Command to quit/restart (2012)
header (2017)
Does [Sendmail] create html? (2002)
Signal Raised Error (1997)
Interactive Docs (2007)
Using the sendmail command on CGate Pro (Unix) (2000)
taxTotal, grandTotal (1997)
To use GREP to boldface text (2003)
Kill the webcat process (2000)
[WebDNA] [OT] potential cheap WebDNA server? (2009)
Shopping problems with 2.1b3 acgi (1997)