Interesting idea.
Perhaps its best to store the current date, and then when I need the data, query for the top set of records for the given week? ----- Original Message ---- From: Barney Boisvert <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Tuesday, April 22, 2008 12:27:33 PM Subject: Re: Storing Records Weekly in the database - Ideas on how to record the week Why not just store 4/22, and then do the date computation on the other (recall) side? It'll potentially be a little slower, but unless you have a crapton of data, its probably irrelevant. cheers, barneyb On Tue, Apr 22, 2008 at 12:24 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > Greg, > > > I think its more complicated than that, but I might be over thinking this... > > > If I want to records weekly and lets say I ran those records today > > > Todays date is 4/22/2008 > > > But, I would need to insert those records into the database as 4/20/2008 > since 4/20 is the start of this week. > > > right? -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
