How do you handle recurring events? Such as if something happens every monday for a month and the user wants to run a update on all occurences. The system I am working with was originally designed by someone else and his method was to put in the first events ID as a lookup ID on all those others. It seems to be working so far. I'd be really curious how Yahoo or one of the other big online calendar systems stores its data.
On 8/8/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > I collect a start and end date from the user, and then create date entries > for each day (start datetime, end datetime) in between in a separate > table. > > Seems like a lot of overhead, but has ended up being very handy. > :D > > On 8/8/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > This is what I do except in my query I use SQL to determine the number > of > > days for the event instead of storing them in a separate column. Could > > just > > as easily use CF to figure it out since you will more than likely have a > > start and end date for the event. > > > > On 8/8/06, Eric Roberts <[EMAIL PROTECTED]> wrote: > > > > > > If you have a 3 day event and you know it starts on the first, then > you > > > also > > > know that it is on the 2nd and third. What you do is you just need > the > > > start date and the number of days and calculate from there. If you > are > > > pulling this from a db...have every entry have a number of days field. > > > > > > Eric > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
