Hi,

I have the next sql command

sql = 'SELECT  
   "EXPRESSIONS_COMPANY"."ID", 
   "EXPRESSIONS_COMPANY"."NAME", 
   "EXPRESSIONS_COMPANY"."NUM_EMPLOYEES",
   "EXPRESSIONS_COMPANY"."NUM_CHAIRS", 
   "EXPRESSIONS_COMPANY"."CEO_ID", 
   "EXPRESSIONS_COMPANY"."POINT_OF_CONTACT_ID", 
   ? AS "FOO" 
   FROM "EXPRESSIONS_COMPANY" 
   WHERE ? = ? 
   ORDER BY "EXPRESSIONS_COMPANY"."NAME" ASC'

Running this sql
cur.execute(sql, ['value', 'value', 'value'])

Raise an exception:
 SQL error code = -804 - Data type unknown'

Of course, fdb doesn't replace params from entire sql command, just from where 
clause.

Is this behavior the standard according to python db-api ?
Is there another approach to accomplish using fdb without make a string 
replacement ?


Regards
Maxi










 

  • [firebird-python] sql re... maxiroba...@gmail.com [firebird-python]

Reply via email to