%s place holder does not let me insert ' in an sql query with python.
pyth0nc0d3r at gmail.com
Mon Dec 15 14:21:12 CET 2008
I had this problem too. If you've upgraded to python 2.6 you need to use
the new sytnax "format
queryString = "insert into venders
On Mon, Dec 15, 2008 at 6:46 AM, Krishnakant <hackingkk at gmail.com> wrote:
> hello all hackers.
> This is some kind of an interesting situation although many of you must
> have already gone through it.
> I am facing a situation where I have to use psycopg2 and insert rows in
> a postgresql table.
> That's pritty easy and no need to say that it works well. But there are
> some entries which have an ' in the value.
> I have a venders table in my database and one of the values tryed was
> "His Master's Voice "
> now the master's word has the ' which is used for starting and ending a
> varchar value for postgresql or almost any standard RDBMS.
> Does any one know what is the way out of this?
> how do you let the ' go as a part of the string?
> I have used %s as placeholder as in
> queryString = "insert into venders values ('%s,%s,%s" %
> (field1,field2,field3 ) ...
> This is not working for the ' values.
> can any one suggest a suitable solution?
> happy hacking.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list