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 ofdata 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 orderI store the date as a date value 01/01/2005 and use WebDNA with type=Date. Iam in Scotland so all my WebDNA prefs are set to EU date formats so datemath and sorting works fine.Presumably if I change the db I can just use a summary search on month withanother nested search on each months stories?Thanks for the help========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: 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:
> 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 ofdata 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 orderI store the date as a date value 01/01/2005 and use WebDNA with type=Date. Iam in Scotland so all my WebDNA prefs are set to EU date formats so datemath and sorting works fine.Presumably if I change the db I can just use a summary search on month withanother nested search on each months stories?Thanks for the help========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: 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)