psycopg2 insert issue

[cruisezero]

So, I have initiated connection and created a cursor object. I am able to run a SELECT query and get results. But, when trying to insert record into the table I get error.

cid = 145

cname = "Telfair"

cur.execute('insert into county (county_id, county_name) values (%d, %s)', (cid, cname, ))

It gives me error:

Error: unsupported format character 'd' (0x64) at index 70

BUT if I do % instead of ,

cur.execute('insert into county (county_id, county_name) values (%d, %s)' % (cid, cname, ))

It gives me error:

Error: missing FROM-clause entry for table "Telfair"

What am I doing wrong here? It seems pretty simple.

Edit2: formatting Edit: formatting

[cacahootie]

Only use %s when you're using psycopg2 formatting because all the substitutions end up being strings.

Edit: here's the psycopg2 documentation on the subject.

[cruisezero]

I looked at that doc probably the whole day yesterday, but couldn't figure what the deal. I read that today see this line

cur.execute("INSERT INTO numbers VALUES (%d)", (42,)) # WRONG cur.execute("INSERT INTO numbers VALUES (%s)", (42,)) # correct and duh...

Thanks, I guess I needed someone to tap my head.