I tested it with a test paypal acct. I had in products database
only 1 of a particular item. I bought it. But then when I ran project
again, it was still there. I checked the database and it had not been taken out of the products database, although it had been added to the orders database. How would I go about updating that products database? I guess there needs to be a sql statement in the project somewhere?

Rachel

There's already a method that decrements the units in stock for a product.

In the order completion page, the order is retrieved from the ID on the querystring. If the StatusID of the order is "1", then that means the order is "waiting for payment". Then, the order is marked "confirmed", and the order is updated, during which the UnitsInStock for the product should be decremented by 1.

P.S. There are actually a couple of forums dedicated to questions about TheBeerHouse:

http://p2p.wrox.com/forum.asp?FORUM_ID=261

http://forums.asp.net/1115.aspx

_________________________________

Visit my blog at http://leedumond.com

Thanks. Maybe it didn't update because it wasn't showing as paid.
I'll check out those other forums. I didn't know about them. Thanks.
Rachel