Re: [sqlalchemy] SQL Server 2005 + pyodbc + Stored Procedure

2014-04-05 Thread Aniruddha
Thanks for reply. I checked the link it says if stored procedure end with select statement, it will solve problem. In my stored procedure, I am passing XML data, getting all values from that xml put into temp table. CREATE PROCEDURE MY_PROC @empID char(10), @oldEmpList XML,

[sqlalchemy] Strange bevahvior with Association Object - Explanation?

2014-04-05 Thread Christian Kastner
Hi, I have a many-many relationship implemented as an Association Object. When I add an association between a parent and a child, the list of associations within the parent contains the child element twice. A flush() does not help, but commit() resolves the issue. The generated SQL only creates

Re: [sqlalchemy] SQL Server 2005 + pyodbc + Stored Procedure

2014-04-05 Thread Michael Bayer
On Apr 5, 2014, at 3:23 AM, Aniruddha anierud...@gmail.com wrote: Thanks for reply. I checked the link it says if stored procedure end with select statement, it will solve problem. In my stored procedure, I am passing XML data, getting all values from that xml put into temp table.

Re: [sqlalchemy] Strange bevahvior with Association Object - Explanation?

2014-04-05 Thread Michael Bayer
On Apr 5, 2014, at 8:14 AM, Christian Kastner debian.kvr...@gmail.com wrote: Hi, I have a many-many relationship implemented as an Association Object. When I add an association between a parent and a child, the list of associations within the parent contains the child element twice. A

[sqlalchemy] postgis samples problem (AttributeError: 'module' object has no attribute 'Function')

2014-04-05 Thread robert rottermann
Hi there, I try to run the sample at: http://docs.sqlalchemy.org/en/rel_0_9/_modules/examples/postgis/postgis.html but I get the following traceback: Traceback (most recent call last): File scripts/test_geom.py, line 18, in module class BinaryGisElement(GisElement, expression.Function):

Re: [sqlalchemy] Strange bevahvior with Association Object - Explanation?

2014-04-05 Thread Christian Kastner
On 2014-04-05 16:58, Michael Bayer wrote: On Apr 5, 2014, at 8:14 AM, Christian Kastner debian.kvr...@gmail.com wrote: I have a many-many relationship implemented as an Association Object. When I add an association between a parent and a child, the list of associations within the parent

Re: [sqlalchemy] postgis samples problem (AttributeError: 'module' object has no attribute 'Function')

2014-04-05 Thread Michael Bayer
fixed in r4527b6ab943b0f16dd3dd829d7e9872. On Apr 5, 2014, at 12:35 PM, robert rottermann rob...@redcor.ch wrote: Hi there, I try to run the sample at: http://docs.sqlalchemy.org/en/rel_0_9/_modules/examples/postgis/postgis.html but I get the following traceback: Traceback (most recent