MACROMEDIA DRUMBEAT 2000 ECOMMERCE EDITION, User Manual

Page: 58 / 238

Chapter 1 58
Inserting OrderDate into the Orders Recordset
Set the token in the hidden form element:
1
Right-click the OrderDateHidden element, in the Basement, and select
Attributes.
2
From the drop down list for Content, select Text.
3
Click on the ellipses button to open the text editor.
4
Enter [monthnumber]/[daynumber]/[year] for the tokens. Click OK.
5
Right click and choose Possible Activations. Double click the activation in the
Date category:
OrderDateHidden: Replace tokens in OrderDateHidden with static date/time
from server
6
Now, apply the interaction to insert the order date into the recordset when the
SubmitOrder button is clicked.
7
Shift-select the following elements:
SubmitOrder button (on page)
OrderDateHidden (in Basement)
Orders recordset (in Basement)
8
Right click and choose Possible Interactions. Double click the interaction in
the Database Edit category:
Use OrderDateHidden data to update/insert in Orders when SubmitOrder
is clicked
9
Set the Recordset Column parameter according to the following table, then
click OK.
Calculate Sales Tax, Shipping, and Grand Total
The sales tax, shipping charges, and grand total of the order are calculated at
browse time. The sales tax is determined by the customer’s billing state and the
store state of origin. These variables come from the Customer recordset and the
parameters set in the eStore Tax Interactions. The shipping options are
determined by the item quantity. The shipping cost of the total quantity is set by
the flat rate. The grand total is calculated by adding the subtotal, shipping cost,
and tax (if any).
Parameter Set to:
Recordset Column OrderDate