Just off the top of my head ... Let's say a recurring event has an ID of recurring_id
If an event is canceled, we might store something in the table like: exception_id, recurring_id, 'cancel', '1/21/03' If it's rescheduled exception_id, recurring_id, 'new date', '1/22/03', '21:00' Make sense? H. > -----Original Message----- > From: Rick Faircloth [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 2:29 PM > To: CF-Talk > Subject: RE: RE: How to handle Calendar Scheduling of Recurring > Events? > > Hi, Howard and thanks for the input... > > Tell more more about the "Exceptions" table. > How do you see it being setup and how would it's data be used > for processing? > > Rick > > > -----Original Message----- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 4:01 PM > To: CF-Talk > Subject: RE: RE: How to handle Calendar Scheduling of Recurring Events? > > > This is just what I was thinking ... three tables .. > > -- One_Time events (could also contain multiple instances of same event > that > are not, specifically, recurring) > -- Recurring events (stores info needed by CF code to build monthly > calendar) > -- Exceptions table (stores user-input info on specific dates that > scheduled > recurring events are canceled (one entry) and rescheduled (second entry) > > CF code would build (though maybe it would be better to do in a stored > procedure), say, a daily calendar by first pulling recurring events that > meet the criteria for running that day, then checking the exception table, > then mixing in that day's one-time events. > > This meets the needs of recurring events without dumping a whole bunch of > dates into one table, and allows users the ability to reschedule recurring > events. > > On the user interface, when the user logs in, the user gets a hit list of > upcoming events (recurring or otherwise) within that users domain for, > say, > 90 days out, and each one can be individually edited. > > H > > > -----Original Message----- > > From: Matt Liotta [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, January 15, 2003 12:07 PM > > To: CF-Talk > > Subject: RE: RE: How to handle Calendar Scheduling of Recurring > > Events? > > > > 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 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
