Adobe ColdFusion 8

getRowCount

Description

Retrieves the number of rows in a query.

Returns the number of rows contained in a query.

Category

Query interface

Syntax

public int getRowCount()

Example

The following example retrieves the number of rows in a query and writes it back to the user:

Query query = request.getQuery() ;
    int rows = query.getRowCount() ;
    response.write( "The number of rows in the query is " 
    + Integer.ToString(rows) ) ;