Hi guys,
I need to find out if a date range entered overlaps a date range currently in the database.
the database currently stores the date time for start and finish of the range, and the user
enters a desired start and finish.
something like
if the database contains
startDate finishDate 3/06/2004 10:00:00 AM 3/06/2004 11:00 AM
and the user enters startDate finishDate 3/06/2004 10:00:00 AM 3/06/2004 10:30 AM
I need to alert the user that there is an overlap in the data.
I want to do this in the SQL, but i am stumped on how. :( Does anyone have any idea. I am using MySQL 4.1.1
Thanks Ricardo.
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
