OVERLAPS isn't a valid MSSql2K TSQL command. I looked it up in the MSSQL
Books online.
Steve
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 3:38 PM
To: CF-Talk
Subject: Re: Date Range Query Issues
Mickael wrote:
>
> Could you show me a statement where that is used, it sounds interesting
just don't know how it is used.
Instead of
SELECT x
FROM yourtable
WHERE startDateField < '#formEndDate#'
AND endDateField > #formStartDate#'
one would use:
SELECT x
FROM type = 'checktype'
AND (startDateField, endDateField) OVERLAPS
('#formEndDate#', #formStartDate#')
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]