MSSQL LIKE and IN statements in ADO problem

Steve Holden steve at holdenweb.com
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.

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