User Guide

Shopping Cart Reference 207
Insert adjustments from [ShoppingCart] in [Recordset] when
[button] is clicked using OrderID from [ASPServer]
Similar to its Hidden Form Element counter part, this contract is an interaction
between a basement ShoppingCart element, a submit button, an ASPServer
object and the destination Recordset for the Cart adjustments. When the button
is clicked, the shopping cart adjustments are inserted into the orders database
using the OrderID stored in the ASPServer, where each cart adjustment will
become a record in the recordset.
Check out DrumNote_503 for an example of this contract in action.
Note that this contract can be used in conjunction with contracts that generate an
OrderID needed for an OrderAdjustments record (such as the 'Insert order in
[recordset]...' and "Replace [token] in [target] with unique OrderID contracts").
When the button is clicked, the shopping cart adjustments data is inserted into
the recordset where each adjustment is a single record in an Order Adjustments
recordset. The "Go To Page" parameter allows you to redirect to the specified page
after the insert is completed.
Note: This contract should be executed before the "Insert cart in Recordset" contract is
executed because the latter contract destroys the cart and its associated cookie.
Parameters:
OrderIDCol is the name of the OrderID column in the target recordset.
AdjustmentNameCol is the name of the column in the recordset that stores the
adjustment name
AdjustmentValCol is the name of the column in the recordset that stores the
adjustment value
VariableName is the name of the session variable that contains the OrderID
Participants:
ShoppingCart
Recordset
ASPServer basement Session element
Button (any clickable object)