« Calendar View -- Two-Week Display | Main | Staff Development, Thursday, October 5, 2006 »

October 4, 2006

Calendar Views

I have written code to view the calendar, with options to list the tutoring sessions by subject and by tutor. Once I had the calendar view working to show all tutoring sessions over the current two-week time period, listing the sessions by subject and tutor was fairly easy.

When selecting the link to view by subject or by tutor, you are prompted to supply the subject area or tutor's name using a dropdown box that involves a query to either the Subjects table or the Tutors table. After gathering this information, my code determines which view you have selected, runs the appropriate query (cursor), then displays the results within the generic calendar/table that I developed sometime back.

I still need to do some clean-up of my code, as the calendar views look a little crude at this point, and I need to fix some broken links within the various pages, which are the result of changes and additions to parameters being passed to several procedures.

Posted by goodeld at October 4, 2006 9:22 AM