Re: Date summarising

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62686
interpreted = N
texte = > The easiest thing to do is to make a one-time adjustment to the database to > store the year, month, and day in separate columns. Whether you make this in > addition to the existing column or as a replacement depends on how many > templates update this field. Of course, this would be easy enough too accomplish as there is not a lot of data yet. > > However, I'm assuming that you are currently storing the date value as a > number, > not as a string (since you cannot sort by date with a string that is not in > ISO > format, e.g. [CC]YY/MM/DD). You could also return the records in date order I store the date as a date value 01/01/2005 and use WebDNA with type=Date. I am in Scotland so all my WebDNA prefs are set to EU date formats so date math and sorting works fine. Presumably if I change the db I can just use a summary search on month with another nested search on each months stories? Thanks for the help ======================================== 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)
> The easiest thing to do is to make a one-time adjustment to the database to > store the year, month, and day in separate columns. Whether you make this in > addition to the existing column or as a replacement depends on how many > templates update this field. Of course, this would be easy enough too accomplish as there is not a lot of data yet. > > However, I'm assuming that you are currently storing the date value as a > number, > not as a string (since you cannot sort by date with a string that is not in > ISO > format, e.g. [CC]YY/MM/DD). You could also return the records in date order I store the date as a date value 01/01/2005 and use WebDNA with type=Date. I am in Scotland so all my WebDNA prefs are set to EU date formats so date math and sorting works fine. Presumably if I change the db I can just use a summary search on month with another nested search on each months stories? Thanks for the help ======================================== 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:

Followup question re: checksum for credit cards? (1997) createfolder not behaving as expected (1999) WebCat2 as a chat server? (1997) Security Issue (1997) WebDNA Solutions ... sorry! (1997) WebCatalog Mac 2.1b3 (1997) WebDNA Partner edition .. (2002) Problem (1997) WebCat editing, SiteGuard & SiteEdit (1997) FM and Webcat together? (1998) authorizenet and netscape (2002) Almost a there but..bye bye NetCloak (1997) [WebDNA] jQuery validation and webdna (2015) rotating thumbnails (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Dummy Credit Card Number for debug? (1997) WCS Newbie question (1997) A question on sub-categories (1997) WebCat2b13 Command Reference Doc error (1997) Permission denied? (2004)