[Zope] problem with ms sql server

Miguel Beltran R. yourpadre at gmail.com
Mon Dec 1 12:13:02 EST 2008


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20081201/48539c19/attachment.html 


More information about the Zope mailing list