Re: Problem with strange chars in text filed.
| От | Bruce |
|---|---|
| Тема | Re: Problem with strange chars in text filed. |
| Дата | |
| Msg-id | CADzTWJ=dAVOG=Ed2mda5CzOzBBsh5yizYpsbPfz_c-Dsi6TR0A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with strange chars in text filed. (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-sql |
Thanks very much for the help. I am most great full.
Regards
On Mon, Jun 9, 2014 at 6:06 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 06/09/2014 09:02 AM, Bruce wrote:I have a table:meme = fake.name <http://fake.name>()
create table truck (name varchar(45),address varchar(150));
doing an insert:
for i in range (0,10):
address = fake.address()
print (meme,address)
cur.execute("INSERT INTO TRUCK2 VALUES (%s, %s)", ([meme], [address]))
conn.commit()
Assuming you are using psycopg2 the answer is here:
http://initd.org/psycopg/docs/usage.html#passing-parameters-to-sql-queries
so:
cur.execute("INSERT INTO TRUCK2 VALUES (%s, %s)", (meme, address))
or
cur.execute("INSERT INTO TRUCK2 VALUES (%s, %s)", [meme, address])
Help
--
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-sql по дате отправления: