Look at the demo calendar at geonorth and there geocalendar program. ----- Original Message ----- From: "Seth Petry-Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 10:23 AM Subject: Recurring events in database driven calendar
> 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
