[Zope-DB] Sybase ASA, ZODBC and sum() expression in query

Dieter Maurer dieter@handshake.de
Fri, 27 Jun 2003 01:13:38 +0200


Maciej Wisniowski wrote at 2003-6-26 08:28 +0200:
 > I have a problem with Sybase Adaptive Server Anywhere 8 database and ZODBC
 > Database Connection  (ZODBCDA product version: 3.0.3).
 > ...
 > Now I'm trying this query:
 >           'select sum(col1), sum(col2), sum(col3) from testSumy group by
 > miesiac'
 > 
 > It works OK in Sybase's ISQL, but when run from Zope ZSQL Method it returns
 > nothing...

I would be extremely surprising if this were a Zope problem.

However, the ZODBCDA is known to be quite buggy, maybe this
is another bug?

Try "ZmxODBCDA".


Dieter