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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
