I know this has got to be simple. I am updating "table1" in MySQL.
u = table1.update() u.values(col1=bindparam('_col1'), col2=bindparam('_col2') ... updateVals = [ {'_col1': 5, '_col2': table1.col1 * 5} ] engine.execute(u, updateVals) I was expecting table1.col1 * 5 to show up as: `table1`.`col2` = `table1`.`col1` * 5 But it shows up as: '`table1`.`col1` * %s' in the query log. Note the quotes around the actual result, and the missing 5 value. The 5 is never being placed into the string being sent to the server. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.