Previous in Contents Next in Contents

The QueryMap Dictionary

The QueryMap Dictionary object saves multiple query descriptions, including the text of each query, enabling queries to be passed conveniently to OPP components.

The query map is implemented as a Dictionary object, where each name/value pair represents a single query description. Each query description in the query map is also implemented as a Dictionary object that specifies properties of the query.

The query map, named MSCSQueryMap, is created in the Application_OnStart subroutine in your site's Global.asa file.

The following values may be created and specified for each query description. Only one of these values, SQLCommand, is required in a query description; the others are optional. If any of these optional values are not specified, the pipeline component will use the default value shown in the right-hand column in the following table.

Query description value Description
SQLCommand SQL statement to be executed.
ConnectionTimeout Optional. Overrides Microsoft® ActiveX® Data Object's (ADO's) default ConnectionTimeout property for the Connection object for this query.
CommandType Optional. Type of Command object to create for this query. If not specified, the pipeline component will use adCmdText.
MaxRecords Optional. Overrides ADO's default MaxRecords property for the Recordset object used for this query.
CursorType Optional. The value to pass to the CursorType property of the Recordset object when opening the Recordset object. If not specified, the pipeline component will use adOpenForwardOnly.
CacheSize Optional. Overrides ADO's default CacheSize property for the Recordset object when opening the Recordset object.

Related Topics


© 1997-2000 Microsoft Corporation. All rights reserved.