TableHandlingADO

The TableHandlingADO component, which appears in the Handling stage of an order processing pipeline, sets the value of _handling_total on the order form by using values retrieved from the database.

• υKey. (Read-only) The name of a property on the order form used to specify handling method. The value of this property is compared to the string specified in the Method field to determine whether to apply the handling charge to the order.
• υApply when. Specifies when to apply the handling charge.
  • υEqual to Method. Specifies that the handling charge should be applied if the value of the field specified for Key is the same as the string specified in the Method field.
  • υHas Any Value. Specifies that the handling charge should be applied when the value of the field specified for Key has any value on the order form. If you select this option, the Method field should be left blank.
  • υAlways. Specifies that the handling charge is always applied to the order.
• υMethod. If Equal to Method is selected, specifies a string that the component compares with the value of shipping_method on the order form to determine whether to apply the handling charge to the order. The handling charge will be applied only if there is an exact match.
• υConnection string. Specifies the connection string used for connecting to the database. The connection string must include either the full connection string (the data source name (DSN), database login ID, and database password) or the name of a named connection stored in the connection map. If this field is blank, the default connection string is used.
• υQuery. Specifies either the full SQL text of the query that is executed by this component or the name of a query whose full SQL text is defined in the site’s global.asa file.
• υParameter List. Specifies the parameters that the component passes to the query. The parameter count passes the query the number of line items on the order. The parameter order.fieldname passes the value of the specified field on the order form. The parameter sum.fieldname passes the query the sum of a particular field on the order, while sumq.fieldname passes the sum times the respective quantities. If multiple parameters are specified, each parameter is separated from the next by a single space.
• υColumn. Specifies the name of the column in the database that contains the handling charge.

Remarks

The combination of the Key, Apply when, and Method fields determine whether the handling charge should be applied to the order.

The TableHandlingADO component first checks the Apply when value. If it is set to Always, the handling charge is always applied to the order. If Apply when is set to Has any value, the handling charge is applied to the order whenever the order form contains any value for shipping_method. If Apply when is set to Equal to Method, the component does a comparison between the value of shipping_method on the order form and the text string in the Method field on this property page. If there is a match, the handling charge is applied.

If the component determines that the handling charge should be applied, it then executes the query specified in Query, which retrieves the handling charge from the database column specified in Column. The component then computes the handling charge.

Related Topics

• υComponent Coordination