Rick: One way I did it in a previous application was to have the person select the duration of the event...If it was a single day event, the start date & end date were the same in the DB. Then, in the field below, I would ask what days it occurs on (ie. Monday, Tuesday, etc.) The values for each check box were the numerical values of the day of the week. Then, when the calendar processes, it checks each day that it's displaying if there are any events...It would then find that all those days there might be something to display. Then check to be sure that the current day it's processing is selected for weekdays. Let's say the event went from 1/6/03 to 1/13/03 and the user select M,W,F. The way I had the calendar setup was that for each day it would search the database...So for 1/1, call to the db & check for events, 1/2, call to the db & check for events, etc. Once it got to 1/6, it would see that there's an event that it might be able to display...Then it checks the weekday values and sees that the 6th is a Monday and falls within what the user defined...Then onto 1/7...it would then find that it does fall within the time span, but Tuesday's not listed...And so on... Did I confuse anyone? If there's a better way to do this, I'd love to hear.... HTH, Scott
-----Original Message----- From: Rick Faircloth Sent: Tue 01/14/2003 09:06 AM To: CF-Talk Cc: 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