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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:303998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
