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:
> 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:
Emailer setup (1997)
[WebDNA] DNA suffix (2008)
All choices on IE different than Netscape (1997)
multiple databases (1997)
WriteFile Command (1998)
[WebDNA] Reformatting database headers (2009)
Possible Bug in 2.0b15.acgi (1997)
Server slowing down. (1997)
WC2.0 Memory Requirements (1997)
Hiding HTML and page breaks (1997)
no word on MacAuthorize... (1997)
$quit / Command=Quit (2002)
Displaying photo attached to first record (1997)
Not reading code (1997)
creator code (1997)
Robert Minor duplicate mail (1997)
WCS Newbie question (1997)
Locking up with WebCatalog... (1997)
Help with Shipping Costs (1997)
File Security (1999)