[Zope] database functions & zope

[Stephen Nosal]

Folks -

How do I execute SQL statements such as select count(*) from db_table?

I'm running zope 2.2 with the SybaseDA 2.0b2. My connection to the database works fine, ie select * from small_table where amount>1000 produces a valid result set.

Using just the DA connection test, the statement select count(*) from db_table comes up with the error:

Error Type: ValueError
Error Value: Empty column name,

Any insight here would be great - I couldn't find anything documented about database functions.

- Steve


__________________________________________________________________
Get your Private, Anti-Spam, Free Email at http://e3mil.com 
and Step into a Friendly Universe!