SQLOrderADO

The SQLOrder component runs a SQL query once per order, passing the specified order parameters to the query. The SQLOrderADO component uses ActiveX™ Data Objects (ADO) to interface with the data source, and therefore supports Microsoft® Transaction Server (MTS) transactions.

• 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. 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. 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.
• Child Object Name. Specifies the name of a field to which the data is written. The component uses the specified field only if the Use Child Object check box is selected.
• Use Child Object. Specifies whether the component is to use the object specified in the Child Object Name field. If the check box is not selected, the component assumes that no child object exists.