pysqlite2.dbapi2.ProgrammingError: Incorrect number of bindings supplied. The current statement uses

[F. GEIGER]

Im on Python 2.3.4, using pysqlite 2.0.0 (final).

When I try to execute

self._dbc.execute(q, data)

where q is 'select count(*) from Difflets ' and date is None

I get the following exception:

pysqlite2.dbapi2.ProgrammingError: Incorrect number of bindings supplied.
The current statement uses 0, and there are -1 supplied.

Any ideas?

Many thanks in advance and kind regards
Franz GEIGER

 

[F. GEIGER]

Arrgh, sorry for that post!

self._dbc.execute(q, data)

where data is None, works with MySQL. For SQLite I have to write

if data is not None:
self._dbc.execute(q, data)
else:
self._dbc.execute(q)

Sorry again,
Franz GEIGER

 

[=?ISO-8859-1?Q?Gerhard_H=E4ring?=]

Arrgh, sorry for that post!

self._dbc.execute(q, data)

where data is None, works with MySQL. For SQLite I have to write

if data is not None:
self._dbc.execute(q, data)
else:
self._dbc.execute(q)

No, you have to write:

self._dbc.execute(q, (data,))

in both drivers.

i. e. the second parameter to execute *must* be a sequence. Some drivers
(maybe MySQLdb, too) automatically correct the wrong call and transform a:

execute(sql, single_param)

into a

execute(sql, (single_param,))

for you if they notice that "!PySequence_Check(single_param)".

pysqlite 2 does not do this.

HTH,

-- Gerhard

 

[F. GEIGER]

Thank you Gerhard,

No, you have to write:

self._dbc.execute(q, (data,))

in both drivers.

i. e. the second parameter to execute *must* be a sequence. Some drivers
(maybe MySQLdb, too) automatically correct the wrong call and transform a:

Okay, that makes sense.

execute(sql, single_param)

into a

execute(sql, (single_param,))

for you if they notice that "!PySequence_Check(single_param)".

pysqlite 2 does not do this.

HTH,

-- Gerhard

Many thanks again
Franz