GetAllColumnValues

Description

Returns all column values in the result set as an array of strings (for Perl, a reference to an array of strings).

The result contains a pair of strings for each item:

• The first string of each pair is the column name (in uppercase).
• The second string is the column value.

For example, given a query asking for ID and Headline, a successful result of calling this method would be an array containing four elements:

• "ID"
• "SAMPL00001234"
• "HEADLINE"
• "This is a test"

By returning a pair of strings for each column, you can design code independent of the order of the items in the result set.

The MoveNext parameter controls whether this function calls the MoveNext method before retrieving the data. If there is an error executing the MoveNext method, the return value of GetAllColumnValues is a result array containing one element, the String form of the ErrorFetchStatus value that would have been returned from the MoveNext method. A non-error result will always have an even number of elements in the array.

Syntax

VBScript

resultset.GetAllColumnValues MoveNext 

Perl

$resultset->GetAllColumnValues(MoveNext); 

Identifier

Description

resultset

A ResultSet object, representing the rows and columns of data resulting from a query.

MoveNext

A Boolean that specifies whether or not to call the MoveNext method before retrieving all of the column values for a row in the result set.

Return value

For Visual Basic, a Variant array of strings containing the column names and column values.

For Perl, a reference to an array of Strings containing the column names and column values.