never, never, never try quoting on your own! You can only fail. The only choice is to fail now or later.
The only recommended way with Python and DBAPI2.0 is:
lala="huibuh" cs.execute ("select bla from foo where schupp=%s", (lala,))
or better
cs.execute ("select bla from foo where schupp=%(lala)s", dict(lala="huibuh"))
(that's with psycopg2)
Harald
-- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Let's set so double the killer delete select all.