RE: [sqlalchemy] Sybase reports conversion from datatype 'CHAR' to 'INT' is not allowed. when using string instead of int for filterby

2010-06-10 Thread Cserna, Zsolt
SQLAlchemy doesn't do type coercion out of the box. Some DBAPIs do, which is why you may have not noticed this issue on other platforms. You can build that functionality yourself using TypeDecorator:

Re: [sqlalchemy] Sybase reports conversion from datatype 'CHAR' to 'INT' is not allowed. when using string instead of int for filterby

2010-06-10 Thread Michael Bayer
On Jun 10, 2010, at 8:51 AM, Cserna, Zsolt wrote: SQLAlchemy doesn't do type coercion out of the box. Some DBAPIs do, which is why you may have not noticed this issue on other platforms. You can build that functionality yourself using TypeDecorator:

[sqlalchemy] Sybase reports conversion from datatype 'CHAR' to 'INT' is not allowed. when using string instead of int for filterby

2010-06-09 Thread Cserna, Zsolt
Hi all, We're trying to use sybase dialect in sqlalchemy, but it creates invalid select parameters when we are trying to use a python-string (or unicode object) variable to specify a sql-int variable. That problem occurs when we use pylons web framework with formalchemy with sqlalchem+sybase

Re: [sqlalchemy] Sybase reports conversion from datatype 'CHAR' to 'INT' is not allowed. when using string instead of int for filterby

2010-06-09 Thread Michael Bayer
On Jun 9, 2010, at 11:27 AM, Cserna, Zsolt wrote: Hi all, We're trying to use sybase dialect in sqlalchemy, but it creates invalid select parameters when we are trying to use a python-string (or unicode object) variable to specify a sql-int variable. That problem occurs when we use