----- Original Message ----- From: "michael nt milne" <michael.milne@gmail.com> To: "zope list user" <zope@zope.org> Sent: Tuesday, November 06, 2007 9:30 AM Subject: Re: [Zope] is it possible to bypass ZSQL methods and callstoredprocedures in sqlserver straight from ZPT?
thanks. Is there an example or a tutorial at all on this anywhere?
On 11/6/07, Jaroslav Lukesh <lukesh@seznam.cz> wrote:
Yes
----- Original Message ----- From: michael nt milne We have some dynamic ZSQL methods all working but are looking to optimise our code and also access some stored procedures which are already written in SQL Server.
The question is, can you go straight through to a relational database using the connector object and call a stored procedure straight from a ZPT? Or must you use a ZSQL method to access the procedure?
You could also write a Product or External Method to access your databases directly, using something like: http://pymssql.sourceforge.net/ Jonathan