Alan Trick wrote: > On Fri, May 25, 2012 at 10:18 AM, Tim Roberts <[email protected]> wrote: >> Is there any change if you use a tuple instead of a list? That is: >> >> cur.execute("select * from chiro1 where prefix = ?", ('LEG',)) > I get an identital exception with a tuple. For what it's worth, the > value of cur.query is different, but I don't know if that has any > effect on anything. With a list, cur.query is set to "select * from > chiro1 where prefix = ?,parameters=['LEG']", with a tuple it's "select > * from chiro1 where prefix = ?,parameters=('LEG',)".
I'd expect that. I am at a loss. The adodbapi code gives the OLE DB provider a first shot at processing the parameters. If that fails, then the Python code does the processing itself. My guess is that the OLE DB provider here is saying "it worked!", but isn't actually setting up the substitutions. -- Tim Roberts, [email protected] Providenza & Boekelheide, Inc. _______________________________________________ python-win32 mailing list [email protected] http://mail.python.org/mailman/listinfo/python-win32
