Hi all, can anyone help me with this. I am building a hotel bookings site
in coldfusion.
If a room is booked from dateA to dateB I make a record in
#Dateformat(dateA, dd-mm-yy)#, #Dateformat(dateB, dd-mm-yy)# and room, time
etc.
There does not seem to be a sql function in coldfusion that will allow me to
determine if someone else trys to book the same room starting before DateA
and ending between both dateA and dateB.
Ok now I know I could build a second database table and do a 'select not
in', but it would not be as effective I feel.
Cheers
Jonny
Derry Northern Ireland
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
