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:

Bug or syntax error on my part? (1997) Initiating NewCart (1997) [ShowNext] (1997) [WebDNA] TCPConnect/cURL alternative for windows? (2010) Can't load tmpl files (1997) [OT] Regular Expressions (2003) Quit revisited (1997) IIS Brain Dead (1998) [WebDNA] WebDNA vs. php war ;-) (2010) WebSTAR 2.1 freezes my Mac (1997) returning the missing value (1997) searchable list archive (1997) emailer (1997) [WebDNA] WebDNA on Linux (2009) Talk Archives down? (2002) login via cookies (2006) New Featured Site (1999) Hidden or Forbidden? (1998) New WebCatalog site! (1997) SV: Mass Mail (2000)