> (ProgrammingError) (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n > SQL error code = -104\n Token unknown - line 1, column 39\n ,') > 'SELECT substring(planilladet.msg_debug, ?, ?) AS msg_debug, > sum(planilladet.cant) AS cant, sum(planilladet.cant * > planilladet.importe) AS importe \nFROM planilladet JOIN planilla ON > planilla.plan_id = planilladet.plan_id \nWHERE planilla.conv_id = ? > AND planilla.fec_imput = ? GROUP BY 1' [1, 40, 1, datetime.date(2008, > 2, 1)] > > What can be the problem here? > > Thanks in advance.
Oopss, sorry, I respond to myself. The problem is with substring function, in SQL (I'm using Firebird 2.x) substring funcition sintax is: SUBSTRING(planilladet.msg_debug 1 FROM 40) How can do it in sqlalchemy ? (I use sqlalchemy 0.3.11) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---