Re: [sqlalchemy] getting floats instead of decimals from session.execute

2010-10-14 Thread Michael Bayer
On Oct 13, 2010, at 8:04 PM, Chris Withers wrote: On 13/10/2010 22:37, Michael Bayer wrote: use text() with Numeric(as_decimal=False) I can't quite join the dots on this one... I get passed a bunch of sql to execute, I don't have control over that. Where do I wire in

Re: [sqlalchemy] getting floats instead of decimals from session.execute

2010-10-14 Thread Chris Withers
On 14/10/2010 17:10, Michael Bayer wrote: I get passed a bunch of sql to execute, I don't have control over that. Where do I wire in Numeric(as_decimal=False) and how do I tell where I need to given an arbitrary select as a string of sql? text() is in the docs, including an example of

Re: [sqlalchemy] getting floats instead of decimals from session.execute

2010-10-14 Thread Michael Bayer
On Oct 14, 2010, at 1:35 PM, Chris Withers wrote: On 14/10/2010 17:10, Michael Bayer wrote: I get passed a bunch of sql to execute, I don't have control over that. Where do I wire in Numeric(as_decimal=False) and how do I tell where I need to given an arbitrary select as a string of sql?

[sqlalchemy] getting floats instead of decimals from session.execute

2010-10-13 Thread Chris Withers
Hi All, If I'm doing: session.execute('select some_numeric from some_table') ...how do I get floats back in the result instead of decimals? Chris -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

Re: [sqlalchemy] getting floats instead of decimals from session.execute

2010-10-13 Thread Michael Bayer
use text() with Numeric(as_decimal=False) On Oct 13, 2010, at 10:01 AM, Chris Withers wrote: Hi All, If I'm doing: session.execute('select some_numeric from some_table') ...how do I get floats back in the result instead of decimals? Chris -- You received this message because

Re: [sqlalchemy] getting floats instead of decimals from session.execute

2010-10-13 Thread Chris Withers
On 13/10/2010 22:37, Michael Bayer wrote: use text() with Numeric(as_decimal=False) I can't quite join the dots on this one... I get passed a bunch of sql to execute, I don't have control over that. Where do I wire in Numeric(as_decimal=False) and how do I tell where I need to given an