Re: Problem with strange chars in text filed.

Thanks very much for the help. I am most great full.

Regards

On Mon, Jun 9, 2014 at 6:06 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 06/09/2014 09:02 AM, Bruce wrote:
>
>> I have a table:
>> create table truck (name varchar(45),address varchar(150));
>>
>> doing an insert:
>> for i in range (0,10):
>> meme = fake.name <http://fake.name>()
>>
>> 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(dot)klaver(at)aklaver(dot)com
>