Hi list 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 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> If I test the zsql show this, but must show the error: This statement returned no results. ------------------------------ *SQL used:* SET XACT_ABORT ON BEGIN TRANSACTION UPDATE taller SET comercial = '' where taller = 1 insert into taller_movimiento (estado, taller, fecha, asunto, observacion ) values( '14', 1, '', '', '' ) COMMIT TRANSACTION -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida
_______________________________________________ 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 )
