I would probably implement some sort of recurring exception table to keep up with things like that.
Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 2:11 PM > To: CF-Talk > Subject: RE: RE: How to handle Calendar Scheduling of Recurring Events? > > Hmmm... > > If you have an entry in the one table that doesn't have a specific > date, but is for the "2nd Tuesday of each Month", I can see how you > could code to create specific instances dynamically for display, but how > would you allow for changing from the 2nd to 3rd Tuesday for a specific > occurrence? That instance that is changed has to become a separate > record. Would that happen if the user chose to update the dynamically > created "faux" display record? And when it did, would that event be > inserted > back into the table as a "one-time" event? > > Rick > > > -----Original Message----- > From: Matt Liotta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 1:40 PM > To: CF-Talk > Subject: RE: RE: How to handle Calendar Scheduling of Recurring Events? > > > > You're suggesting one table for everything? > > > One method for everything, which may be implemented using a single > table. > > > Wouldn't that pattern have to be turned into specific occurrences at > some > > point? > > > Of course, at runtime when generating a calendar view for instance. > > -Matt > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4