DBStorage.LookupMultipleData Method

DBStorage.LookupMultipleData Method

The LookupMultipleData method retrieves multiple results from the database table. If the data is found, this method creates a SimpleList object that contains OrderForm or Dictionary objects, depending on the ProgID parameter passed to the InitStorage method.

Syntax

DBStorage.LookupMultipleData(Null, Column, Value)

Parameters

Null: This parameter is required for compatibility with Commerce Server 2.0, but is not used.
Column: An array containing the columns to query for the specified values.
Value: An array containing the values that correspond to the column names to use as the basis for the lookup.

Remarks

The Column and Value arrays that you pass to LookupMultipleData share an index-to-index relationship. This means that they must contain an identical number of members, and that the value stored in Value(N) will be searched for in the column specified by Column(N). If the number of elements in Column does not equal the number of values in Value, LookupMultipleData returns Null.