[Zope-DB] How to import SQL in python script?
Mon, 10 Feb 2003 10:20:42 +0100
On 2003-02-10 at 06:05:45 [+0100], firstname.lastname@example.org wrote:
> Hi, I would like to use python to dynamically query a database.
> import the SQL Method class is with:
> from Products.ZSQLMethods.SQL import SQL
> Error Value: You are not allowed to access SQL in this context
> How do I set the permissions such that I could import the SQL object? I
> don't have access to the LINUX system to modify the SQL.py file.
Could you provide a bit more detail about what you're trying to do? It
sounds like you might be trying to use some Python module in a part of Zope
that doesn't allow it; that's why Zope's security doesn't let you. You
don't need to worry about the operating system permissions on the SQL.py
file. It's normally best to use a ZSQL-method do the work and call this
from a PageTemplate or a PythonScript. Importing the module directly is
more relevant for external methods, I think.