[Zope] Z SQL Methods

Paul Aviles paul.aviles@palei.com
Wed, 5 Jul 2000 21:24:51 -0400


I am completly new to Zope so pardon the question. I downloaded the RPMs
from http://starship.python.net/crew/jrush/Zope, etc, etc and installed them
without any problems.  I tried to follow the documentation on creating a
sample Z Sql using the Z Gadfly Database connection and I am having
problems.
On page 4 it mentions the you should add the arguments product_number, etc,
etc but the picture shows nothing in the Arguments field. Then when you do
add and test, it is supposed to get a message saying that is not a query.
That is not what I get. Then on the insert Product Input Data test I get an
error after hitting submit query, the error reads:

 Z SQL Method at /manage_addProduct / ZSQLMethods / sqlCreateTable
----------------------------------------------------------------------------
----
Error, exceptions.IOError: [Errno 13] Permission denied:
'/var/zope/var/gadfly/demo/demo.gfl'
----------------------------------------------------------------------------
----
SQL used:

CREATE TABLE product
(product_number VARCHAR(10),
product_description VARCHAR(10),
product_price FLOAT)

What am I doing wrong?? Also, is there a way to connect to a postgres or
mysql database?  Is one better than the other?

Thanks a lot!

-pa