>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:296604
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
