Best way to build a recurrent days...

[PerryC]

I am trying to build a room reservation system for our church. The
problem is, some events happen on a weekly basis, other adhocs. What
is the best way inquire for data and then display them? i.e. I don't
want to ask users to enter the recurrent event every week in a year,
is there a way to build a select... The tough part is, if one week out
of the 52 weeks certain group is not using a certain room (which they
normally use weekly), How can this be overided, just for that week?

Thanks in advance,
Perry

[Bradley]

PerryC wrote:

I am trying to build a room reservation system for our church. The
problem is, some events happen on a weekly basis, other adhocs. What
is the best way inquire for data and then display them? i.e. I don't
want to ask users to enter the recurrent event every week in a year,
is there a way to build a select... The tough part is, if one week out
of the 52 weeks certain group is not using a certain room (which they
normally use weekly), How can this be overided, just for that week?

Thanks in advance,
Perry

I've got a similar "recurrance" in a system for my church (pastoral care
tracking for large churches).

One way is to create seperate records for each occurance that link back
to the initial record (which contains start/end/period). You could then
just delete any that are not needed anymore. When clicking on a date it
would show all the occurances so you can edit them, move one, delete
another etc.

The problem then is what if you have an open-ended recurrance? With this
you could create records for all the occurances for a certain time in
the future and create more occurances on your startup code to always
keep it a year for example in the future.

I'm sure there are other ways though :)
--
regards,

Bradley

[Tom van Stiphout]

On 21 Apr 2004 20:07:54 -0700, pe******@yahoo.com (PerryC) wrote:

For these situations I always speculate how Outlook does this. It
supports recurring appointments (appt), and you can delete one appt or
all.

One way we once implemented this is by having a Master record that was
the first one created:
ID=123, ApptDate=1/1/2004, ApptTime=7PM-8PM, Recurrence=every week

When starting the app, the startup code would ensure we had N years of
appts scheduled. Each one carried the MasterID (null for single appt),
which allowed us to easily wipe out the whole (future) series if
needed.

-Tom.

I am trying to build a room reservation system for our church. The
problem is, some events happen on a weekly basis, other adhocs. What
is the best way inquire for data and then display them? i.e. I don't
want to ask users to enter the recurrent event every week in a year,
is there a way to build a select... The tough part is, if one week out
of the 52 weeks certain group is not using a certain room (which they
normally use weekly), How can this be overided, just for that week?

Thanks in advance,
Perry

[Perry Cheng]

Yes, something like Outlook or any other Calender is what I am after.
What you have suggested I actually implemented in the past... but it is
not exactly like Outlook. I was wondering if anyone has something like
that built?

PC

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!