MSSQL LIKE and IN statements in ADO problem

Steve Holden steve at
Thu Jan 19 15:08:49 CET 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.

Steve Holden       +44 150 684 7255  +1 800 494 3119
Holden Web LLC           
PyCon TX 2006        

More information about the Python-list mailing list