> There is also Option 3: Use actual parameter passing to build a WHERE ... IN
> (...) clause:
>
> cSql = ("select ktbl2_fk from tbl3 where OtherKey IN ("
> +",".join("%s" for _ in cList)
> +")" )
> cur.execute(cSql, cList)Don't suppose you know off the top of your head how to code it for .paramstyle=named >>> print cx_Oracle.paramstyle named Carl K _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
