error in addZSQLMethod.
Hi Folks, I am trying to add zsql method using python script.I have written the following. context.manage_addZSQLMethod('selectname', title='selectname', connection_id='Oracle_database_connection', arguments='PROF_ID,firstname,middlename,lastname,email,linktowebpage,degree,officenumber,telephonenumber', template='Select firstname from Professor') The error that i get is an attribute error.Can someone tell me how to fix it. Also if anyone has come across a tutorial on using zope API where u can add new products using python,please send me the URL. Thanks, S.
I am trying to add zsql method using python script.I have written the following.
context.manage_addZSQLMethod('selectname', title='selectname', connection_id='Oracle_database_connection', arguments='PROF_ID,firstname,middlename,lastname,email,linktowebpage,degree,officenumber,telephonenumber', template='Select firstname from Professor')
The error that i get is an attribute error.Can someone tell me how to fix it.
It's easier to diagnose an error message if we can actually see it, but I think I can do it blind: the contents of 'arguments' should be separated by spaces or newlines, and not by commas, as the online help for ZSQL Methods will tell you.
Also if anyone has come across a tutorial on using zope API where u can add new products using python,please send me the URL.
Well, I think you got it above. There's really not much more to it: find the method, use the method as documented (or if not documented, guess.) If you like, you can go take a look at the Zope Cookbook at zopelabs.com where there may be something on this. Going through the list archives will also tell you more than you want to know on the subject.
Thanks for the reply.I did what you suggested namely separate the arguments by spaces.However I still get the smae error.Heres what i wrote now context.manage_addZSQLMethod('selectname', title='selectname', connection_id='Oracle_database_connection', arguments='PROF_ID firstName middleName lastName email linkToWebpage degree officeNumber telephoneNumber', template='Select firstname from Professor') and here is the error i get Error Type: AttributeError Error Value: manage_addZSQLMethod S. On Mon, 31 Mar 2003, J Cameron Cooper wrote:
I am trying to add zsql method using python script.I have written the following.
context.manage_addZSQLMethod('selectname', title='selectname', connection_id='Oracle_database_connection', arguments='PROF_ID,firstname,middlename,lastname,email,linktowebpage,degree,officenumber,telephonenumber', template='Select firstname from Professor')
The error that i get is an attribute error.Can someone tell me how to fix it.
It's easier to diagnose an error message if we can actually see it, but I think I can do it blind: the contents of 'arguments' should be separated by spaces or newlines, and not by commas, as the online help for ZSQL Methods will tell you.
Also if anyone has come across a tutorial on using zope API where u can add new products using python,please send me the URL.
Well, I think you got it above. There's really not much more to it: find the method, use the method as documented (or if not documented, guess.) If you like, you can go take a look at the Zope Cookbook at zopelabs.com where there may be something on this. Going through the list archives will also tell you more than you want to know on the subject.
_______________________________________________ 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 )
Thanks for the reply.I did what you suggested namely separate the arguments by spaces.However I still get the smae error.Heres what i wrote now
context.manage_addZSQLMethod('selectname', title='selectname', connection_id='Oracle_database_connection', arguments='PROF_ID firstName middleName lastName email linkToWebpage degree officeNumber telephoneNumber', template='Select firstname from Professor')
and here is the error i get
Error Type: AttributeError Error Value: manage_addZSQLMethod
Ah, now that's useful. You need to get to the constructor first (they aren't global.) Try this: context.manage_addProduct['ZSQLMethods'].manage_addZSQLMethod(...) This is documented in the API docs for ObjectManager. See your Zope install's online help system for more details. --jcc
participants (2)
-
J Cameron Cooper -
Santoshi Reddy