[mv] Don't Know How To Title This Question

[OTR Comm <otrcomm@isp-systems.com>]

Hello,

I want to put up a gallery with one-of-a-kind pieces.

What I want to be able to do is setup a system where when a customer
selects to buy an item, everyone else who goes into the gallery sees a
'Sale Pending' notice for that particular item.  In other words, I do
not want multiple customers trying to purchase the same piece.

Then, if the customer who has the piece under 'Sale Pending' does
purchase the piece, the notice will change to 'Sold' when the page is
re-displayed.

The only way that I can figure out how to do this is by having code at
the start of the page where this item lives that checks a switch in a
database.  If the switch is not set, then the item is available for
purchase.  If someone puts the item in their cart, the switch is then
set and anyone else who comes to the page will not have the item
available (i.e., Sale Pending).  These customers will be told to
periodically check back at the page to see if the sale went through.  If
the sale does go through, then the notice will say 'Sold', if not then
the item will be available.

Does this make sense?  Has anyone ever done this? Am I off base with the
database switch approach?  Would the inventory database work for this? 
I have never worked with the inventory database, so I do not know.

Any ideas/solutions would be appreciated.

Thanks,
Murrah Boswell


_______________________________________________
Minivend-users mailing list
Minivend-users@minivend.com
http://www.minivend.com/mailman/listinfo/minivend-users