Hi folks The New Zealand Ecological Restoration Network Website at www.bush.org.nz is currently being moved over to ColdFusion. ColdFusion is a great tool!
We have the same need with events having patterns. Our solution so far is to have a one form for one off events and another for regular events with a pattern. The data goes back into one table. There is a second table for the specific occurance. A volunteer manually enters all the repeat occurances of a regular event. Its a real hassle. Would be nice to be able to automate this too Mike Peters Volunteer Developer ---------------------------------------------------- NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- To you too Mike, I am in Victoria so I am not affected but I feel for those that do live in those areas. I actually did something similar for Siemens Corporation about 2 years ago, for their intranet. Mike I would use three filed one to decide the date it was created, then the type (which could be a list) to determine the period the event needs to be displayed and maybe one so that it can't be displayed past this date. The other thing to keep in mind that each event can be located in one table, then use a unique user ID that would then identify who the event belongs to as well. Sorry seeing words on a screen really doesn't help, but hopefully we can help you out more. -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 2 January 2002 1:22 AM To: CF-Talk Subject: RE: Any ideas on how to do this please? Andrew, Kym, thanks for your interest in my problem. Happy New Year to y ou. I'm not sure where in Oz you are Andrew, but I hope neither of you are be ing barbecued right now in Sydney. It's a worry for me out here in Windsor, but thankfully we haven't been directly threatened by the fire yet, although some of our friends have had to evacuate their homes up in Kurrajong. The site in question is www.bluegrass.org.au .. it's a directory of bluegrass music and events in Australia. At the moment I'm keeping it up to date by editing all the pages myself, using simple html for the most part. (there are some dynamic aspects to the site but the events listings are a ll manually created). Single events, like a concert, I have set up ok. I enter the location an d other details and the date in my SQL database and the listing appears in the relevant state pages and disappears after the event is over. Now I want to do a similar thing with regular events, such as monthly association meetings, or regular jam sessions (which could be on the seco nd Tuesday of the month say) and I want to allow people around the country t hat I authorise to be able to update listings in their areas. So this mean s I cant have it with all these people (with greater or lesser understandings of html) tinkering with the pages directly. I have to do it by giving them a form and the database to get the dynamic updates happening. So I'd like to give them a form where they can enter the location and tim es and other details of the event, and for the date, let them choose either specific dates, or a pattern, such as "monthly on the first Friday" or "fortnightly on Saturday" IT's this aspect I'm not sure how to do. In my processing of the form, should I insert these "monthly on the first Friday" details into the database or convert them to specific dates at th at time. Or should I pull these events out every time the page is called, and work out what events are coming up in the next month, based on the specific da te listings, and the periodic listings? Does that make it clearer? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:04 PM To: CF-Talk Subject: Re: Any ideas on how to do this please? Hi Mike, >I am embarking on a sub-project to allow suitably authorised users to in put >events to my web site, to be displayed a month before the event happens, and >automatically deleted after the event is over. I want the users to be a ble >to put in an event as being held on a specific date, weekly, every two >weeks, every month, on the third Friday of the month etc. I am a bit like Andrew, I would like to know more about the thing in term s of size, business of the servers, etc. You can do more work in CF and put a set of events in the DB but it will be bigger as a result but the queries a lot simpler compared with calculating it on the fly every time. BTW if you are showing the event for a month before, then clearing it, ho w are you going to handle a weekly event :^) -- Yours, Kym ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists