I'd suggest storing the full date and time which is basically 'all of the above' in this case. You can pull any of the other information out of the date if you need to later.
..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 22, 2008 2:26 PM To: CF-Talk Subject: Storing Records Weekly in the database - Ideas on how to record the week 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:304013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
