On May 16, 11:06 am, 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.
>
I'm confused. This IS the SqlAlchemy list...
> > Would upgrading it
> > to SQLAlchemy 0.4.5 fix it?
>
> Try it out yourself and see what's happening. Nobody know about your
> particular setup, code etc. - but you do.
>
> Andreas
>
We did end up trying it soon after posting and it works now. Sorry to
bother you.
Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
