Nate Willard wrote: > Hello, > > > I'm working to build a system that stores a set of records every week. Can > anyone offer suggestions on how to best save these records in the DB? > > > Should I have a column 'datetime' and have the result be the Sunday of the > week, for example this week's records all with the datetime: 4/20/2008 > > > or Should I use CF's Week() function and store the week number, which I > believe is currently 17. > > > I'm looking for your advice to prevent issues when I want to access the data > later down the road. > > > Thanks > N
My feeling would be to store the date as a date. That allows you the most latitude in accessing this data as requirements change over time. If you store the week you would also need to store a year assuming you will eventually have data from more then one 'week 17' as the years go by. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
