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 _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )