And now we go WAY OT... Just saw the Victoria reference....welll I'm in the other Victoria...Victoria, British Columbia, Canada (near Seattle for those in the US) ;-) Hello Down Under
and now back to your regular scheduled CFing ;-) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com ----- Original Message ----- From: "Andrew Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 01, 2002 6:47 PM Subject: RE: Any ideas on how to do this please? > 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 > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
