Duncan I Loxton wrote:
>
> SELECT *
> FROM LibraryBooking
> WHERE lib_item = #attributes.lii_id#
> AND (
> (lib_StartDate >= #startDate# AND lib_StartDate <= #startDate#)
> OR
> (lib_EndDate >= #endDate# AND lib_EndDate <= #endDate#)
> )
Presuming you have already validated that #startDate# < #endDate#
and lib_StartDate < lib_EndDate:
SELECT *
FROM LibraryBooking
WHERE
lib_item = <cfqueryparam cfsqltype="cf_sql_integer"
value="#attributes.lii_id#">
AND NOT (
lib_StartDate <= <cfqueryparam cfsqltype="cf_sql_date"
value="#endDate#">
AND
lib_EndDate >= <cfqueryparam cfsqltype="cf_sql_date"
value="#startDate#">
)
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
This list and all House of Fusion resources hosted by CFHosting.com. The place
for dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189315
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
