we are using Zope 2.1.6 with Sybase 11.9.2 on Suse Linux, and calling
stored procedures just works fine. 

create procedure csp_add_barcode
        @tableName varchar(12), @barcode numeric(8) OUT
        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

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 Heinkel                  Cenix Bioscience GmbH
Director of the IT-Unit        Tel  : +49 6221/387 915
Meyerhofstr. 1                 Fax  : +49 6221/387 971
69117 Heidelberg, Germany      eMail: [EMAIL PROTECTED]

Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to