MACROMEDIA DRUMBEAT 2000 ECOMMERCE EDITION, Руководство пользователя, Страница: 212 / 238

Chapter 9 212
Do not create [target] if the quantity of any product in
[OrderDetailsRS] exceeds stock levels in [ProductRS]
Will not show the target participant if any product specified in the
OrderDetailsRS does not have sufficient quantity in stock to fulfill the quantity
ordered. This would typically be used on a button that executes the inventory
adjustment code (see "Update inventory in [ProductsRS] with [OrderDetailsRS]
data when [button] is clicked"), such that if any available stock for any product in
an order was less than the quantity ordered, you would be unable to click the
button and modify the inventory.
This contract assumes an OrderDetails recordset filtered for a specific OrderID
containing a list of products that for a specific order. The contract then iterates
through the list of products in the OrderDetails recordset, gets each product ID
and the order quantity for that product, then looks up the product in the Products
recordset, comparing the order quantity from the OrderDetails recordset with the
UnitsInStock value from the Products recordset. If the order quantity of any
product in the orderDetailsRS exceeds the units in stock from the ProductsRS, the
target participant will not be shown.
Parameters:
OrderDetailQtyCol is the column name of the OrderDetails recordset that
contains the order quantity for a product.
ProductIDCol_OrderDetails is the column name in the OrderDetailsRS that
holds the unique ID of the product.
ProductIDCol_Products is the column name in the ProductRS that holds the
unique ID of the product.
ProductStockLevelCol column is the name in the ProductRS that holds the
number of units in stock of the product.
Participants:
OrderDetailsRS is the recordset containing a list of products and order
quantities for a given order.
ProductRS is the recordset containing product inventory data.
Target (image, button, text element, etc.)