Re: Sorting Date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58750
interpreted = N
texte = sneaky.... so you just combine them then? I like that, less code, I guess where I have gone wrong is not supplying the order in which the search items are getting sorted ie postDatesort=1. Thanks for all your help. Alan Matthew A Perosi wrote: > or better yet give this a try: > dePOSTDATEsort=1 > > 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:
sneaky.... so you just combine them then? I like that, less code, I guess where I have gone wrong is not supplying the order in which the search items are getting sorted ie postDatesort=1. Thanks for all your help. Alan Matthew A Perosi wrote: > or better yet give this a try: > dePOSTDATEsort=1 > > 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:
encrypt (2000)
Announce: Bug fix talk list (1999)
OT: Limit on # of Pulldown entries (1997)
Links and Carriage Returns, Oh my! (2000)
RequiredFields notes ... (1997)
Webcatalog error, Plug-in for Webstar (1996)
Help! Odd, irreproducible happenings. (1998)
[WebDNA] v7 problem? (2012)
Text data with spaces in them... (1997)
[WebDNA] WebDNA as cgi app (was WebSite Examples) (2008)
[WebDNA] Cloud hosting and local development (2019)
protect tag on NT IIS (1997)
[Price] (1997)
Emailer on NT not working. (1999)
Webcat 4.0 and security (2000)
Force a search at the default.tmpl page? (1997)
Emailer Set Up (1997)
WebCat2 beta 11 - new prefs ... (1997)
[WebDNA] WebDNA install on Redhat 4 64 bit? (2008)
Appending problem (still) on Solaris (2000)