UsefulConcept

Just started looking into setting up recurring events in a calendar for an application of mine.  I haven't had to deal with this before and to be honest I don't want to invent something that must have a standard out there.  I would rather use the established methodology.   I searched around the ColdFusion world a bit, but haven't found anything.  I then started searching around for anything relating to it.  I found lots of wiki's with info like "we need to do x" but not much that gave me a sense that there is a tried and true way to do store and search them.

I can easily enough make a schema for storing recurring events (monthly, weekly, every x days, etc).  The tough part comes in doing proper searches. Ideally there is only one query result.   Do people make temp tables of actual records for events, populated by the recurring event record?  It would work, but seems wasteful. How far out would you populate? 

What have you done to deal with repeating events?

Like this entry? Subscribe to my blog.