Personally, I would advise AGAINST using 2 tables for event storage ... It could get messy. If you use the link table then they're all treated the same, you just select everything from the tblEventDates table that's within the current date range that the calender is displaying or searching. If there's only one instance then that's fine, if there are 30 then that's fine too - it's all the same. I would think that using 2 tables for storing the "events" would be pointless. You could accomplish the same thing using one table for events and one for event dates.
For "First Tuesday of Each Month" you would just need to (perhaps) predefine a list of these types of events. Maybe 3 fields on the form: [number] [day of week dropdown] [datepart dropdown] Ie: [2] [Tuesday] [Month] [SUBMIT] Then use CF to pre-determine the dates for the timespan before shoving them in the dates table. Just my opinion though, worth what it cost you :) Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 11:54 AM To: CF-Talk Subject: RE: How to handle Calendar Scheduling of Recurring Events? I'm going to have to give all the input some thought... a lot of good input...thanks, everyone. A couple of notes: This calendar function doesn't have to bother with overlapping events or show duration. Just when it starts. So duration doesn't have to be a factor like it would be in a scheduling function for a room or something like that. Also, I don't *think* anyone's approach so far has addressed a problem with how many recurring community events are scheduled...e.g. "First Tuesday of each month"... That causes the date of each month to be different depending on the month. I guess I could just code the function to find the date of the "First Tuesday of each month", then I'd be set. Right? Another thing... How about having two tables for the app...one that holds "one-time" events and another that holds recurring events with extra fields for denoting frequency, etc. Then when the calendar processes, output events from the table of "one-time" events, then have the code search the table of "recurring" events which have events matching the display date range...say for the month of February. Joshua, you hit upon a problem of rescheduling a recurring event for just one of the times it happens...e.g. next month's meeting will be rescheduled from the "2nd to the 3rd Tuesday of the month". The only way to allow rescheduling would be for the event to have an actual record in the "one-time" events table. That could happen if the recurring events table mentioned above was used to insert specific instances of a recurring event into the "one-time" events table. That table would then provide the event data for display. (That's the first way I can think of immediately...) Finally... Like Neil suggested and Joshua pointed out, in order to have "granular" control over event date/time changes, I could just allow all recurring events to be inserted as individual occurences in the db, for up to, perhaps, the next 2 years, which would allow annual events to be schedule for the next 2 years, and would keep the table down to about 5,000 events covering 2 years, assuming about 50 events per week, both one-time and recurring events. Then, with each passing week, when the calendar is processed and displayed, the code adds another week's worth of events from the recurring events table. It would amount to keeping 2 years worth of records in the table at once. If required by a client, the time-span of 2 years could be increased if they needed to show more years for recurring annual events. ??? Of course, if scheduling certain locations and times was an issue, then the code could be adjusted to check for conflicts... More thoughts? Rick -----Original Message----- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 9:59 AM To: CF-Talk Subject: RE: How to handle Calendar Scheduling of Recurring Events? Actually, rethinking things, a multi-insertion isn't all that bad of an idea - just using a linked table. What if the event has one day out of the recurrence that's an oddity - like if they need to push a Monday meeting to Tuesday one week. If it's a multi-insertion then you could actually let them edit the individual instances of the event by adding another record to the events table and then perhaps reference a "alteration" to a particular event. I think that using a linked table with only dates would give you more granular control over the individual event occurrences. In real life, things get pushed and shoved around to fit into schedules. If they don't get edited then it's no big deal, using a linked table doesn't actually use a whole lot of storage space. Besides, drive space is cheap, processing power is more costly. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 9:49 AM To: CF-Talk Subject: RE: How to handle Calendar Scheduling of Recurring Events? nah, dont worry, us Celts have thicker skin that that... I did see what you meant, and I didnt mean it to be a multi insertion etc.... -----Original Message----- From: webguy [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 14:47 To: CF-Talk Subject: RE: How to handle Calendar Scheduling of Recurring Events? > Thats just stupid Sorry that sounded rude when I reread it! I'll post my solution in a mo. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
