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/ -- http://mail.python.org/mailman/listinfo/python-list
