>So that approach would actually create 3 years of specific occurrences of >recurring >events in the calendar table...right? If that's true, then it would allow >a user to modify a specific instance of a recurring event for >flexibility...right?
That could work too depending on the scenario or the event itself, didn't think of that. I was thinking more along the lines of performance issues when mentioning that - 3 years worth of dates seems more than enough for a user to browse through a calendar and prevents constant access by the db for that particular event. > >Also, can you describe the "refresh or trigger option" a little more? Is >this >for creating specific occurrences of recurring events only when the calendar >is called up for viewing of a previously unviewed time period on the >calendar? What I was thinking of there is an event based operation of sorts that works both ways. A calendar is just for presentation, a trick of the users eyes of sorts. Take a common calendar control for instance with a select for year. You have a month with an event on say the first day of that particular month. Since three years will be cached on the db end you can move forward to 2004, 2005... then when you get to 2006 - create the successive dates for just that year only (or two, whichever). Since you have that rule or origin stamp of sorts, you can create the dates on the fly as needed, may be some tricky algorithmic programming though, best wrap some of the sql logic in a stored procedure too. Same sort of thing when going back, though perhaps only create one years worth of dates in the lookup table at a time (who really goes back to look at archived events that much, anyways) Granted I'm making some gross user assumptions here. Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
