What I'm wanting is all dates between the range and any matching events in
the database. For my example the record set would be something like
ID | Date | Event
---+------------+-------------------
1 | 01/15/2004 | NULL
2 | 01/16/2004 | NULL
...
10 | 01/26/2004 | Mom's Birthday
11 | 01/27/2004 | NULL
...
19 | 02/04/2004 | Doctor's Appointment
Basically I want to do a left outer join with a calendar.
Hatton
> -----Original Message-----
> From: Eric Creese [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 29, 2004 11:34 AM
> To: CF-Talk
> Subject: RE: Calendar query?
>
> simplistically in SQL
>
>
> SELECT date,event
> FROM events
> WHERE date BETWEEN '1/14/2004' AND '2/16/2004'
>
>
>
> -----Original Message-----
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 29, 2004 10:33 AM
> To: CF-Talk
> Subject: Calendar query?
>
>
> Does anyone know of a way to create a query with a range of
> dates and any matching records that might match in a database
> in one query? For example, if I'm looking at a table that
> has the following:
>
> ID | Date | Event
> ---+------------+-------------------
> 1 | 01/01/2004 | New Years Day
> 2 | 02/14/2004 | Valentine's Day
> 3 | 01/26/2004 | Mom's Birthday
> 4 | 02/04/2004 | Doctor's Appointment
>
> Say I wanted to show all of the days between 01/15/2004 and
> 02/15/2004 along with any matching events in the database.
> Is there a way to do this with one query? So far the only
> two ways that I can see doing it otherwise is to loop through
> the date range and perform individual queries... Which IMO is
> a little inefficient.
>
> Any ideas?
>
> Thanks!
> Hatton
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004
> _____
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
