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 be
> (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 \nFRO
