Re: [Zope] problem with ms sql server

2008-12-02 Thread Dieter Maurer
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

Re: [Zope] problem with ms sql server

2008-12-01 Thread Jaroslav Lukesh
Hi, It should sounds courious, but try to manually rewrite (ie., do not copy&paste!) your ZSQL method. MSSQL and Sybase servers are sometimes sensitive to unvisible characters and query does not work and you does not know why. - Original Message - From: Miguel Beltran R. I have a zsq

[Zope] problem with ms sql server

2008-12-01 Thread Miguel Beltran R.
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