rs = cur.execute("INSERT INTO steering_file_entry (id,galaxy_id,comparison,notes,auth)\
VALUES (?,?,?,?,'import')", getID(),fk_galaxyID,fk_comparison,fk_notes)

or this

rs = cur.execute("INSERT INTO steering_file_entry (id,galaxy_id,comparison,notes,auth)\
VALUES (:a,:b,:c,:d,'import')", getID(),fk_galaxyID,fk_comparison,fk_notes)

but both of those gave me

ingresdbi.InterfaceError: usage: cursor.execute()

Does anyone have any idea what I'm doing wrong?

Martin Bowes

cursor.execute expects 2 parameters, first the operation, second a tuple (or list) with all parameters in it. In the example, cur.execute is called with 5 parameters. Use round braces around the 4 values or use

op = "INSERT INTO xxx (yyy, zzz) VALUES(?,?)"
pa = (id, galaxy_id)
rs = cur.execute(op, pa)

Uwe Stelling

Martin Bowes wrote:

Thanks Uwe.

That did the trick!

Marty

-----Original Message-----
From: Uwe Stelling [mailto:stelling (AT) sdac (DOT) hannover.bgr.de]
Sent: 19 July 2011 14:37
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Using parameter place holders with Python

cursor.execute expects 2 parameters, first the operation, second a tuple (or list) with all parameters in it. In the example, cur.execute is called with 5 parameters. Use round braces around the 4 values or use

op = "INSERT INTO xxx (yyy, zzz) VALUES(?,?)"
pa = (id, galaxy_id)
rs = cur.execute(op, pa)

Uwe Stelling

Martin Bowes wrote:

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres