Yeah, I did this. I wrote a whole recurrence component for an application. I did follow the Outlook model and it did work quite nicely. However, Outlook allows you (fake) enter forever recurring occurrences. I didn't allow this - all appointments had to have an end date. It wasn't an issue for my app, but YMMV.
For the database, I set up a parent record, and then created child records. The hardest part was actually determining which days the recurrences fall on. ----- Original Message ----- From: "Owens, Howard" <[EMAIL PROTECTED]> Date: Tuesday, January 14, 2003 1:29 pm Subject: RE: How to handle Calendar Scheduling of Recurring Events? > This discussion has come up at a timely time, as I'm getting ready > to build > a calendar app. > > I just wanted to point out -- take a look at the recurrence screen in > Outlook. It's a pretty intuitive GUI and might provide some useful > guidanceon how to set up such an interface, provide some good > ideas on how to > collect data (and what needs to be collected) and provide further data > storage hints for the best way to store and retrieve the info. > Also, with a > bit of JavaScript, the GUI could be emulated pretty nicely. > > H. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Howard Owens > Internet Operations Coordinator > InsideVC.com/Ventura County Star > [EMAIL PROTECTED] > AIM: GoCatGo1956 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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