Vijay Ramachandran wrote:
>
> Suppose I have a list of ids, I would write sql such as
> 'select * from Employee where id in (id1, id2, id3)' and this would work
> even if there was only one id, say, 'select * from Employee where id in
> (id1)'
>
> How should I do this in MySQLdb? It seems that I need to handle single
> entry list differently from a list with multiple elements?
You may find the bit of additional software at the following site useful. It
has a slide presentation that talks about this and similar issues and delivers
a lightweight solution.
http://furius.ca/antiorm/
The presentation slides are very good and bring up some interesting ideas.
http://furius.ca/antiorm/doc/talks/dbapiext/dbapiext-pres.pdf
-Jeff
_______________________________________________
BangPypers mailing list
BangPypers@python.org
http://mail.python.org/mailman/listinfo/bangpypers
