Michel, Here is some more testing that I have done which still leads me to think that something is wrong here: http://www.jamenterprises.com:8080 ******************** This is the code behind the link "folder_gadfly": ******************** <dtml-var standard_html_header> <h2><dtml-var title_or_id></h2> <p>This is the <dtml-var id> Document.</p> <!--#call "manage_addFolder('Sample')"--> <!--#call "Sample.manage_addZGadflyConnection('zopadelic', '', 'demo', 'YES', REQUEST)"--> <!--#call "Sample.manage_addZSQLMethod('create_table', '1', 'zopadelic', '2', 'create table zopista(col_a integer,col_b integer)')"--> <!--#call "Sample.create_table.manage_test(REQUEST)"--> <!--#call "Sample.manage_addZSQLMethod('insert_data', '', 'zopadelic', '', 'insert into zopista (col_a, col_b) values (120, 380)')"--> <!--#call "Sample.insert_data.manage_test(REQUEST)"--> <!--#call "Sample.manage_addZSQLMethod('view_data', '', 'zopadelic', '', 'selct col_a, col_b from zopista')"--> <p>The Resulting Data is:</p> <ol> <!--#with Sample--> <!--#in view_data--> <li>col_a is <!--#var col_a-->, col_b is <!--#var col_b-->.</li> <!--#/in--> <!--#/with--> </ol> <dtml-var standard_html_footer> ******************** And Here are the Results: ******************** Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: manage_addZSQLMethod Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File /web1/home1/www/w085036/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /web1/home1/www/w085036/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /web1/home1/www/w085036/zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /web1/home1/www/w085036/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /web1/home1/www/w085036/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /web1/home1/www/w085036/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: index_html) File /web1/home1/www/w085036/zope/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: index_html) File /web1/home1/www/w085036/zope/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: index_html) File /web1/home1/www/w085036/zope/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: Sample.manage_addZSQLMethod('create_table', '1', 'zopadelic', '2', 'create table zopista(col_a integer,col_b integer)')) (Info: Sample) File <string>, line 0, in ? File /web1/home1/www/w085036/zope/lib/python/DocumentTemplate/DT_Util.py, line 127, in careful_getattr AttributeError: (see above) Michel Pelletier wrote:
Please continue to CC the list.
John Platten wrote:
Maybe I just don't understand how exactly "gadfly" is supposed to work, but here is the following notes about what I see with "gadfly":
1. Adding new directories to ./zope/var/gadfly will make new database names (ie. directory names) show up in the pick list for selecting which database to establish a new database connection with, however, when I try to "test" the database connection with the "test-tab" by sumitting SQL to the database connection, yes I do get tracebacks such as the following:
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: NameError Error Value: 'LIKES' no such relation in DB
I'm no gadfly expert, but it soulds like your gadfly is running fine. You just don't have the table 'LIKES' in whatever db you're connecting to. Try using a "create table" type SQL statement. For more info on creating tables, see the gadfly docs.
-Michel
_______________________________________________ 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 )