SQLOrder

The SQLOrder component runs a SQL query once per order, passing the specified order parameters to the query.

Note  The SQLOrder component is included in Commerce Server 3.0 only for backward compatibility with sites created in Commerce Server 2.0, in which the database connection is provided by the Content object. Commerce Server 3.0 sites should use the SQLOrderADO component.

• 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 stored in the Content object.
• Parameter List. Specifies the parameters that the component passes to the query. If multiple parameters are specified, each parameter is separated from the next by a single space. 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.