This is the same scenario as a concert or sports ticketing system where you purchase reserved seats.
In most of these systems they reserve the ticket as soon as you indicate you wish to buy it. If you don't complete the transaction then it becomes available once again after X minutes - usually something like 5 to 15 minutes, whatever is reasonable for completing the checkout process, but also depending on demand. For a campsite ticketing system, I doubt you'd have to worry about making the time period too long. Go to ticketmaster.com and begin the purchase of some tickets - I believe the system shows you how long you have to complete the purchase before the tickets are released. ----- Original Message ----- From: "Parker, Kevin" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, March 29, 2005 5:32 PM Subject: Is this campsite available > I'd be most grateful for a little bit of advice from this list please. > > I am working on a campsite booking system. The main issue of course is > that unlike an item in a shop, any given campsite is only available once > on any given day. > > Here's a likely scenario... > > User A indicates that he wants Campsite 1 for Day X. He is then moved > through to the payment system and payments is processed and the booking > is recorded in the system. Campsite 1 is now not available for Day X to > anyone other than User A. > > That works fine. However, along comes User B who also picks Campsite 1 > for Day X before User A's payment is processed. We could deal with this > by placing a reserved flag on Campsite 1 as soon as User A indicates he > wants it which precludes User B from selecting it. If User A's payment > is rejected then we unreserve Campsite 1. > > However, what happens if User A does not actually complete the > transaction (as opposed to it being rejected) We now have a campsite > sitting there with a reserved lock on it but no booking. > > Any clues on strategy greatly appreciated!!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
