When I collect the info, I have a start date and number of days for the event and let CF figure out the rest ;-)
The calendar I created can be viewed at http://www.midwestpagans.org Just click on a state (IL has the most) and then click on the link for the calendar. One of these days I have to go in and update the code as it was written 8 years ago for CF 4.5. I could prolly spiffy it up a bit to make it more efficient. That would require having the time to do so ;-) Eric -----Original Message----- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Tuesday, 08 August 2006 20:51 To: CF-Talk Subject: Re: Calendars 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:249388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
