[Zope] problem with ms sql server

Dieter Maurer dieter at handshake.de
Tue Dec 2 13:18:38 EST 2008


Miguel Beltran R. wrote at 2008-12-1 11:13 -0600:
>I have a zsql where made a UPDATE and INSERT, I need know when happen a
>error to show.
>I using pyodbc 2.0.58, zpyodbcda 1.0.6 and ms sql server 2000
>
>[zsql with error after render: actualiza_info ]
>SET XACT_ABORT ON
>BEGIN TRANSACTION
>UPDATE taller SET
>comercial = ''
>where taller = 1

I would expect the need of a command separator (here at least and maybe after
earlier commands as well).

>insert into taller_movimiento (estado, taller, fecha, asunto, observacion
>) values(
>'14',
>1,
>'',         <--This must be not blank
>'',
>''
>)
>COMMIT TRANSACTION
>
>
>[dtml method]
><dtml-try>
>   <dtml-call actualiza_info>
>   All Ok
><dtml-except>
>   Error, but not showed :(
></dtml-if>

Omit the "dtml-try" (why does it end with "/dtml-if"?) and see
whether you get more information.



-- 
Dieter


More information about the Zope mailing list