I initially tried building a coded system where numbers 1 through 10
referenced a certain type of recurring appointment, and would then call a
specific function for each, but as more appointments were added things began
to slow down quite a bit. I've taken a different approach since, and decided
to create a single record for each recurring appointment, but this has
problems as well due to the fact that I have to search each time slot going
all the way out to the specified end date/time.
What is the most efficient way to create recurring appointments using ASP
and SQL Server?
Thanks 5 4043
Does anyone know of any components I can use to build recurring
appointments?
"gil" <gi*@nospam.thankyou> wrote in message
news:uI**************@TK2MSFTNGP09.phx.gbl... I initially tried building a coded system where numbers 1 through 10 referenced a certain type of recurring appointment, and would then call a specific function for each, but as more appointments were added things
began to slow down quite a bit. I've taken a different approach since, and
decided to create a single record for each recurring appointment, but this has problems as well due to the fact that I have to search each time slot
going all the way out to the specified end date/time.
What is the most efficient way to create recurring appointments using ASP and SQL Server?
Thanks
"gil" <gi*@nospam.thankyou> wrote in message
news:uI**************@TK2MSFTNGP09.phx.gbl... I initially tried building a coded system where numbers 1 through 10 referenced a certain type of recurring appointment, and would then call a specific function for each, but as more appointments were added things began to slow down quite a bit. I've taken a different approach since, and decided to create a single record for each recurring appointment, but this has problems as well due to the fact that I have to search each time slot going all the way out to the specified end date/time.
What is the most efficient way to create recurring appointments using ASP and SQL Server?
Thanks
There's a nice disucssion of recurring events in this article: http://aspfaq.com/show.asp?id=2519
Thanks for the reply. How would you recommend checking to see if an
appointment is available or not?
Would you first lookup all the dates in the auxiliarly table (depending on
the complexity of the pattern) and then build a new query from there?
Thanks again
"Chris Hohmann" <no****@thankyou.com> wrote in message
news:uN****************@TK2MSFTNGP12.phx.gbl... "gil" <gi*@nospam.thankyou> wrote in message news:uI**************@TK2MSFTNGP09.phx.gbl...I initially tried building a coded system where numbers 1 through 10 referenced a certain type of recurring appointment, and would then call
a specific function for each, but as more appointments were added things began to slow down quite a bit. I've taken a different approach since, and decided to create a single record for each recurring appointment, but this has problems as well due to the fact that I have to search each time slot going all the way out to the specified end date/time.
What is the most efficient way to create recurring appointments using
ASP and SQL Server?
Thanks There's a nice disucssion of recurring events in this article: http://aspfaq.com/show.asp?id=2519
"Phil" <no*@anaddress.nospam.com> wrote in message
news:eA*************@tk2msftngp13.phx.gbl... Thanks for the reply. How would you recommend checking to see if an appointment is available or not? Would you first lookup all the dates in the auxiliarly table (depending on the complexity of the pattern) and then build a new query from there?
Join the set of potential recurring events with the set of existing events.
If the resultset is empty, then there are no conflicts.
"Chris Hohmann" <no****@thankyou.com> wrote in message
news:Od**************@TK2MSFTNGP09.phx.gbl... "Phil" <no*@anaddress.nospam.com> wrote in message news:eA*************@tk2msftngp13.phx.gbl... Thanks for the reply. How would you recommend checking to see if an appointment is available or not? Would you first lookup all the dates in the auxiliarly table (depending
on the complexity of the pattern) and then build a new query from there? Join the set of potential recurring events with the set of existing
events. If the resultset is empty, then there are no conflicts.
Thank you, that worked great. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Pramod |
last post by:
Experts
I am also trying to create appointments for Outlook users on a
specific Day and time. I was told you can't create appointments for
others (but only for the user who is logged on).
Is...
|
by: Shabam |
last post by:
I'm having a calendar feature developed whereby users can add recurring
events. These recurring events can have start and end dates, meaning they
will recur only within a date range. For...
|
by: steve |
last post by:
Hi All
I am writing a program for a gymnasium for membership control
It is the first time I have had to deal with appointment diaries and I want
to know the best way to store recurring...
|
by: nepdae |
last post by:
Please forgive me, this is a long one.
My 11-user Access 2000 database is having recurring corruption
problems. The symptoms include the following:
1) corrupted fields in recently created or...
|
by: VB Programmer |
last post by:
Here's the scenario: 3 different pcs in a doctors office. 2 doctors with 2
seperate appointment calendars. All 3 pcs need to be able to see, real
time, both doctors calendars and add, remove,...
|
by: Stephen B. Burris Jr. |
last post by:
In my database I need to keep the offices calendar up to date with the
current information that my database is tracking. To do this I am
entering events as appointments. Entering them into...
|
by: mattkorguk |
last post by:
Hi,
Following the introduction of an appointment booking system in Access I've now given myself another issue.
As I'm sending lots of appointments out I'm also then getting lots of the same...
|
by: Ben Grimwade |
last post by:
Hi, im developing an Application that integrates with Outlook by creating an appointment in there calender.
The code in question is below
Dim appt As Outlook.AppointmentItem
obj =...
|
by: =?Utf-8?B?TWVlbWEgSnVkeQ==?= |
last post by:
I have a Verizon Palm Treo 755p and use Outlook 2002 on my new HP Pavilion
(Vista 64-bit). When I was syncing on my old XP PC, everything worked fine.
On the Vista PC, when I finally got it to...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |