Thanks for the response, I initially tried that, it doesnt seem to work for multiple statements or my syntax is wrong. I need to be row specific because often i split the rows into more than one new word_id.
Originally I tried this statement in several different ways and it didnt work... nuc_word_table.update(nuc_word_table.c.word_id==old_word_id, nuc_word_table.c.nuc_word_seq_num==oligo1 ).execute(word_id=new_word_id) I get the following error, File "splitTables_44.py", line 270, in ? nuc_word_table.c.nuc_word_seq_num==oligo1 File "build/bdist.solaris-2.9-sun4u/egg/sqlalchemy/sql.py", line 1303, in update File "build/bdist.solaris-2.9-sun4u/egg/sqlalchemy/sql.py", line 103, in update File "build/bdist.solaris-2.9-sun4u/egg/sqlalchemy/sql.py", line 1609, in __init__ File "build/bdist.solaris-2.9-sun4u/egg/sqlalchemy/sql.py", line 1576, in _process_colparams AttributeError: 'BooleanExpression' object has no attribute 'keys' --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---