Extracting results from SELECT count(*) query

[Ryan Breed]

I'm trying to determine the size of a table with the following code:

stringstream ssCountRecordsQuery;

ssCountRecordsQuery << "SELECT COUNT(*) FROM " << m_pszDatabaseName;
ssCountRecordsQuery << "." << m_pszTableName << ";";

auto_ptr< Statement > pCountRecordsStatement(m_pzConnection->m_pConnection->createStatement());

try
{
auto_ptr<ResultSet> results(pCountRecordsStatement->executeQuery(ssCountRecordsQuery.str()));
int nRecordCount = results->getInt(0);
}

I've tried all flavors of get* to extract the results, which I believe will be in the form of a single column named count(*) with a single numerical (integer?) result. As none of these have worked I'm wondering if I'm going about this incorrectly.

I've also tried getInt("COUNT(*)")

I've also tried getInt(1).

Can someone please assist?

Thanks in advance,
Ryan