Date summarising

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62684
interpreted = N
texte = Hi My brain is having a bit of a slow day and I'm wondering if someone could help out a little. I have a news.db that stores the usual stuff like ID, HEADLINE, STORY, DATE, PICTURE etc. My problem is that the client wants to see the results summarised like the following... May 2005 Headline 1 Headline 2 April 2005 Headline 3 Feb 2005 Headline 4 Headline 5 Headline 6 Etc etc, hopefully you get the idea. The dates are stored as dd/mm/yyyy in the db. I just can't get my head round how to summarise the date variable into blocks of months, if that makes sense. Any help or pointers much appreciated. Thanks ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.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:

    
  1. Re: Date summarising ( Joe D'Andrea 2005)
  2. Re: Date summarising ( Steve Craig 2005)
  3. Re: Date summarising ( John Peacock 2005)
  4. Date summarising ( Steve Craig 2005)
Hi My brain is having a bit of a slow day and I'm wondering if someone could help out a little. I have a news.db that stores the usual stuff like ID, HEADLINE, STORY, DATE, PICTURE etc. My problem is that the client wants to see the results summarised like the following... May 2005 Headline 1 Headline 2 April 2005 Headline 3 Feb 2005 Headline 4 Headline 5 Headline 6 Etc etc, hopefully you get the idea. The dates are stored as dd/mm/yyyy in the db. I just can't get my head round how to summarise the date variable into blocks of months, if that makes sense. Any help or pointers much appreciated. Thanks ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.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/ Steve Craig

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:

[isfile] ? (1997) [showif]/[hideif] question (1997) [WebDNA] [WSC] WebDNA Development Summit (2014) Re:Signal Raised (1997) [quantity] - spoke too soon (1997) Not really WebCat (1997) Stumpted Again (1997) multiple databases (1997) Help! WebCat2 bug (1997) Bug in random search - MacOS v4.5 plugin ... (2002) Image editing in browser (2005) ShowNext (1997) [Sum] function? (1997) WebCatalog on Linux (2000) Problems appending to database (1997) Great product and great job ! (1997) More than one db with the same namn (was: WC2f3) (1997) NT 2.1b10 (1998) SKU lookup (1997) New Webcatalog for Mac (1997)