Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #34591

Re: MySQLdb insert HTML code error

References <CAKhY55Nfq7+CsjqrksdGYxODNYUvBSowXQYjZ6-FzxQeOgBnUQ@mail.gmail.com> <50C6837D.9040307@mrabarnett.plus.com>
Date 2012-12-11 02:05 +0100
Subject Re: MySQLdb insert HTML code error
From Anatoli Hristov <tolidtm@gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.703.1355187941.29569.python-list@python.org> (permalink)

Show all headers | View raw


> You're using a parametrised query (which is good :-)), but you've included
> quotes around the placeholders. There's no need to do that. They'll be
> quoted automatically when necessary:
>
> sql = "INSERT INTO product_description (product_id, language_id, name,
> description) VALUES (%s,%s,%s,%s)"

Thanks a lot it woooorks. I was looking in the wrong direction (escape
str. raw etc) Thanks again :-)

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: MySQLdb insert HTML code error Anatoli Hristov <tolidtm@gmail.com> - 2012-12-11 02:05 +0100

csiph-web