[ciapug] calendars

[Carl Olsen]

Here is yet another calendar I built for Mediacom, which stores starting
date, starting time, ending date, ending time, duration, frequency, and has
a child table with 48 half hour increments for each day.

     http://www.connections22.com/

Every calendar is different.

-----Original Message-----
From: ciapug-admin@cialug.org [mailto:ciapug-admin@cialug.org] On Behalf Of
Carl Olsen
Sent: Thursday, May 05, 2005 4:08 PM
To: ciapug@cialug.org
Subject: RE: [ciapug] calendars

If a date is given, validate it.  Simply bypass the validation if the field
is null or empty - same thing for time.  You can always use a default in the
database if no date or time is given.

As far as displaying the calendar, you can do that a lot of different ways.
I've simply listed the ones with no time first, but you could do anything
you want.

You probably want to do it differently depending on circumstances.
Sometimes people will tell you how they want it to look, and sometimes they
will tell you how they want to input the data.

Here's one I did for Capitol Hill Lutheran Church -
http://www.capitolhilllutheran.org/des_moines_church_events.htm

And here's another one I did for Des Moines Neighbors -
http://www.dmneighbors.org/Modules/CalendarManager/Calendar.aspx


-----Original Message-----
From: ciapug-admin@cialug.org [mailto:ciapug-admin@cialug.org] On Behalf Of
Scott Phillips
Sent: Thursday, May 05, 2005 2:19 PM
To: ciapug@cialug.org
Subject: Re: [ciapug] calendars

Good points.  I'm going to complicate matters slightly.

I'd like the date to be required but start/end times optional.  How should 
I keep track of whether this is an all-day event (no specific time) or 
meeting with time specified.  Perhaps an all-day-flag field?

Trivial questions?  Probably.  But I like to hear how others approach 
things and this list has been real quiet lately!




_______________________________________________
ciapug mailing list
ciapug@cialug.org
http://cialug.org/mailman/listinfo/ciapug