- Zope - Zope lists

FYI: Zope Weekly News
by Amos Latteier 02 Jun '99

02 Jun '99

Hello, It's been a fairly calm week in Zope development. The folks from DC are back from Linux Expo and working to finish a beta of the Portal Toolkit ASAP. Brian Lloyd has been relentlessly attacking the backlog of Zope bugs. And Zope is still getting press. * Steve Litt wrote a very complementary article about Zope in Troubleshooting Professional Magazine. http://www.troubleshooters.com/tpromag/199906/_digcreate.htm * Zope also appeared in an article on open source in Computing Canada. http://www.zope.org/pipermail/zope/1999-June/004935.html http://www.plesman.com/cc/news/cc252127a.html * A Zope job posting appeared on the Python list and the Zope list this week. So there does seem to be some money to be made in open source, after all ;-) http://www.zope.org/pipermail/zope/1999-May/004751.html * Following in the tradition of Python bot humor, hilarity ensued when Paul Jackson mistook Zope contributor Amos Latteier for an RDF database. http://www.zope.org/pipermail/zope/1999-May/004772.html http://www.zope.org/pipermail/zope/1999-May/004773.html * Jim Washington revealed tips on how to get Zope running on Mac OS X. http://www.zope.org/pipermail/zope/1999-May/004873.html * German Zope enthusiasts who missed the first Berlin Zope Barbecue will definitely be interested in the 2nd beehive Zope barbecue. http://www.zope.org/pipermail/zope/1999-June/004904.html Until next week, happy Zoping. -Amos -- Amos Latteier mailto:amos@digicool.com Digital Creations http://www.digicool.com

1 0

Re: external product writing to a file system ?
by Dr. Ross Lazarus 02 Jun '99

02 Jun '99

Thanks for the suggestion, but I'd already looked through the DTMLtest code and tried that - here's what I got Sorry, an error occurred.<p> <PRE> Traceback (innermost last): File lib/python/ZPublisher/Publish.py, line 877, in publish_module File lib/python/ZPublisher/Publish.py, line 592, in publish (Info: /CDT/cdt/testpub) File lib/python/ZPublisher/Response.py, line 264, in setBody File lib/python/DocumentTemplate/DT_HTML.py, line 217, in __str__ (Object: <string>) File lib/python/DocumentTemplate/DT_HTML.py, line 211, in quotedHTML (Object: <string>) TypeError: argument 1: expected read-only buffer, ExplicitAcquirerWrapper found There must be some function which knows how to deal with the wrapper which dtml objects have when I grab them from self.objectItems('DTML Document'). Explicitly unwrapping them with str(foo) doesn't help much - I just get a quoted html representation. I'm still missing something here ! Kent Polk wrote: > > In zope.misc, you wrote: > >One of us is probably really missing something here. > > >The problem I'm wrestling with is the opposite - I can grab zope > > dtml objects in external methods, but I can't figure out how to > > call some mythical function render(foo) the way zope does - converting > > all the zope bits (such as ) into the same html that > > the zope ORB would. Any advice appreciated... > > Maybe I'm still misunderstanding, but you can use Globals.HTML() > to render a dtml 'string'. Take a look at DocumentTemplate/DTtest.py > > Kent -- Dr Ross Lazarus Associate Professor and Sub-Dean for Information Technology Faculty of Medicine, A27, R126a, University of Sydney, Camperdown, NSW 2006, Australia Tel: (+61 2) 93514429 Mobile: +61414872482 Fax: (+61 2) 93516646 Email: rossl(a)med.usyd.edu.au http://www.health.usyd.edu.au/people/rossl.htm

1 0

Simplest example of INSERT
by Evan Simpson 02 Jun '99

02 Jun '99

Have you filled in the ZSQLMethod's argument list with col and fla? Unless a variable name is in the argument list, it is NOT found in REQUEST or parameters in a call, ONLY in the containing folder. AFAIK this is a security feature, so that you can parameterize a query using acquisition and properties of the acquiring object, without allowing the REQUEST to override parameters unless you explicitly specify. For example, you could have ZSQLmethod "base/larch/newstuff" as INSERT INTO  (ID, ) VALUES (, ) with "new_id" and "new_value" in the argument list. Then "base/larch/newstuff" accepts "new_id" and "new_value" as arguments, and looks up "relation" and "attribute" in "base/larch", while "base/larch/parrot/newstuff" looks up "relation" and "attribute" in "base/larch/parrot". Neither one allows ".../newstuff?relation=forbiddentable..." since "relation" is not in the argument list.

1 0

RE: [Zope] Simplest example of INSERT
by Rob Page 02 Jun '99

02 Jun '99

> > I have a 'dataentry.html' that looks something like this: > > <form method="post" action="sqltestthing"> > > Color: <input name="col"> > > Flavor: <input name="fla"> > > <input type=submit> > > </form> > > > > And then a Z SQL Method 'sqltestthing': > > INSERT INTO TESTTABLE (color,flavor) > > VALUES (,) > > > > > > I enter the data into the form page, and hit submit. I get back the > > sqltestthing page saying 'This query requires no input.' I > hit submit > > again, and get > > Error, exceptions.SyntaxError: unexpected token sequence.near :: > > 'lavor)\012VALUES ('*',) > > > I think you mistyped your sqlvar tags - try changing: >  > to >  In general the an SQL Method has little to no useful interface. Since you are likely to want to wrap the result (e.g., 'Thanks for Registering, Daniel') I'd make the target of the form another DTML document and call the SQLMethod from the second document. As in: <form method="post" action="document_wrapper_for_sqltestthing"> Color: <input name="col"> Flavor: <input name="fla"> <input type=submit> </form> And then a Z SQL Method 'sqltestthing': INSERT INTO TESTTABLE (color,flavor) VALUES (,) and THEN a document document_wrapper_for_sqltestthing:   <P>Thanks for registering your favorite color, </P>  --Rob

1 0

RE: [Zope] Simplest example of INSERT
by Brian Lloyd 02 Jun '99

02 Jun '99

> I'm a total Zope newcomer, and I'm attempting to create a test thing > where I can enter data into a form and have that data inserted into a > table in a gadfly database. > > I've read the ZDTML guide, the Z SQL methods guide, and the managers > guide, and none of these seem to give any examples of how to do this > simplest task. (I've found the documentation to be absymal -- no > examples, just definitions.) > > I have a 'dataentry.html' that looks something like this: > <form method="post" action="sqltestthing"> > Color: <input name="col"> > Flavor: <input name="fla"> > <input type=submit> > </form> > > And then a Z SQL Method 'sqltestthing': > INSERT INTO TESTTABLE (color,flavor) > VALUES (,) > > > I enter the data into the form page, and hit submit. I get back the > sqltestthing page saying 'This query requires no input.' I hit submit > again, and get > Error, exceptions.SyntaxError: unexpected token sequence.near :: > 'lavor)\012VALUES ('*',) I think you mistyped your sqlvar tags - try changing:  to  Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com >

1 0

RE: [Zope] trouble with Zope 2.0.0a1, manage_addZGadflyMethod
by Aaron Watters 02 Jun '99

02 Jun '99

Michel Pelletier @digicool.com relates: > Hopefully, we will have a working version of the latest gadfly bundled with zope > 2.0 final. Great! Quick comment: the main gadfly 1.0 engine is *not* threadsafe, and I hear rumors that zope 2.0 is multithreaded. I recommend that each database instance be protected by a lock to disallow multiple threads from attempting to update or query a given gadfly instance at the same time. There are a number of places where extremely unlikely circumstances might lead to spectacular failures otherwise. In my experience you will never detect a potential problem like this in testing -- it will only occur during peak usage by your most important customer -- and you won't be able to reproduce the problem after that either... Of course if there are more than one lock around deadlocks also might be concievable afiak... A word to the wise... -- Aaron Watters === If you think you're smart enough to do multithreaded programming you're not. -- Jim Ahlstrom's variant of the Catch 22

1 0

RE: [Zope] Access denied when reading empty field in DB
by Miller, John M. 02 Jun '99

02 Jun '99

Yes Mr. Miller, there is a quite simple solution to your problem. Since I am, in fact, you I know the DTML code you were using in your rendering document:  ... blah ... blah ...  ... more blah ...    You would get much better results. Also, if you had been paying more attention when you first wrote you would noticed your described problem was with _all_ fields with empty values. My best guess (which is still rather poor with my only basic understanding of Zope lore) is that the Z SQL method won't create a variable representing a field in the database unless it actually finds a value for that field. Or perhaps it could be something completely different, I'm not really sure at the moment. Have a pleasant day Mr. Miller, John Miller > -----Original Message----- > From: Miller, John M. [SMTP:jmiller1@uop.com] > Sent: Wednesday, June 02, 1999 9:09 AM > To: 'zope(a)zope.org' > Subject: [Zope] Access denied when reading empty field in DB > > Hello, > > I have a Z SQL method (querying through a Z ODBC connection to an Access > database) that retrieves all the entries in a particular row in a table in > my DB, as so: > select * > from [Verbal Requests] > where [Case#] =  > > Most of the time this works jolly well (I'm still getting over how easy > this > was to set up in Zope after trying to use various wizards in Access, > *shudder* FrontPage, and *double shudder* Interdev) except when it > encounter > a field with an empty value. The field it chokes on contains values of > type > Double. I have specified no default value in the database setup. The > field > is named 'Man Hours' (so that you can recognize it in the traceback). > > When a blank value is encountered the browser politely tells me "You are > not > authorized to access this resource" and gives me the following traceback: > > Traceback (innermost last): > File C:\Program Files\ZopeEdge\lib\python\ZPublisher\Publish.py, > line 255, in publish_module > File C:\Program Files\ZopeEdge\lib\python\ZPublisher\Publish.py, > line 157, in publish > File C:\Program Files\ZopeEdge\lib\python\ZPublisher\mapply.py, > line 154, in mapply > (Object: index_html) > File C:\Program Files\ZopeEdge\lib\python\ZPublisher\Publish.py, > line 98, in call_object > (Object: index_html) > File C:\Program Files\ZopeEdge\lib\python\OFS\DTMLDocument.py, > line 181, in __call__ > (Object: index_html) > File C:\Program Files\ZopeEdge\lib\python\OFS\DTMLDocument.py, > line 177, in __call__ > (Object: index_html) > File C:\Program > Files\ZopeEdge\lib\python\DocumentTemplate\DT_String.py, line 514, in > __call__ > (Object: index_html) > File /Program Files/ZopeEdge\lib\python\DocumentTemplate\DT_In.py, > line 675, in renderwob > (Object: get-vr-details) > File C:\Program > Files\ZopeEdge\lib\python\DocumentTemplate\DT_Util.py, line 315, in eval > (Object: _vars['Man Hours']) > File <string>, line 0, in ? > File C:\Program > Files\ZopeEdge\lib\python\DocumentTemplate\DT_Util.py, line 150, in > careful_getitem > Unauthorized: (see above) > > I am thinking this problem stems from having an empty (null?) value in > this > field when it is expecting a floating-point value. I imagine configuring > the Access database to provide a default value for this field will make > this > go away. Does anyone else have a better idea? I did some thinking along > the lines of capturing this situation and providing a slightly more > elegant > response, i.e. displaying all the fields expect the empty one, but my Zope > lore is woefully insufficient. > > I am happy to provide any additional details that you so require, > > Much thanks, > John Miller > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

help help!
by CURTIS David 02 Jun '99

02 Jun '99

Greetings, I am a newbie trying to access MySQL via ZOPE. Basically I want to access databases via the web. I keep getting a mysql access error :" MySQL error select command is denied to user '@localhost' for table 'table1' ===PC SETUP=== Here is my setup. Redhat Linux 5.2 Python 1.5.1 MySQL 22.22.22 (most stable version) Zope 1.20.29 (most stable version) I have tried already to grant rights to 'nobody' and 'localhost' users. This did not help! mysql> grant select, insert on database1.table1 to nobody(a)159.121.xx.xx; and localhost, localhost(a)159.xx, etc... I added the line "mysql database1" to the connection screen. Can I connect with a usernamne and a password? Basically how can I determine it I am really connected to the database: ie is there a command that I can send to the database that does not need access? Also once I get connected (unless I give up) how do I access this database via other computers? I tried on a separate PC using the following URL: http://159.121.xx.xx:9673/manage and it sits and spins. It works on the localhost PC only. Thanks in advance for the help!!!

1 0

Simplest example of INSERT
by Daniel M. Drucker 02 Jun '99

02 Jun '99

I'm a total Zope newcomer, and I'm attempting to create a test thing where I can enter data into a form and have that data inserted into a table in a gadfly database. I've read the ZDTML guide, the Z SQL methods guide, and the managers guide, and none of these seem to give any examples of how to do this simplest task. (I've found the documentation to be absymal -- no examples, just definitions.) I have a 'dataentry.html' that looks something like this: <form method="post" action="sqltestthing"> Color: <input name="col"> Flavor: <input name="fla"> <input type=submit> </form> And then a Z SQL Method 'sqltestthing': INSERT INTO TESTTABLE (color,flavor) VALUES (,) I enter the data into the form page, and hit submit. I get back the sqltestthing page saying 'This query requires no input.' I hit submit again, and get Error, exceptions.SyntaxError: unexpected token sequence.near :: 'lavor)\012VALUES ('*',) I'm obviously doing this entirely wrong. Perhaps someone could point me to a simple example of a simple database app in action? Daniel Drucker

2 2

RE: [Zope] trouble with Zope 2.0.0a1, manage_addZGadflyMethod
by Michel Pelletier 02 Jun '99

02 Jun '99

> -----Original Message----- > From: Christopher Lange [mailto:chl@mme.de] > Sent: Tuesday, June 01, 1999 8:29 PM > To: zope(a)zope.org > Subject: [Zope] trouble with Zope 2.0.0a1, manage_addZGadflyMethod > > > Hi, > > I am new to Zope and can´t get a database connection up and running. > > I downloaded Zope 2.0.0a1 and starting it using > /home/chl/Python-1.5.2/bin/python z2.py -2 -d 192.168.10.1. > its running fine on my Linux system (2.2.5 kernel, SuSE 6.1). > <snip> > > whats wrong? Where can I get working database demos? In > detail, how can I > create a table to play with? > Somewhere between 1.9 and 2.0.0a we broke the Gadfly that comes with Zope. We are commited and interested in leaving Gadfly in Zope, but we are a little strained for project resources at the moment. Hopefully, we will have a working version of the latest gadfly bundled with zope 2.0 final. We realize that this is an inconvienence, and fixing this is definatly on the board. In the meantime, you can get the latest version of Gadfly (http://www.chordate.com/) and use it in a non-bundled fasion with Zope. It will work identically (probably better, cuz you'd have the latest version) you just have to go the extra step of installing Gadfly. -Michel PS: Gadfly Database Adapter related questions should go here, not to Aaron. Gadfly related questions (non-zope) should probably go to it's discussion group (http://www.egroups.com/list/gadfly-rdbms/) > Chris > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0