Skip site navigation (1)
Skip section navigation (2)
Parthan,
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.
Peripheral Links
Header And Logo
|
Site Navigation
Re: Error in PostgreSQL query with psycopg
- From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
- To: Parthan <parth(dot)technofreak(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Error in PostgreSQL query with psycopg
- Date: Mon, 31 Jul 2006 22:30:55 +0200
Parthan,
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.
- Follow-Ups:
- Re: Error in PostgreSQL query with psycopg
- From: John D. Burger
- Re: Error in PostgreSQL query with psycopg
- References:
- Error in PostgreSQL query with psycopg
- From: Parthan
- Error in PostgreSQL query with psycopg
- Prev by Date: Re: pg_xlog not cleaned up
- Next by Date: Re: Corrupted DB? could not open file pg_clog/####
- Previous by thread: Re: Error in PostgreSQL query with psycopg
- Next by thread: Re: Error in PostgreSQL query with psycopg
- Indexes: