Looking at the doc for 0.4 I see that I should be able to do this: result = engine.execute("select username from users") ... do something with the result result.close()
But I am getting the following exception. Note that I am using Firebird SQL and the firebird.py is the one patched by Roger. Am I doing something wrong or is this not supported in 0.4? BTW, I would like to use this within a custom type ("class MyType(types.TypeDecorator):" to do the I18N translation similar to what Karsten suggested in another thread. Best regards Werner Traceback (most recent call last): File "sai18Test.py", line 15, in <module> for entry in session.query(model.Test_i18n): File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\query.py", line 619, in __iter__ return self._execute_and_instances(context) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\query.py", line 624, in _execute_and_instances return iter(self.instances(result, querycontext=querycontext)) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\query.py", line 680, in instances self.select_mapper._instance(context, row, result) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\mapper.py", line 1436, in _instance self.populate_instance(context, instance, row, **flags) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\mapper.py", line 1517, in populate_instance p(instance, row, ispostselect=ispostselect, isnew=isnew, **flags) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\strategies.py", line 77, in new_execute instance.__dict__[self.key] = row[self.columns[0]] File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\engine\base.py", line 1580, in __getitem__ return self.__parent._get_col(self.__row, key) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\engine\base.py", line 1386, in _get_col return rec[1](row[rec[2]]) File "c:\downloaded software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\types.py", line 46, in process return self.convert_result_value(value, dialect) File "C:\Dev\BoaTest04\sqlalchemy\modelTest.py", line 16, in convert_result_value result = engine.execute("select output1 from t(?, ?)", ('some new text here ddd', 'wbruhin')) AttributeError: 'FBDialect' object has no attribute 'execute' --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---