Re: [Zope] is it possible to bypass ZSQL methods and callstoredprocedures in sqlserver straight from ZPT?

2007-11-07 Thread robert rottermann 

> You could also write a Product or External Method to access your
> databases directly, using something like:  http://pymssql.sourceforge.net/
> 
you should not do that, you would get into lots of problems with zope's
transaction machinery.
always go trough a zope connection.

robert
begin:vcard
fn:Robert  Rottermann
n: Rottermann;Robert
email;internet:[EMAIL PROTECTED]
tel;work:++41 31 333 10 20
tel;fax:++41 31 333 10 23
tel;home:++41 31 333 36 03
x-mozilla-html:FALSE
version:2.1
end:vcard

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

Re: [Zope] is it possible to bypass ZSQL methods and callstoredprocedures in sqlserver straight from ZPT?

2007-11-06 Thread Jonathan 


- Original Message - 
From: "michael nt milne" <[EMAIL PROTECTED]>

To: "zope list user" 
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 <[EMAIL PROTECTED]> 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

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )