Re: Is this really new ?

[Nathan Andelin <nandelin@xxxxxxxxx>]

> From: Maurice O'Prey
> With a properly designed database schema a single SQL
> statement would suffice (not 42 SETLLs), returning the day,
> month, year and boolean flag for whether or not there is an
> appointment booked for that day ...

Thanks for the suggestion.  I may try something like that.  I need to answer the question - does a given user have any events scheduled on a given day - where there are 42 days in the grid?

> Are suggesting that a procedural program should be 
> initiated that in turn renders HTML for the days of the
> calendar with  appointment days flagged ...

No.  I'm using JavaScript to generate the calendar.  But when users navigate to prior or up-coming months, I'm setting the background color of each day according to whether that day has one or more scheduled events - using AJAX.

> Wouldn't it be better to bind a Calendar control to a datasource
> that provides the information requested?

You lost me, there.  Are you suggesting that Microsoft already provides a calendar control that implements the behavior I'm looking for?

Nathan.