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 )