On 05/20/2016 08:53 AM, John Omernik wrote:
Awesome, I am making some progress, I realized that the visit_join I had
was specific to Microsoft access, so I commented it out to see what
happened... that function was somehow not using the ?. When I commented
it out I got "better" sql:
OK so th
So maybe I want "with_labels" but I am not sure how to set that in the
visit_join... or am I looking in the wrong place?
On Fri, May 20, 2016 at 7:53 AM, John Omernik wrote:
> Awesome, I am making some progress, I realized that the visit_join I had
> was specific to Microsoft access, so I comm
Awesome, I am making some progress, I realized that the visit_join I had
was specific to Microsoft access, so I commented it out to see what
happened... that function was somehow not using the ?. When I commented it
out I got "better" sql:
Access visit_join:
def visit_join(self, join, asfrom=F
Hey Mike, thanks for the reply. I feel really bad in that I am struggling
on this, a little background, I am trying to get Caravel, which uses SQL
Alchemy to play nice with Apache Drill, this means I am learning about
dialects through a crash course of feeling really dumb, I've had some
success (wi
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 par
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 beca
