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

2004-08-15 Thread --CELKO--
>> I'd like to figure out a way to add simple re-occurrances of events. 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. << No, not r

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 l

[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 +---+---