Re: [sqlalchemy] order_by: ArgumentError

2010-11-17 Thread Enrico Morelli
On Tue, 16 Nov 2010 11:37:12 -0500 Michael Bayer mike...@zzzcomputing.com wrote: On Nov 16, 2010, at 6:16 AM, Enrico Morelli wrote: On Mon, 15 Nov 2010 15:56:06 -0500 Michael Bayer mike...@zzzcomputing.com wrote: its looking for a Column object.menus_table.c.weight instead of

Re: [sqlalchemy] order_by: ArgumentError

2010-11-16 Thread Enrico Morelli
On Mon, 15 Nov 2010 15:56:06 -0500 Michael Bayer mike...@zzzcomputing.com wrote: its looking for a Column object.menus_table.c.weight instead of 'weight'. Thanks, I modified the query: main_menu = Session.query(Menu).filter(and_(Menu.parent_id==None,

Re: [sqlalchemy] order_by: ArgumentError

2010-11-16 Thread Michael Bayer
On Nov 16, 2010, at 6:16 AM, Enrico Morelli wrote: On Mon, 15 Nov 2010 15:56:06 -0500 Michael Bayer mike...@zzzcomputing.com wrote: its looking for a Column object.menus_table.c.weight instead of 'weight'. Thanks, I modified the query: main_menu =

[sqlalchemy] order_by: ArgumentError

2010-11-15 Thread Enrico Morelli
Dear all, I've a lot of applications using SA 0.5.6. Now I upgraded my personal computer and now I can use SA 0.6.5 but my applications stops to work. I receive the error: ArgumentError: Column-based expression object expected for argument 'order_by'; got: 'weight', type type 'str' I try to

Re: [sqlalchemy] order_by: ArgumentError

2010-11-15 Thread Michael Bayer
its looking for a Column object.menus_table.c.weight instead of 'weight'. On Nov 15, 2010, at 10:03 AM, Enrico Morelli wrote: Dear all, I've a lot of applications using SA 0.5.6. Now I upgraded my personal computer and now I can use SA 0.6.5 but my applications stops to work. I