Seth
Here is one of those places where it is convenient to set/use a business
"policy".
Again, I f you think about the application, how far in advance can one
realistically
schedule a recurring event -- I would guess 6 months, tops.
So, set a "policy" that your application sets N recurring events
maximum, where
N is something like:
6 monthly events
12 weekly events
or events can only be scheduled 6 months in advance
whatever seems logical for your calendar,
Then to make it easy (but not too easy) for the scheduler, after he has
scheduled one set
of events, fill in the defaults for the next set of events.
With a "policy" such as this, you avoid situations where people reserve
a time-slot for the next 2 years
(will we still be in business then? will the one who scheduled the
meeting still be with the company, Will
anyone know why this meeting was scheduled).
This approach will yield a useful, "living" calendar -- rather than one
cluttered with meaningless events that will likely never happen (and can
be difficult to remove from the calendar).
HTH
Dick
On Sunday, August 18, 2002, at 02:26 PM, Seth Petry-Johnson wrote:
>> Kreig's advice is spot on!
>>
>> If you think the application through, I believe that you will come to
>> the same conclusion.
>
> Many thanks to everyone that responded to my post. After reading
> through
> everyone's suggestions I've decided to follow Kreig's advice of
> creating a
> database record for every occurrence of an event. This will obviously
> simplify my database logic when querying for events and also allows for
> better data indexing, something that my early ideas did not do well.
> This
> approach will also allow me to add unique comments for each occurrence
> of an
> event and potentially track information about each event's attendees.
>
> One question for you Kreig: when a recurring event is added to the
> database
> a number of inserts must be run. In your application, how far "down the
> road" did you create records in the DB? If an event is to take place
> every
> Monday with no definite end date specified, how many records did you
> create?
> A year's worth? Two?
>
> Thanks again for everyone's input,
> 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
