[sqlalchemy] mssql, pyodbc and rowcount

2008-05-01 Thread Saibot
Hi, I am using mssql with pyodbc and stumbled over the following behaviour: meta.Session.execute(meta.metadata.tables.get(table).select()).rowcount -1 Can anybody explain what I have to do (if possible at all) to get the correct number of rows in my cursor? Thanks in advance, Tobias

[sqlalchemy] Re: Reflecting tables, Unicodecolumnames and orm.mapper()

2008-04-24 Thread Saibot
) UnicodeDecodeError: 'utf8' codec can't decode bytes in position 6-7: invalid data On 23 Apr., 15:07, Michael Bayer [EMAIL PROTECTED] wrote: On Apr 23, 2008, at 3:50 AM, Saibot wrote: mapper.py, line 669, in _compile_property    setattr(self.class_, key, Mapper._CompileOnAttr(self.class_, key

[sqlalchemy] Reflecting tables, Unicodecolumnames and orm.mapper()

2008-04-23 Thread Saibot
Hi, i was reflecting mssql tables with german umlauts in their columnsnames and got an error, mapping these tables to classes: File c:\TTL\ttl\model\__init__.py, line 24, in init_model orm.mapper(MLFB, t_mlfb) File c:\python25\lib\site-packages\sqlalchemy-0.4.4-py2.5.egg