-=(ASP-Support-Group)=- Calendar Best Practice

I am trying to figure out the best way to check dates on a calendar. I
have a scheduling calendar
(http://www.cumminsnorthwest.com/Portal/ServSched.asp) that just shows
if a date is available based on location. Right now as the calendar is
rendered, it checks a database to see if that date is available or not
than fills in the box with the appropriate color. Unfortunatley that
means that on a long month, it queries the DB 31 times. On the page
that I have for the calendar, if you change locations fast (I am using
AJAX to grab the calendar) it can lock up the web browser.

Besides querying the database for each date, what are some otehr ways
that I can approach this (if there are really any otehr good ways to do
it)? What is the best way to do it?

Thanks,
Soren

Messages in this topic (1) Reply (via web post) | Start a new topic

.

First a comment. That calendar you used asked me if I wanted "to allow
software such as ActiveX controls and plug-ins to run". Now I don't allow
them to run very often, and people could well have them disabled completely.
You'd be better off with a calendar that doesn't require this.

As for how I'd approach this ... I'd actually do a negative check. I'd
query the database to find all the days that are already booked out in the
month, for a location, then use this to configure the "available" days in
the calendar. Hopefully you can retrieve this information with a single
database query - perhaps using "select distinct" to cut down further on the
number of records returned.

Regards, Dave S

----- Original Message -----
From: "Soren" < soren.j.winslow%40cummins.com">soren.j.winslowcummins.com>
To: < ASP-Support-Group%40yahoogroups.com">ASP-Support-Groupyahoogroups.com>
Sent: Thursday, March 06, 2008 7:56 AM
Subject: -=(ASP-Support-Group)=- Calendar Best Practice

>I am trying to figure out the best way to check dates on a calendar. I
> have a scheduling calendar
> (http://www.cumminsnorthwest.com/Portal/ServSched.asp) that just shows
&gt; if a date is available based on location. Right now as the calendar is
> rendered, it checks a database to see if that date is available or not
> than fills in the box with the appropriate color. Unfortunatley that
>; means that on a long month, it queries the DB 31 times. On the page
>; that I have for the calendar, if you change locations fast (I am using
&gt; AJAX to grab the calendar) it can lock up the web browser.
>
>; Besides querying the database for each date, what are some otehr ways
>; that I can approach this (if there are really any otehr good ways to do
> it)? What is the best way to do it?
>
> Thanks,
> Soren
&gt;
>
>
>;
> Group homepage is here:
&gt; http://groups.yahoo.com/group/ASP-Support-Group
>
> To unsubscribe from this group, send an email to:
> ASP-Support-Group-unsubscribe%40yahoogroups.com">ASP-Support-Group-unsubscribeyahoogroups.com and cross your fingers
> because Yahoo is 5h1te.
&gt;
> Yahoo! Groups Links
&gt;
>
>

Messages in this topic (2) Reply (via web post) | Start a new topic

.