Tim - You're asking a fairly complicated question. Let me simplify the way I ended up doing it was a related datamodel: event [event_id, ...details...]
event_date [event_id, date (day, month, year), time, duration] Now, the important thing to note is that "event_date" is unique on event_id AND date. Every day that an even was good for, got a new record. For my application, time & duration were not necessarily the same on every day, in which case, I needed to put it in event date. A more elaborate scheme would be the following event [event_id, ...details...] event_recur [event_id, recur_id, duration] recur [recur_id, ...] In this scheme, ColdFusion would be in charge of placing recurring to the screen properly. A recurrence might be: every other week. A duration might be: 12 times. Lots of effort is put into printing recurrence on output. This scheme also makes determining exactly which events occur on a particular day difficult in SQL. Mike Wokasch At 01:25 PM 10/15/2002 -0400, you wrote: >I am creating a calendar of events database & CF app from scratch.. An >initial question that comes to mind is.what is the best way to store >event dates for this.using separate fields called something like >from_day, >to_day >from_month >to_month >from_year >to_year > >OR - should I somehow just use two fields.one for the "from date" (ex. >3/12/02) and one for the "to date" (ex. 3/13/02) >I'm trying to think ahead to the customer making calendar changes and >displaying the calendar >Could anyone with experience creating this type of event calendar share >their thoughts on this? >Thanks in advance >Tim Laureska > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com