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 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