SQLItemADO

The SQLItemADO component runs a 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.

• 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 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.