[Zope-dev] Z SQl Method (Newbie)

[Paul Chung Chee Soong]

Thanks pal. Anyway, I still failed to create a table. My SQL stmt is   
"CREATE TABLE policy (id varchar, status varchar)" and the error I get is   


Zope Error
Zope has encountered an error while publishing this resource.
exceptions.AttributeError
Sorry, a Zope error occurred.
Traceback (innermost last):
  File /usr/local/src/Zope-2.0.0a1-src/lib/python/ZPublisher/Publish.py,   
line 255, in publish_module
  File /usr/local/src/Zope-2.0.0a1-src/lib/python/ZPublisher/Publish.py,   
line 165, in publish
  File /usr/local/src/Zope-2.0.0a1-src/lib/python/BoboPOS/TJar.py, line   
281, in commit
  File /usr/local/src/Zope-2.0.0a1-src/lib/python/BoboPOS/TJar.py, line   
200, in maybe_commit_objects
AttributeError: _p_changed

Pls help. T.Q.


 -----Original Message-----
From: Martijn Pieters [SMTP:mj@antraciet.nl]
Sent: Friday, June 25, 1999 9:53 AM
To: Paul Chung Chee Soong; zope-dev
Subject: Re: [Zope-dev] Z SQl Method (Newbie)

At 11:53 25/06/99 , Paul Chung Chee Soong wrote:
>Create a Z Gadfly Database Connection. I created a directory 'test' in
>Zope-2.0.0a1-src/var/gadfly and it appeared in the Data Source field.   
How
>can I access it thru SQL Method since it isn't a database at all (just a
>plain dir !!). Can I create a database or table via SQL Method?
>
>Do I need to link the data source with a gadfly database? If yes, how??
>
>By default, there's a demo data source. How can I use it????? How do I
>know what are the tables in it anyway?? Thus, I can't use the SQL   
Method.
>
>I would appreciate very much if you can reply as soon as possible. I   
need
>to use SQL Method desperately now.

No tables have been defined yet. You can create tables using a SQL   
method,
using standard Data Definition Language syntax:

CREATE TABLE <tablename> (<column definition> [, <column definition>]*)

xŸ>"'