On 8/8/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > How do you handle recurring events? Such as if something happens every > monday for a month and the user wants to run a update on all occurences.
Since I use a record for each date the event runs, reoccurring events are handled the same way as any other event. I use CF to add a date record for each and every Monday between the start and end dates. Then I update, add or delete 'em. I offer a date range first (and a calendar view optionally), so the user has the days of the week as checkboxes, with a start and end date, and a start and end time. For that one most stuff is like "7PM-9PM, Tues and Thurs, from 9/21/07 10/14/07", otherwise I might offer the calendar with checkboxes for days first... depends on the data entry needs, neh? So in my case, there is only one event, with however many dates. tbl_events :eventID :eventDescription tbl_eventdatetimes :eventDateID :eventID :eventDateTimeStart :eventDateTimeStop Pretty much. Has worked well for calender stuff, where I'm looking for conflicts on a certain date, and don't want to have to check all event start dates and end dates for dates & times within the given period, etc.. Could just be "six of one, half a dozen of another" though. That's how I do it, mostly. The system I am working with was originally designed by someone else and his > method was to put in the first events ID as a lookup ID on all those > others. It seems to be working so far. I'd be really curious how Yahoo > or > one of the other big online calendar systems stores its data. Me too. Normalization is an art at that scale, I reckon! :Denny On 8/8/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > > > I collect a start and end date from the user, and then create date > entries > > for each day (start datetime, end datetime) in between in a separate > > table. > > > > Seems like a lot of overhead, but has ended up being very handy. > > :D > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4