My sentiments exactly Aaron, and in addition if you want to make the app
more generic to allow for an unknown number of rooms, set your database up
to treat a new room like a new resource. Make a 24 hr. clock available to
each new resource. Use a field in the table for how many units of the
available hours that the resource has consumed and then only display
available hours so no and so on.....
I built a print solution for a company where in a years time 2 people hit
the print button at the same time and created a dead lock about 10 times or
so. It just doesn't happen that often.
----- Original Message -----
From: "JAIME HOI" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 7:57 PM
Subject: Can CF Handle Concurrent Booking
>
> Hi
> I have an application that handles meeting room booking. The booking
is
> based on the day, room and time of the booked period. I have a problem.
How
> do i ensure that , if 2 users went in and booked on the same day, same
room
> and same time slots , Only 1 booking will be accepted. I was thinking of
> using <CFLOCK> but not sure what variable should i locked so that only 1
> booking will go through.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
