I upgraded to 0.3.6 from 0.3.5 and one of my querys stopped working: s = model_table.select(~(model_table.c.therapeutic_area.in_('Respiratory','Diabetes', 'Inflammation','CVD')), order_by=[model_table.c.model_acronym])
All my other query still work fine. Although this is the only one using in_() and "~". The funny thing is that the created sql appears to be exactly the same as before. Here is the error: 2007-03-26 15:11:20,851 INFO sqlalchemy.engine.base.Engine.0x..d0 SELECT model.i nvestigator_isid, model.active, model.model_id, model.model_acronym, model.model _name, model.therapeutic_area FROM model WHERE model.therapeutic_area NOT IN (:model_therapeutic_area, :model_therapeutic _ar_1, :model_therapeutic_ar_2, :model_therapeutic_ar_3) ORDER BY model.model_ac ronym 2007-03-26 15:11:20,851 sqlalchemy.engine.base.Engine.0x..d0 INFO SELECT model.i nvestigator_isid, model.active, model.model_id, model.model_acronym, model.model _name, model.therapeutic_area FROM model WHERE model.therapeutic_area NOT IN (:model_therapeutic_area, :model_therapeutic _ar_1, :model_therapeutic_ar_2, :model_therapeutic_ar_3) ORDER BY model.model_ac ronym 2007-03-26 15:11:20,861 INFO sqlalchemy.engine.base.Engine.0x..d0 {'model_therap eutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', 'model_therapeutic_ ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} 2007-03-26 15:11:20,861 sqlalchemy.engine.base.Engine.0x..d0 INFO {'model_therap eutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', 'model_therapeutic_ ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} 2007-03-26 15:11:20,861 INFO sqlalchemy.engine.base.Engine.0x..d0 ROLLBACK 2007-03-26 15:11:20,861 sqlalchemy.engine.base.Engine.0x..d0 INFO ROLLBACK Traceback (most recent call last): File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt-project \start-sr t.py", line 23, in ? from srt.controllers import Root File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt-project \srt\cont rollers.py", line 9, in ? model_list = [('Respiratory',[('','Please select a model')] +dbmodel.model_li st('Respiratory')), File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt-project \srt\mode l.py", line 158, in model_list rs = s.execute() File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\sql. py", line 776, in execute return self.compile(engine=self.engine, parameters=compile_params).execute(* multiparams, **params) File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\sql. py", line 669, in execute return e.execute_compiled(self, *multiparams, **params) File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\engi ne\base.py", line 726, in execute_compiled return connection.execute_compiled(compiled, *multiparams, **params) File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\engi ne\base.py", line 503, in execute_compiled proxy(str(compiled), parameters) File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\engi ne\base.py", line 499, in proxy self._execute_raw(statement, parameters, cursor=cursor, context=context) File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\engi ne\base.py", line 547, in _execute_raw self._execute(cursor, statement, parameters, context=context) File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg \sqlalchemy\engi ne\base.py", line 566, in _execute raise exceptions.SQLError(statement, parameters, e) sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-01460: unimplemented or unre asonable conversion requested 'SELECT model.investigator_isid, model.active, model.model_id, model.model_acro nym, model.model_name, model.therapeutic_area \nFROM model \nWHERE model.therape utic_area NOT IN (:model_therapeutic_area, :model_therapeutic_ar_1, :model_thera peutic_ar_2, :model_therapeutic_ar_3) ORDER BY model.model_acronym' {'model_ther apeutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', 'model_therapeuti c_ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---