Re: Sorting Date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58753
interpreted = N
texte = I think I will have a play about once I have our new site live ... I still have loads to do and deadlines are looming ;-)Thanks AgainAlanNitai @ ComputerOil wrote:> 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/>>>-------------------------------------------------------------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 think I will have a play about once I have our new site live ... I still have loads to do and deadlines are looming ;-)Thanks AgainAlanNitai @ ComputerOil wrote:> 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/>>>-------------------------------------------------------------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:
record locking (2000)
back button problem (1999)
NetForms for email (1998)
How to Sort Summ data ? (1997)
Zipcodes (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebCat templates for TyphoonPro admin (1999)
Server crashes and triggers . . . are they linked? (2001)
WebCat2final1 crashes (1997)
Separate SSL Server (1997)
mass mailing (1998)
WebCat2b15MacPlugin - showing [math] (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Attn: Bug in GeneralStore example b15 (1997)
unable to launch acgi in WebCat (1997)
YACBQ.....(Yet another checkbox question) (2000)
Associative lookup style? + bit more (1997)
frames & carts (1997)
[format xs] freeze (1997)
Another StoreBuilder Question (2003)