SQLItemADO
Use this component to run a query for each item in an order form.
Intended use: Order Processing pipeline, Accept stage.
Configuration Values
You can determine the query the SQLItemADO component runs by setting component properties. Use the following boxes on the SQL Item (ADO) tab of the Component Properties dialog box to determine this information.
| Box | Description |
|---|---|
| Connection String | The connection string to connect to the database. This may be a full connection string or a name in a connection map. If blank, the default connection string is used. |
| Query | The full SQL text of the query this component will run, or the name of a query whose full SQL text is defined in the Global.asa file in the QueryMap key. |
| Parameter List | The parameters the component passes to the query. Separate multiple parameters with a single space. The following are the allowed parameters:
|
Values Read
The SQLItemADO component reads the following values from the indicated dictionaries.
| Key | Dictionary | Description |
|---|---|---|
DefaultConnectionString |
Context | Optional. The key in the Application dictionary containing the default query string. |
ConnectionStringMap |
Context | Optional. The map in which to look up the name of a mapped connection string. |
QueryMap |
Context | Optional. A reference to a dictionary containing a query map. |
Values Written
None.
Remarks
The SQLItemADO component runs a query for each item in the items list, passing the specified order form fields as parameters to the query. These fields can include keys from either the Order or the Item dictionary.
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.
Copyright © 2005 Microsoft Corporation.
All rights reserved.