Results 1 to 4 of 4

Thread: recurring events in calendar

  1. #1
    Senior Member
    Join Date
    May 2001
    Posts
    472

    recurring events in calendar

    I've written a (fairly nice imho) calendar display program that uses a MS SQL server to hold the data. One of the problems I am having is with recurring events. Entering them day after day after day is a bit much, since some of them go for a month or two non-stop. What I'd like to do is give the person entering the data the option of a start and stop date. Then when it is submitted, some how cycle thru every date between the two to enter the information in hte SQL server.

    Should it be something as simple as adding a day to the start date, creating a new date from that, sending the SQL statement, increment a counter, add the counter to the start date and repeating until start date + counter == end date? Or is there a better way?

  2. #2

    Re:recurring events in calendar

    What language are you programming on?

    Do you want to do this from the SQL side or from the application side?



  3. #3
    Senior Member
    Join Date
    Nov 2001
    Posts
    419

    Re:recurring events in calendar

    What a nice idea. I would be interested in this same thing. I've got a calendar system written in PHP which interfaces with a MySQL db...

  4. #4
    Senior Member
    Join Date
    May 2001
    Posts
    472

    Re:recurring events in calendar

    Coding it all in php. Got it working, it was relatively easy to do my plan. Next is to allow people to schedule long events (month or two) and skip weekends, or recurring on whatever day(s) of the week.

    Several people have posted interest in the scripts, so I'll try to get them cleaned up and commented (comments are for weenies ), remove the stuff specific to the school, and post it.


Similar Threads

  1. Microsoft Money 2005 Recurring Category Setup
    By mriopelle102 in forum Windows - General Topics
    Replies: 0
    Last Post: 02-02-2005, 07:37 AM
  2. Events and cert.
    By Fatal Error in forum General Chat
    Replies: 3
    Last Post: 02-01-2005, 12:13 AM
  3. Lemony Snicket's A Series of Unfortunate Events
    By shebang in forum General Chat
    Replies: 21
    Last Post: 01-22-2005, 07:26 AM
  4. Events and Errors Database
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 12-31-2004, 11:15 PM
  5. calendar in PHP
    By ph34r in forum Linux - Software, Applications & Programming
    Replies: 5
    Last Post: 08-07-2003, 08:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •