If I were doing this, I would allow them to choose the dates and not do t he first friday thing. This will save much aggrevation on your part as far a s date manipulation goes. You could give them the option of start date and end date and maybe use a JS calendar for them to choose dates from. There is several in allaires tag gallery which have username/passowrd ability etc.
There are two major products that come out of Berkeley: LSD and [Unix] BS D. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 01, 2002 6:22 AM 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, althoug h > 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 pa rt. > (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 i n > 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 se co > 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 me an > s I > cant have it with all these people (with greater or lesser understandin gs > of > html) tinkering with the pages directly. I have to do it by giving the m > 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 t im > es > and other details of the event, and for the date, let them choose eithe r > 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 fir st > 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 wo rk > 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 happen s, > 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 tw o > >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 te rm > s > of size, business of the servers, etc. You can do more work in CF and p ut > a > set of events in the DB but it will be bigger as a result but the queri es > 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
