a SQL query that uses parameters will use ? if the DBAPI uses "qmark" paramstyle which is very common. The actual value that lines up with the ? is part of the "parameters" sequence. The specification for this is at https://www.python.org/dev/peps/pep-0249/#id15 which also links out to paramstyle.
On 05/19/2016 05:27 PM, John Omernik wrote:
I am writing my own dialect, and for some reason, when my application sets a limit via parameter, the query submitted to the back end just has ? in it. Is this an issue with the dialect, the pyodbc (doubt it's that), or the ODBC driver itself? Thanks, John -- 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 <mailto:sqlalchemy+unsubscr...@googlegroups.com>. To post to this group, send email to sqlalchemy@googlegroups.com <mailto:sqlalchemy@googlegroups.com>. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
-- 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.
