Pdo And Rowcount With Obdc Driver

[MIPS64]

I am struggling to return a row count for a query I have to run on a database using OBDC connection to a MSSQL server. I can get row counts just fine with MySQL. I know the query works because I can run it on the MSSQL server with no problem.

 

When I echo the result I get -1. I am not sure what that means.

 

$sth = $dbh->prepare("
SELECT PatronID
FROM Patrons
WHERE Barcode = :barcode
");
$sth->bindParam(':barcode', $barcode);
$sth->execute();
$count = $sth->rowCount();

echo $count;

 

EDIT: I can echo the PatronID just fine. Just not retrieve the row count.

Edited October 19, 2012 by MIPS64

[scootstah]

From the manual:

For most databases, PDOStatement::rowCount() does not return the number of rows affected by a SELECT statement. Instead, use PDO::query() to issue a SELECT COUNT(*) statement with the same predicates as your intended SELECT statement, then use PDOStatement::fetchColumn() to retrieve the number of rows that will be returned. Your application can then perform the correct action.

 

So, you can either run two queries or you can count() the result set.

Edited October 19, 2012 by scootstah