[SQL] Suggestions on storing re-occurring calendar events

2004-08-09 Thread Matt Nuzum
Hello, I've got an application and there is something that I just cannot get figured out. I currently store a bunch of events for various calendars in related tables that look like this: ftr_cal_master Column | Type | Modifiers

Re: [SQL] Suggestions on storing re-occurring calendar events

2004-08-09 Thread Josh Berkus
Matt, I can think of two ways, [a] Using application logic, create a finite number of future occurrences --- for example, for 10 occurrences, 10 entries into ftr_cal_events will be created. This seems like an ugly hack. [b] Create some new table that will be unioned onto my query to list