[sqlalchemy] Re: Using substring function

2008-04-11 Thread maxi
(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

[sqlalchemy] Re: Using substring function

2008-04-11 Thread Lele Gaifax
On Fri, 11 Apr 2008 07:00:42 -0700 (PDT) maxi [EMAIL PROTECTED] wrote: 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) It's been