Do like Ticketmaster and allow 10 minutes to complete the transaction or the site goes back to the available inventory list. Dell does something similar with their refurb computers. If you add it to your cart and leave, after a timeout, it goes back to the inventory.
-----Original Message----- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 5:32 PM To: CF-Talk 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!!!! ++++++++++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++++++++++ ************************************************************************ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ************************************************************************ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200599 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

