Personally, I would have a checkbox which would simply state : recurring event with a duration flag... i.e. Weekly, Monthly, Daily etc....once clicked it should be able to insert the event at each date/time from that point forward... you have got the basis of the calendar and indeed it should be fairly simple to modify it so..
Neil -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 14:07 To: CF-Talk Subject: How to handle Calendar Scheduling of Recurring Events? Hi, all. I was wondering about the various approaches that have been taken to scheduling recurring events in a calendar? I haven't worked with auto-insertion of recurring events, but now is the time for my calendar creation to become more sophisticated. Should I insert data for "one-time" events in one table and data for "recurring" events in another with the user specifiying daily, weekly, monthly, quarterly, yearly, etc...and have code that checks that table and auto-inserts those events when the day/dates are checked? How would I handle the City Council meeting that is scheduled on "the 2nd Tuesday of each month." Would I have the person inputting the data fill out or check fields for "1st, 2nd, 3rd, etc.", then "Tuesday, Wednesday, etc.", each "Week, Month, Year" or whatever? (That could get really complicated...) Just let them handle that kind of insertion manually? Perspectives? (If anyone knows of any tutorials that address this subject, a link would be most appeciated!) Thanks, and good morning! Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
