ResultSetIsLimited

Description

Returns a Long that indicates whether or not the result set is limited. Returns the number of rows to be returned if the ResultSet object execute is limited, or 0 (zero) if not limited.

This method is available following a call to the ResultSet object Execute method, and can be used with the EnableRecordCount and GetRecordCount methods.

Note: This method became available in version 7.1.

Syntax

VBScript

resultset.ResultSetIsLimited

Perl

$resultset->ResultSetIsLimited();

Identifier: Description
resultset: A ResultSet object, representing the rows and columns of data resulting from a query.
Return value: Returns a Long that represents the number of rows the ResultSet object is limited to; Returns 0 (zero) if the ResultSet is not limited.

Example

Perl

# Alert the caller about the data truncation: 
$ResultSet->EnableRecordCount();
$ResultSet->Execute ();
My $limited_rs = $ResultSet->ResultIsLimited();
My $recs = $ResultSet->GetRecordCount();
If ($limites_rs) print "ResultSet limited to $recs rows!\n";