Jason,

> It is not intended behavior. I think what it should do is impose a fetchall
> or raise an exception that it cannot determine the count.

I assume you do a select count(*) to count the rows.

If the query selects just one column (as is often the case with
distinct), perhaps you could use

select count (distinct fieldname) from table where ...

Why SQL does not allow this syntax with more that one column, I ignore.
Ciao
--
____
_/\/ando