Thanks Paul, It was the problem!! 1/ Now, how to call in an ACTION attribut form the sql method I created to query the base? I cannot find example in the Aqueduct doc to do it? 2/Date seems not to be a type in gadfly thus how to sort on date?
Check the permissions on the Gadfly directory in the Zope var directory.
Trying the example from "http://www.zope.org/Documentation/HowTo/SampleGadfly" I obtained the following error :
=============================================== <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta name="GENERATOR" content="Mozilla/4.5 [fr] (WinNT; I) [Netscape]"> <title>seminairecreate_table</title> </head> <body bgcolor="#FFFFFF" link="#000099" vlink="#555555">
<table BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH="100%" > <tr> <td ALIGN=LEFT VALIGN=TOP><b>Z SQL Method at /seminaire </b></td> </tr> </table>
<hr><b>Error, <i>exceptions.IOError</i>:</b> (13, 'Permission denied') <hr><b>SQL used:</b> <pre>create table zopista (col_a integer, col_b integer)</pre>
<hr> </body> <!-- Traceback (innermost last): File /opt/digicool/zope/Zope-1.9.0- src/lib/python/ZPublisher/Publish.py, line 879, in publish_module File /opt/digicool/zope/Zope-1.9.0- src/lib/python/ZPublisher/Publish.py, line 595, in publish (Info: /seminaire/testgadfly) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/OFS/Document.py, line 181, in __call__ (Object: testgadfly) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/OFS/Document.py, line 177, in __call__ (Object: testgadfly) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/DocumentTemplate/DT_String.py, line 514, in __call__ (Object: testgadfly) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/DocumentTemplate/DT_Util.py, line 268, in eval (Object: Sample.create_table.manage_test(REQUEST)) File <string>, line 0, in ? File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Shared/DC/ZRDB/DA.py, line 317, in manage_test (Object: Item) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Shared/DC/ZRDB/DA.py, line 298, in manage_test (Object: Item) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Shared/DC/ZRDB/DA.py, line 402, in __call__ (Object: Item) File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Products/ZGadflyDA/db.py, line 187, in query File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Products/ZGadflyDA/gadfly/gadfly.py, line 353, in execute File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py, line 1177, in flush File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py, line 1263, in log File /opt/digicool/zope/Zope-1.9.0- src/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py, line 1244, in restart IOError: (see above)
--> </html> ===============================================
Bye, FR.
François-Régis Chalaoux Bioinformatics Group Synthélabo Biomoléculaire 67080 Strasbourg Cedex FRANCE Tél : 03 88 60 87 14 Fax : 03 88 45 90 70
François-Régis Chalaoux Bioinformatics Group Synthélabo Biomoléculaire 67080 Strasbourg Cedex FRANCE Tél : 03 88 60 87 14 Fax : 03 88 45 90 70