When I print a select statement, my bindparams show as %s instead of as named params. What could be the cause of this?
>>> myparam BindParameter('myparamname', 'hello', type_=Unicode()) >>> print(table.c.colname == myparam) table.colname = :myparamname >>> print(select([table.c.colname]).where (table.c.colname == myparam)) SELECT table.colname FROM table WHERE table.colname = %s I tried to construct a toy example and couldn't reproduce my issue. So if this doesn't prompt any ideas, I'll work to reduce my repeatable example to something minimal and postable. The reason this is important to me is that the %s hid a mistake I made in assigning the same name to two bindparams that should have had different values. This caused the actual value that was used during execution to be selected arbitrarily and produce undesirable results. Note that if I compiled with literal binds and executed, then I always got both distinct values (probably due to it using positional args) and received desireable results. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.