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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
