You might consider a status field. Something to the effect that the item is still available, but may be dedicated to a cart. If in 72 hours or whatever, it is still in the "Shopping Cart" the return it to the pile.
-----Original Message----- From: stas [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 10:59 AM To: CF-Talk Subject: Dealing with inventories Hello, I am trying to figure out how to deal with updating the inventory in a shopping cart. I create (only if it doesn't already exist) an application scoped array within a CFLOCK populated by looping over a query. As users add items, I update the quantities in the that array. What I can't figure out is how to deal with abandoned shopping carts - how do I update the inventory back to the real value? ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists