SQLItem

The SQLItem component runs a SQL query for each item in the items list, passing the specified OrderForm fields as parameters to the query. These fields can include name/value pairs from either the order or the item Dictionary.

Note  The SQLItem 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 in the Pipe Context. Commerce Server 3.0 sites should use the SQLItemADO 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 index passes the query the zero-based index number of this line item. The parameter order.fieldname passes the value of the specified field on the order form. The parameter item.fieldname passes the value of the specified field in the item Dictionary.

Remarks

You can pass name/value pairs from the order Dictionary as parameters to both the SQLItem and SQLOrder components. However, these components are not identical in the way that they use these name/value pairs.

The SQLOrder component executes the query that you specify once. This query cannot take parameter values from the items list.

The SQLItem component executes the query for each item in the items list. If you reference a name/value pair on the order Dictionary as a parameter to SQLItem, that name/value pair is passed as a parameter to each execution of the specified query. For example, if you use an INSERT query as the SQL command, and you specify order.order_id as a parameter, and the items list contains nine items, the value of order.order_id will be inserted nine times.