A suggestion is to when the user selects the
room/item is to mark the record as being taken,
and with a date/time.
Thus not available for someone else.
Then I would run a clean up file to unmark those
checked after say 20 minutes or so.
Maybe a scheduled task every hour
-----Original Message-----
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 7:06 AM
To: CF-Talk
Subject: Re: concurrency problem..
I have somewhat of the same issue... In my shopping cart which show live
inventory available, stock is check before you put the item in the cart.
And then again during a transaction which puts the item in your order. But
there is the possibility that someone will have ordered the last widget
AFTER the inventory check, but BEFORE the actual decrement of inventory.
How does everyone handle this?
> hi ppl... i have a hotel booking system that lets the users to reserve
room thru the web.
> I retrieve the hotel room capacity to show the current room available...
if the capacity is zero.. the page will indicate fully booked.
> In order to have the most updated info..
> i actually retrieve the room capacity again from the database juz before
updating...
> but seems still have slight chance to have multiple submission at microsec
difference...
>
> i thinking of using CFLOCK to contain the read,update queries..
> however.. at the admin module... i have a function that enable the
administrator to update the total room capacity...
> so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only
locks requests from same page...)
>
> Any advice??
>
> heard that i can use stored procedure from the DB to "lock" the table...??
> i never use stored procedure b4... so any kind soul can kindly guide me to
some examples or website where i can learn??
>
>
> thanx in advance...
>
> han
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
