This is a multi-part message in MIME format.
------=_NextPart_000_0015_01BFAB26.1C358640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Everyone,
I am writing a scheduling application. My problem is that I can't =
figure out what to put in the SQL WHERE statement to handle a particular =
case:
Someone may have scheduled a event to last several days, or even weeks. =
For instance the event could start on April 15 and last until April =
20th. The IDEA is that the scheduler only allows the user to VIEW one =
day at a time. The user selects a date and then I query the database to =
see what events take place on that day (even if they started a few days =
earlier and/or won't end for a few days.) I have no trouble selecting =
the event if it starts or ends on the particular day in question, but I =
don't know how to handle events that last a few days (esp. when the user =
is trying to view a day that is in the middle of several day event.)
My table (in an MS Access 2000 database) has these fields:=20
Start_Date_Time,
End_Date_Time,
Name_Of_event
Can anyone give me any ideas on how to SELECT these events?
Thank You,
Eron
------=_NextPart_000_0015_01BFAB26.1C358640
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Everyone,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I am writing a scheduling =
application. My=20
problem is that I can't figure out what to put in the SQL WHERE =
statement to=20
handle a particular case:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Someone may have scheduled a event to =
last several=20
days, or even weeks. For instance the event could start on April =
15 and=20
last until April 20th. The IDEA is that the scheduler only =
allows=20
the user to VIEW one day at a time. The user selects a date and then I =
query the=20
database to see what events take place on that day (even if they started =
a few=20
days earlier and/or won't end for a few days.) I have no trouble =
selecting=20
the event if it starts or ends on the particular day in question, but I =
don't=20
know how to handle events that last a few days (esp. when the user is =
trying to=20
view a day that is in the middle of several day event.)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>My table (in an MS Access 2000 =
database) has these=20
fields: </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Start_Date_Time,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>End_Date_Time,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Name_Of_event</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Can anyone give me any ideas on how to =
SELECT these=20
events?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank You,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Eron</FONT></DIV></BODY></HTML>
------=_NextPart_000_0015_01BFAB26.1C358640--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
