[Zope] Re: SyBaseDA and select count problem

[Christopher Petrilli]

On 1/7/00 4:02 PM, Bill Anderson at banderson@boi.hp.com wrote:

> Bill Anderson wrote:
>> 
>> 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?
>> 
> 
> 
> 
> nevermind .. I found one ...
> *doh*

In case it was the wrong one :-)

select count(*) as result from <table>

All returned values must have a column name to bind to :-)

Chris
-- 
| Christopher Petrilli        Python Powered        Digital Creations, Inc.
| petrilli@digicool.com                             http://www.digicool.com