Re: [Zope] Zope and Sybase Stored Procedures
Hi, we are using Zope 2.1.6 with Sybase 11.9.2 on Suse Linux, and calling stored procedures just works fine. e.g. create procedure csp_add_barcode @tableName varchar(12), @barcode numeric(8) OUT AS insert into BarcodeItem (tableName) values (@tableName) select @barcode = @@identity This is a stored procedure that inserts one row into the table 'BarcodeItem' and returns an automatically created unique identity key as a result named 'barcode'. The ZSQL methods takes one parameter 'tableName' and returns the resulting 'barcode' like a normal select statement does. The query template simply is: csp_add_barcode dtml-sqlvar tableName type=string Hope that helps. Btw, Zope 2.2.0 has a bug in connecting to SybaseDA which is reported to digicool. Should be fixed in the next release. If interested for the fix, send me a mail. Ralph -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope and Sybase Stored Procedures
MANUEL JOSE AMADOR BRIZ wrote: Everything works from a SQL method except \"exec sp_xx\" calls. It is driving me insane. ZSybaseDA spits errors about some operation in progress . WARNING: This data is a bit old! Last I knew, SybaseDA didn't work with stored procedures. if that ahs changed, I apologize. I haven't seen anything that says it changed though. -- E PLURIBUS LINUX ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope and Sybase Stored Procedures
Everything works from a SQL method except \"exec sp_xx\" calls. It is driving me insane. ZSybaseDA spits errors about some operation in progress . Quoting [EMAIL PROTECTED]: Hi, I am working with zope and I want to securize my access to the data stored in a Sybase Server. So I am trying to do all my SQL requests by using stored procédures. The only thing that goes wrong is that I don\'t know how to make a call to a Sybase Stored Procedure within Zope. Can anyone help me ? Sincerly, Badara POUYE Infosources 16, rue Hoche Tour Kupka B 92906 Paris La Défense Tel.: (+33)141028000 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) -- Universidad Federico Santa Maria - Campus Guayaquil Enviado por: www.usm.edu.ec ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Zope and Sybase Stored Procedures
Hi, I am working with zope and I want to securize my access to the data stored in a Sybase Server. So I am trying to do all my SQL requests by using stored procédures. The only thing that goes wrong is that I don't know how to make a call to a Sybase Stored Procedure within Zope. Can anyone help me ? Sincerly, Badara POUYE Infosources 16, rue Hoche Tour Kupka B 92906 Paris La Défense Tel.: (+33)141028000 ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )