For each entry in that table, there was a date for it. So getting appointments for any given day was extremely easy.
----- Original Message ----- From: Scott Wilhelm <[EMAIL PROTECTED]> Date: Tuesday, January 14, 2003 2:01 pm Subject: RE: RE: How to handle Calendar Scheduling of Recurring Events? > When you looped through to display the dates, did you do a query for > every single day? Or was there another way that you handled this? > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 14, 2003 4:00 PM > > To: CF-Talk > > Subject: Re: RE: How to handle Calendar Scheduling of > > Recurring Events? > > > > > > 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 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
