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 > > > > -----Original Message----- > > From: mac jordan [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 08 August 2006 08:54 > > To: CF-Talk > > Subject: Re: Calendars > > > > On 7/13/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > > I've built a calendar like this, but it's not the prettiest piece of > > > code that I've ever written. The really tricky part was displaying > > > events that took place over a number of days. > > > > > > http://www.beeryard.com/events/default.cfm > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:249263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
