My experience has been that the ZSQL method must be able to "see" the ZODBC connection. I have a folder called Query at the root of my zope installation that contains all databases connections and ZSQL methods. I use <dtml-var "Query.some_zsql_method()"> from anywhere on my site. __________________________________________________________________ Jim Sanford . Database Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________ ----- Original Message ----- From: Shalabh Chaturvedi <shalabh@pspl.co.in> To: zope <Zope@zope.org> Sent: Wednesday, November 24, 1999 11:45 AM Subject: [Zope] Design Issues
I'm relatively new to Zope.
I've written a couple of SQLMethods using ZODB connections. Currently I've put them in the root directory of Zope.
I have questions regarding possibilities and design issues:-
1. Is it possible to create an SQLMethod in a folder if the connection object exists in another folder (the connection object is not available here even through acquisition) ? Experienced zopers : would you do this?
2. Would it be a good idea to define all SQLMethods and corresponding connections at the root ? Then they can be used anywhere.
3. What are the folders under Control Panel:Products etc for ? Would I ever need to 'add' any objects under those folders ?
Thanks, Shalabh
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope No cross posts or HTML encoding! (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )