[Zope] SyBaseDA and select count problem

[Rob Page]

> It seems that whenever I try to use any of the following:
> select count(*) from <tablename>
> select count(<columnname>) from <tablename>
> 
> it returns:
> "Error, exceptions.ValueError: Empty column name, "
> 
> Of course, the sql is tested and known to work.
> 
> Any clues here?

try

SELECT COUNT(column) AS some_number FROM tablename

--Rob