What is is transact or PL? I'm afraid I have not herd this term.
-----Original Message-----
From: JME Maxwell [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2001 12:52
To: Fusebox
Subject: RE: sql date functions
Are you able to use transact or PL?
-----Original Message-----
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 3:35 AM
To: Fusebox
Subject: sql date functions
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
