Restricting quantity based on number of items in stock?
We have a field in our product database that details the number in stock of a particular product.
Is it possible to restrict the quantity selected by a user, based on this stock number? For example, if a user attempts to purchase 5 of an item, which only has 1 showing as in stock, an error would be produced informing them of the quantity available.
Sorry, I should add that I don't need the purchasing process to update the stock level, I just need to restrict the quantity, availabile to purchase, based on the stock level.
We're using Classic ASP btw.