MACROMEDIA DRUMBEAT 2000 ECOMMERCE EDITION, User Manual

Page: 213 / 238

Shopping Cart Reference 213
Create [target] if the quantity of any product in [OrderDetailsRS]
exceeds stock levels in [ProductRS]
This contract is the opposite of the "Do not create [target] if the quantity of any
product in [OrderDetailsRS] exceeds stock levels in [ProductRS]" contract. It will
only 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 to display a message such as "Cannot fulfill this order."
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 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 is the column 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.)