March 2001 - Zope - Zope lists

Order by property
by Andrew Fielden 08 Mar '01

08 Mar '01

All I am looking at the best way to order a set of dtml documents to display on a page using a custom sort method. I have it in mind to do something very similar to the Elvis sightings in the quick start tutorial. My current suggestion that is currently incomplete is The documents are in their own folder, similar to the Elvis sightings. - OK no problems there That the documents have a property called orderNo - OK again and once I get the display sorted I will try to create my own zclass to hold the property (unless there is a simple better way) There is a DTML method (or should it be a python script) that sorts the documents and then displays them, I am thinking of a dtml-in type thing here. I have looked through much of the documentation and all of the howtos but cannot work out how to do the sorting and iteration. Ideally I would like to use acquisition to achieve this so that I can have sets of folders that I can sort in the same way without having to worry about the method being present. Can anyone help. Andrew Fielden

1 0

Can only managers manage users???
by Lars Heber 08 Mar '01

08 Mar '01

A few days ago, a similar question to mine was asked: http://zope.nipltd.com/public/lists/zope-archive.nsf/ByKey/A5E30D4A4F40707A My problem is: I have a subfolder, want to create a user defined role, with which I can manage (i. e. add, edit, delete) users. When I give a user that UDR, he cannot get on the content screen of acl_users but is immediately redirected to the Security tab. Even typing in the direct URL doesn't work. But when I give that user the manage role which has EXACTLY the same permissions (my UDR has every possible permission for testing), then it works. What's going on here? I read a few threads about that topic, but either the authors didn't get an answer at all or the answers were confusing, because they matched only the special case of the author. All I want to know is if a user necessarily has to have the manager role to manage users. Thanks to you all! -- Lars Heber, mailto:Lars.Heber@t-systems.de TTTTTT TT T-Systems, debis Systemhaus GEI GmbH O TT O O O TT

1 0

What button submitted
by Axel.Missbach＠t-online.de 08 Mar '01

08 Mar '01

Hi, having a form with some buttons.(Add, Edit, Del...). Every button shoulg call the same form, wich one should handle the diffrent button-methods. Please tell me a way how to get to know which button is pressed. Every button is in the REQUEST, but i can't see, which one is the caller. I have looked in the Source of the manageform with the Rename Cut, Copy ... buttons. This ones changes the actionmethod, but where is the method they calling (e.g. manage_cutObjects) witg regards Axel

3 3

MySQL DA for Win98 environment
by Anton A. Zotov 08 Mar '01

08 Mar '01

Urgent: Would anybody be so kind to help me to find MySQL DA for Win98 in binary release ?

2 1

RE: [Zope] PythonScripts and REQUEST, RESPONSE objects
by Mayers, Philip J 08 Mar '01

08 Mar '01

Odd... a) Try: print dtml_method(context,context.REQUEST) If validate is in the REQUEST namespace, then context alone won't help. Context just contains the acquisition tree. b) is expected and normal behaviour. c) context contains the acquisition tree (folder path) so if the DTML method references anything else in the Zope hierarchy (other methods, headers, etc) then not passing context will fail, as you've seen. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Stefan H. Holek [mailto:stefan@epy.co.at] Sent: 08 March 2001 16:27 To: Mayers, Philip J; 'Wolfgang Strobl'; 'zope(a)zope.org' Subject: RE: [Zope] PythonScripts and REQUEST, RESPONSE objects Sorry Phil, this does not work for me in several ways: a) when I call any DTML Method from a Python Script with 'context' as the first parameter, I immediatley get Error Type: AttributeError Error Value: validate from the __call__ b) I have to use print context.blahblah( _.None, _ ) return printed to have anything output at all, and c) the called DTML Method does not aquire anything (possibly because I pass _.None) Duh! I must be doing something wrong then... Stefan -- Things work better when plugged in. --On Donnerstag, 08. März 2001 11:20 +0000 "Mayers, Philip J" <p.mayers(a)ic.ac.uk> wrote: > context.standard_html_{header,footer}(context,REQUEST) > > Or, if "_" is bound (called from DTML): > > context.standard_html_{header,footer}(context,_) > > Could this please go in the manual and Zope book? > > Regards, > Phil > > +----------------------------------+ > | Phil Mayers, Network Support | > | Centre for Computing Services | > | Imperial College | > +----------------------------------+ > > -----Original Message----- > From: Wolfgang Strobl [mailto:ws@gmd.de] > Sent: 08 March 2001 10:49 > To: zope(a)zope.org > Subject: Re: [Zope] PythonScripts and REQUEST, RESPONSE objects > > > On 8 Mar 2001, 9:26 Chris Withers wrote: > >> > after line 124 in Pythonscript.py. Now each time I add a new >> > PythonScript object, it starts with >> > >> > from Products.PythonScripts.standard import html_quote >> > REQUEST = context.REQUEST >> > RESPONSE = context.REQUEST.RESPONSE >> >> Can you stick that in the Collector as a 'Feature w/patch'? > > Done. In addition as an afterhought, I suggested adding two > additional lines > > print "This is Script (Python) ",script.getId(),"("+script.title+") at > ",container.absolute_url() > return printed > > in analogy to the default content of DTML Methods. > > Btw, what's the correct way of rendering the default > standard_html_header/footer from within a Python script? > > -- > o ( Wolfgang.Strobl(a)gmd.de (+49 2241) 14-2394 > /\ * GMD mbH #include > _`\ `_<=== Schloss Birlinghoven, <std.disclaimer> > __(_)/_(_)___.-._ 53754 Sankt Augustin, Germany ________________ > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

RE: [Zope] PythonScripts and REQUEST, RESPONSE objects
by Mayers, Philip J 08 Mar '01

08 Mar '01

context.standard_html_{header,footer}(context,REQUEST) Or, if "_" is bound (called from DTML): context.standard_html_{header,footer}(context,_) Could this please go in the manual and Zope book? Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Wolfgang Strobl [mailto:ws@gmd.de] Sent: 08 March 2001 10:49 To: zope(a)zope.org Subject: Re: [Zope] PythonScripts and REQUEST, RESPONSE objects On 8 Mar 2001, 9:26 Chris Withers wrote: > > after line 124 in Pythonscript.py. Now each time I add a new > > PythonScript object, it starts with > > > > from Products.PythonScripts.standard import html_quote > > REQUEST = context.REQUEST > > RESPONSE = context.REQUEST.RESPONSE > > Can you stick that in the Collector as a 'Feature w/patch'? Done. In addition as an afterhought, I suggested adding two additional lines print "This is Script (Python) ",script.getId(),"("+script.title+") at ",container.absolute_url() return printed in analogy to the default content of DTML Methods. Btw, what's the correct way of rendering the default standard_html_header/footer from within a Python script? -- o ( Wolfgang.Strobl(a)gmd.de (+49 2241) 14-2394 /\ * GMD mbH #include _`\ `_<=== Schloss Birlinghoven, <std.disclaimer> __(_)/_(_)___.-._ 53754 Sankt Augustin, Germany ________________ _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

3 2

Re: [Zope] SQLTEST is case insensitive?
by Dieter Maurer 08 Mar '01

08 Mar '01

FThe Doctor What writes: > The problem is two fold: > 1) ID = 1 should be "ID" = 1 so that PostgreSQL will treat it as a > case sensitive string. This was discussed some time ago (--> list archives). Changing "dtml-sqltest" to enclose the column name in double quotes would break lots of code (as many people rely on the case insensitive interpretation). > 2) ID = 1 should really be "URL"."ID", but I can't figure out how to > pass that through sqltest! You know the "column" argument to "dtml-sqltest". It can be used to provide an alternativ column name. The quotes will make difficulties, however, as they would be interpreted as DTML syntax. You can use vanilla DTML to emulate "dtml-sqltest" like for example: .... "URL"."ID" = '<dtml-var ID sql_quote>' .... Dieter

2 1

RE: [Zope] Reloading a page.
by Schmidt, Allen J. 08 Mar '01

08 Mar '01

Could this same thing be used to stop a proxy server from caching a page? We have a dtml method (that calls a ZSQL method) that is stuck in someone's proxy server and hits the page once every minute all day long. The resulting query that is showing up in our HitBox listing is for a DB category that is not even in the DB anymore but it keeps executing the same URL. Any ideas? Thanks Allen -----Original Message----- From: Casey Duncan [mailto:cduncan@kaivo.com] Sent: Thursday, March 08, 2001 10:11 AM To: Daniel Corrêa de Azevedo Cc: 'zope(a)zope.org' Subject: Re: [Zope] Reloading a page. Daniel Corrêa de Azevedo wrote: > > Whatz up, guys? > > Well, I´m having problems in reloading a page that shows information > contained in a table of a database. > The problem is that whenever I include some data in the database at > another page it send´s me back to that page that shows information, it > doens´t show the update, but a cached page. I´m using the IE 5.0 and I > haven´t figured out how to reload it every time without changing the > configuration of the browser. > I´ve tryed the same code that I´m using in IE 5.0 in IE 5.5 and > this problem doens´t happen. > Hope that you all could give me some help. > Thank´s, > Daniel C. Azevedo > Try putting this in the head of your standard_html_header: <dtml-if no_cache> <META HTTP-EQUIV="pragma" CONTENT="no-cache"> </dtml-if no_cache> Then set a boolean property on the DTML Document (or folder if it's a method) called "no_cache". This should prevent the browser from caching the page. -- | Casey Duncan | Kaivo, Inc. | cduncan(a)kaivo.com `------------------> _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

LoginManager form-based login and <dtml-raise "LoginRequired">
by Gerald Gutierrez 08 Mar '01

08 Mar '01

In my continuing quest to get LoginManager working for me, I've found that the loginForm needs to be wrapped with a <dtml-raise> tag before it'll display. If not, the basic authentication dialog box pops up. The <dtml-raise> tag seems to cause a stack trace to be displayed along with the login form. I cannot seem to get rid of it no matter what I do. I must have it not show up because my application uses WML and the <pre> tag is not a part of WML (and it'll make the page exceeded the maximum size of the page anyway). The source to LoginManager seems to just "call" acl_users.loginForm() and expect that it raises an exception in order to display a page to the user. Does this mean that there is no way around not displaying the stack trace to the user? Thanks.

2 1

ZMysql and MysqlDB
by Olaf Marc Zanger 08 Mar '01

08 Mar '01

hi there, i had a zope 2.3 installation under suse 7.0 (python 1.5.2) running wonderfully with connection to mysql (don't know the version anymore) now i installed the same mysql-data,. zope-data on suse 7.1. with mysql 3.22.30 and ZMySQL da 1-2-0 and MySQLdb 0.1.2, python 2.0 now i can use the database, so the data and passwords should be correct. unfortunately, if i connect to the database i get the error message printed in the addendum. is it possible, that i have to recompile the MySQLdb ? what else could be the problem? thanks for help olaf addendum -------------------- Zope Error Zope has encountered an error while publishing this resource. BadRequest Invalid connection string: ipOperate soli-con Traceback (innermost last): File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/soli-con/ipOffice/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: RoleManager) File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/soli-con/ipOffice/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_open_connection) File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_open_connection) File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 220, in manage_open_connection (Object: RoleManager) File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 240, in connect (Object: RoleManager) File /home/soli-con/ipOffice/lib/python/Products/ZMySQLDA/db.py, line 155, in __init__ BadRequest: (see above) -- soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23, 3013 Bern / Switzerland fon:+41-31-332 9782, mob:+41-76-572 9782 mailto:olaf.zanger@soli-con.com, http://www.soli-con.com

1 0