--On 16. Mai 2008 18:06:46 +0200 Andreas Jung <[EMAIL PROTECTED]> wrote:
--On 16. Mai 2008 08:58:38 -0700 Mike <[EMAIL PROTECTED]> wrote:Hi, We are using SQLAlchemy 4.X in Zope using SQLAlchemyDA, found here: http://opensource.zopyx.com/projects/SQLAlchemyDA This uses SA 0.4.0. We are connecting to MS SQL 2000. While this works in Zope for normal SQL commands, if we try to execute a stored procedure, we get the following traceback: [Traceback (most recent call last): File "sqltest.py", line 14, in ? print cur.fetchall() File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/ SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1231, in __repr__ return repr(tuple(self)) File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/ SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1223, in __iter__ yield self.__parent._get_col(self.__row, i) File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/ SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1468, in _get_col rec = self._key_cache[key] AttributeError: 'ResultProxy' object has no attribute '_key_cache' I'm not sure how to go about troubleshooting this.You're basically on the wrong list. This issue belong on the SQLAlchemy mailing list. There is no indication for a anything related to Zope.
Sorry, you're on the right list. Somehow I saw this mail in the context of the Zope lists. Andreas
pgpIslnSPgDzR.pgp
Description: PGP signature