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

2007-11-07 Thread Andrew Milton
+---[ michael nt milne ]-- | ok thanks. I guess then if you're using the ZMI could you embed this in your | ZPT? But I guess that is not best practice. Using the ZMI you'd make a Python Script to call from your ZPT instead. -- Andrew Milton [EMAIL PROTECTED] __

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

2007-11-07 Thread michael nt milne
ok thanks. I guess then if you're using the ZMI could you embed this in your ZPT? But I guess that is not best practice. On 11/6/07, Andrew Milton <[EMAIL PROTECTED]> wrote: > > +---[ michael nt milne ]-- > | thanks. Is there an example or a tutorial at all on this anywhere

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

2007-11-06 Thread Andrew Milton
+---[ michael nt milne ]-- | thanks. Is there an example or a tutorial at all on this anywhere? # queryConnection holds the id of a DA connectionObject=getattr(self, queryConnection) connection = connectionObject() results = connection.query(SQL_GOES_HERE) This is from

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

2007-11-06 Thread Stefan H. Holek
IIRC, DB connections have a 'manage_test' method that could be (ab) used for things like that. On 6. Nov 2007, at 15:23, Jaroslav Lukesh wrote: 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? O

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

2007-11-06 Thread michael nt milne
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 s

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

2007-11-06 Thread Jaroslav Lukesh
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 usi