For what it's worth, the MS SQL Server model for scheduled tasks is well
documented in the SQL DMO help. Do a search for "SQLDMOFreq_Daily" and
you'll be smack in the middle of the data model they use. Their model
has no problem with "first Tuesday of each month", etc, and it may give
you ideas.
It helps to have access to a SQL Server to play with to really
understand how their model really works; I used the docs and some
hacking around to develop code to dump a scheduled task's run schedule.
Thanks
Mark
-----Original Message-----
From: Ravi Shankar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 3:10 AM
To: CF-Talk
Subject: Re: designing db tables for calendar events
> >what are you ideas so far? what design have you come up with on your
> own?
> >
> >---
> >Azadi Saryev
> >Sabai-dee.com
> >http://www.sabai-dee.com
> >
> >
> >
> >Ravi Shankar wrote:
> >> Ravi
>
> My approach is following
> -------------------------
> PatternbaseTable
> ---------------
> Pattern Id --> 0,1,2,3
> Pattern value --> daily,weekly,monthly,yearly
>
> EventTable
> ---------
> Pattern Id,
> Start time
> end time
> start date
> end date
> isRecurence --> which indicates if it is recur event or not.
> no_of_occurence
> counter --> to keep track on number of recurrences which are over
>
> EventPattern
> ------------
> Patternid Primary value secondary value
> ------------------------------------------------------
> 0 [ Daily ] 2 NULL --> This row means
> event is daily
> and will recur every 2 days
> 0 [ Daily ] NULL 1 --> This row means recur
> every
> weekday
> 1 [ weekly ] 2 MTW --> this row indicates
> recur every
> 2 weeks and the days are M
> [ monday] T [ tuesday ] and
> [wednesday]
> 2 [ Monthly ] xxxx xxx --> I am not clear on
> how to fill for
> monthly
> 3 [Yearly ] xxxx xxx --> Not clear
>
> So i want to know if my approach is clear.If yes then what values
> should I fill for monthly and yearly.
> To get a clear incite of what I am taking about,open outlook express
> and try to configure a meeting and in the recurrence choose monthly
> and yearly.
>
> Thanks
> Ravi
>
>
>
I am not clear on how to represent the following
The first tuesday of every 3 month.
The first tuesday of january
In the approach which i have taken.
Any suggesstions are welcome.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296756
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
