Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
benricho
Yak Posting Veteran
84 Posts |
 Posted - 2001-11-19 : 18:53:33
|
| I am writing a web based calendar app, and I need users to be able to add an event that will recur, such as every Thursday for 6 weeks. Has anyone got some experience on the best way to implement something like this? |
|
|
benricho
Yak Posting Veteran
84 Posts |
Posted - 2001-11-26 : 18:43:16
|
| Ok, the schema is pretty simple, I have an appointment table and an appointment recurrence table:Appointment-------------appID (pk)appStaffID (fk)appTitleappDescriptionappStartTimeappEndTimeAppointmentRecurrence---------------------appReccID (pk)appID (fk)appDateAs you can see individual appointment start and end times can't be modified. I was just going to populate the AppointmentRecurrence table with the appropriate dates when the user added an appointment, but then I realised that when users want to edit an appointment, I won't know what recurrence pattern they had previously selected. I guess I have to store these details and use some rules to work out what they selected? |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-11-28 : 15:04:31
|
| Won't you be able to get all the info you need because of the AppID being in the tables?-------------------It's a SQL thing... |
|
|
|
|
|
|
Event recurrence