O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Inventory Tracking

The examples in this chapter assume that all items in the Merchandise table are always available for sale. Orange Whip Studios might not need to be concerned about its merchandise ever selling out, but your company probably does. At a minimum, you should probably add an InStock Boolean field to the Merchandise table and ensure that users can’t add items to their carts unless the InStock field is 1. More sophisticated applications might call for maintaining a NumberOnHand field for each item, which gets decremented each time an item is ordered and incremented each time new shipments come in from the supplier.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required