[sqlalchemy] bindparams fails for the table

2014-05-15 Thread google
Hi, my program tries to read data from a configurable, unknown user table. So I came up with such a statement: result = self.session.execute(SELECT * FROM :mytable, {mytable: self.table}) But when I run it, I get this, what I do not understand: result = self.session.execute(SELECT

Re: [sqlalchemy] bindparams fails for the table

2014-05-15 Thread Michael Bayer
a SQL statement cannot use a bound parameter as a substitute for SQL identifiers, such as table and column names. that is, this is not valid: conn.execute(select * from :table, table='foo') bound parameters are only intended for literal values used in SQL expressions, that is, the *data*, not