Hi, does FDB support named parameters in queries? Other python database 
adapters support specifying a name for the parameters in the SQL string 
and passing a dict to execute(), to bind the parameters to its values. 
Something like this:

cur.execute('select * from customers where id = %(cid)d', {'cid': 3})

That obviously does not work with FDB:

Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
   File "/usr/local/lib/python3.4/dist-packages/fdb/fbcore.py", line 
3352, in execute
     self._ps = PreparedStatement(operation, self, True)
   File "/usr/local/lib/python3.4/dist-packages/fdb/fbcore.py", line 
1985, in __init__
     "Error while preparing SQL statement:")
fdb.fbcore.DatabaseError: ('Error while preparing SQL statement:\n- 
SQLCODE: -104\n- Dynamic SQL Error\n- SQL error code = -104\n- Token 
unknown - line 1, column 37\n- %', -104, 335544569)

Is there another way?

  • [firebird-python]... Ernesto Benestante ebenesta...@gmx.net [firebird-python]

Reply via email to