MSSQL LIKE and IN statements in ADO problem
Steve Holden
steve at holdenweb.com
Thu Jan 19 09:08:49 EST 2006
Raja Raman Sundararajan wrote:
[...]
> Any inputs to improve the IN statement logic?
> My dream is to use just one create parameter for the SQL list
> so that the query looks like
> query = "SELECT * FROM tb_name WHERE firstname IN ?"
> Nice and easy...
>
Some DBAPI modules will indeed allow you to use a list or set parameter
for this purpose, but not all.
regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/
More information about the Python-list
mailing list