Try this one on:
================
tblEvents
================
eventID int(4) (PK/ID)
parentID int(4) (Parent Identifier - 0=Main Event /
[eventID]=Child Event [modified instance - eventID of the parent])
ename varchar(150) (Event Name)
edesc varchar(1000) (Event Description)
estarttime datetime(8) (Event Start Time)
eendtime datetime(8) (Event End Time)
estartdate datetime(8) (Event Start Date)
eenddate datetime(8) (Event End Date)
erecurr varchar(500) (Recursion Pattern)
[Anything else you want in events table ...]
Then in ColdFusion, you write a self-referencing CustomTag that loops
over the Events that have 0 as their parentID and pull their date
records, then if any of those dates fall in the displayed range, then
you begin checking the Child Events of those parents for any
"modifications" to the main data that occurr in the date range
specified. If there are child instances you display child data, if not
you display the parent data.
To handle the recursion you would perform pattern checking to determine
if this event that is in the range actually has an instance in this view
which, admittedly, is the hard part. I would try some type of codes for
a recursion pattern rather than checking plain English. Say for example:
1MM = First Monday of the Month
2TF = Second Tuesday in February
You could use string functions to cut the pattern into pieces that would
be meaningful in code.
Ok, so someone tear this apart :)
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
************************************************************************
*************
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
************************************************************************
*************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
