But does Gadfly work in 2.0? I know for a fact it doesn't work in 1.11.0pr1, and the error you cite is the exact same error I get using the latter version. I asked about this earlier, but I'm still waiting for an answer. -- Alexander Staubo http://www.mop.no/~alex/ "`This must be Thursday,' said Arthur to himself, sinking low over his beer, `I never could get the hang of Thursdays.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

-----Original Message----- From: zope-dev-admin@zope.org [mailto:zope-dev-admin@zope.org]On Behalf Of Paul Chung Chee Soong Sent: 28. juni 1999 02:09 To: mj@antraciet.nl; zope-dev@zope.org Subject: RE: [Zope-dev] Z SQl Method (Newbie)

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Ÿ>"'

_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://www.zope.org/mailman/listinfo/zope-dev

(For non-developer, user-level issues, use the companion list, zope@zope.org, http://www.zope.org/mailman/listinfo/zope )

_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope (For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )