On Thu, Dec 18, 2008 at 11:31 AM, <span dir="ltr"><<a href="mailto:bangpypers-request@python.org">bangpypers-request@python.org</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
From: "Sidharth Kuruvila" <<a href="mailto:sidharth.kuruvila@gmail.com">sidharth.kuruvila@gmail.com</a>><br>
<br>
Do this instead<br>
<br>
cur.execute('select * from Employee where id in (%s)', ids.join(', '));<br>
<br>
</blockquote><div><br>I would need to co-erce my id into a string rep to do this. I guess that's ok?<br>Also, will the escaping be taken care of if the type of id was a string?<br></div></div><br>thanks,<br>Vijay<br>
<br>