Paul Boddie wrote:
On 26 Mai, 13:46, Gabriel Rossetti <gabriel.rosse...@arimaz.com> wrote:def getParams(curs): curs.execute("select * from param where id=%d", 1001)First of all, you should use the database module's parameter style, which is probably "%s" - something I've thought should be deprecated for a long time due to the confusion with string substitution that this causes, regardless of whether that mechanism is actually used internally by the module (as seen in your traceback). You also have to provide a sequence of parameters: unlike string substitution, you cannot provide a single parameter value and expect the execute method to do the right thing. Some database modules seem to insist on either lists or tuples of parameters, but I think any sequence type should work. Try this: curs.execute("select * from param where id=%s", (1001,)) Paul
Thank you for the explanation Paul! Gabriel -- http://mail.python.org/mailman/listinfo/python-list
