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 )