Hello all, I am re-designing a database driven calendar application. I want to support recurring events (such as a weekly meeting) and I was looking for a few design suggestions. Basically, I want a user to be able to enter an event and specify that it happens on a repeating schedule: every week, once a month, etc. When a user views the calendar I want these to appear, but I do not want to have to enter a record into the database for each occurrence of that event. In other words, if an event happens weekly I want to have one database record, not a separate record for each week of each month of each year, etc.
Does anyone have any experience with this sort of thing that they would like to share? I am specifically interested in the best way to store the information about the repeat schedule in the database, and the most efficient way to query against this data to find which events will fall on any given day. Thanks in advance, Seth Petry-Johnson Argo Enterprise and Associates ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
