[Zope] is it possible to bypass ZSQL methods and call stored procedures in sqlserver straight from ZPT?
Hi 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? Thanks -- michael ___ 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 call storedprocedures in sqlserver straight from ZPT?
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? ___ 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 call storedprocedures 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? > > -- michael ___ 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?
- 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 )
Re: [Zope] is it possible to bypass ZSQL methods and call storedprocedures in sqlserver straight from ZPT?
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? Or must you use a ZSQL method to access the procedure? -- Anything that, in happening, causes something else to happen, causes something else to happen. --Douglas Adams ___ 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 call storedprocedures in sqlserver straight from ZPT?
+---[ 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 Product code, it should be usable (s/self/context/) in a PythonScript, but, I haven't tested it. -- Andrew Milton [EMAIL PROTECTED] ___ 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 )
[Zope] Zope 2-3-five Confusion
I've pretty new to zope and am getting lost in the shuffle between zope 2/3/five/archetypes. I'm trying to get my feet wet by using zope 2.10.4. I'm trying to get a very simple content type to work inside the ZMI. I'd like to use the latest recommended five approach to this, but am getting confused in understanding what this approach is nowadays. I done much searching on the Internet and have purchased a couple of books (Web Component Development with Zope 3 & Professional Plone Development), but am still confused as to what approach should be used (what is the easiest) when it comes to the ZCML files. 1. Do I require "http://philikon.de/files/zope3-for-zope2-developers.pdf. However, I could not get the examples to work for me (especially when it came to the "Step 4: Basic Configuration" section where he goes into ZCML configuration). ___ 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 )
[Zope] Zope Jobs
Anyone have any recommendations for a good place to post a Zope job? Its for a freelance, work from where ever gig. Thanks. Tom ___ 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] Zope Jobs
- Original Message - From: "Tom Von Lahndorff" <[EMAIL PROTECTED]> To: "Zope user list" Sent: Tuesday, November 06, 2007 4:45 PM Subject: [Zope] Zope Jobs Anyone have any recommendations for a good place to post a Zope job? Its for a freelance, work from where ever gig. Thanks. You could try here: http://plone.freerecruiting.com/ 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 )
[Zope] Please help in selecting approach (zope2, 3, +grok, plone) for a new project
Hi all I am to start working on a new web (site/application) project. Wanted to find out better route from among the available choices. In other words what are *you* using ? I have used zope 2 and plone in my past projects. The question arises now as we have new rewrite of zope with grok on the horizon and plone as always is there (with a new version). There is also new CMS based on zope (hivert announced recently on zope-dev). Exciting times, but a little confusion too. The site will tend towards social networking some time later as I see the requirements taking shape. At the moment it is about people joining a community website and exchanging information on a particular topic, reviewing items (articles, links, photos) added to the site. TIA Chetan ___ 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 )