September 1999 - Zope

Sorting rows from a database in reverse order
by Ben Glazer 23 Sep '99

23 Sep '99

I have a question about sorting rows returned by an SQL query. I'm running Zope 2.0 with a Z MySQL DB connection. display_news is a Z SQL Method that contains the following query: SELECT DATE_FORMAT(date, '%b %d, %Y') as date, headline, url FROM news I use display_news in the following DTML fragment: <dtml-in display_news sort=date> <a href="<dtml-var url>"><dtml-var headline></a><br> <dtml-var date> <br><br> </dtml-in> When I view the page containing the above DTML, the news headlines are displayed such that the oldest news is at the top of the page and the newest is at the bottom. Now, I know that I can use "ORDER BY date DESC" in the SQL query and remove the "sort=date" dtml-in parameter to accomplish the task, but I'm not sure that it's really the most efficient way, nor that it will always work. So here are the questions whose answers will settle the matter for me: 1. Will dtml-in always iterate over the rows display_news returns in order? 2. If so, is there a way for dtml-in to reverse the sort order? 3. If so, is it more efficient to let Zope or MySQL sort the data? Thanks, Ben

2 1

Objet : Re: [Zope] Install problem with Zope2.0.1
by Francois-Regis CHALAOUX 23 Sep '99

23 Sep '99

Hi and thank Anthony, The problem ========== I'm interesting to install Zope-2.0.1 ( www.zope.org ) Constraints ========= it is a production machine (Intel RH5.2 + Python-1.5.1.rpm from RH5.2 ) Experiments ========== Thus, to minimize installation and tests I tried to install the Linux binary version of Zope-2.0.1 which contents a Python 1.5.2 version. Some days before I did it on RH6.0 and it worked fine. But today it does not work :( During the installation and startup ( with zserver ) of Zope-2.0.1 i obtain the following messages ( see 'Install error' and 'Error at startup' below). I also tested the python install coming with Zope-2.0.1 ( see message 'Test of python' ). I also tested the python install coming with Zope-2.0.1 with setting the PYTHONHOME ='/opt/digicool/zope/Zope2' ( see message 'Test of python with PYTHONHOME='/opt/digicool/zope/Zope2' ). Questions ======= Is the python coming with zope-2.0.1 works ont RH5.2 or should I configure other things? If not, what's the best to upgrade from the standard Python1.5.1 rpm version to a Python1.5.2.rpm with threads for RH5.2. Bye, FR. Install error ========= [root@srnoix Zope2]# ./install Built-in exception class not found: EnvironmentError. Library mismatch? Warning! Falling back to string-based exceptions ------------------------------------------------------------------------------ Compiling python modules ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ creating default access file Note: The super user name and password are 'superuser' and 'UWHI16bP'. You can change the superuser name and password with the zpasswd script. To find out more, type: /opt/digicool/zope/Zope2/bin/python zpasswd.py chmod 0600 /opt/digicool/zope/Zope2/access chmod 0711 /opt/digicool/zope/Zope2/var ------------------------------------------------------------------------------ creating default database chmod 0600 /opt/digicool/zope/Zope2/var/Data.fs ------------------------------------------------------------------------------ Writing the pcgi resource file (ie cgi script), /opt/digicool/zope/Zope2/Zope.cgi chmod 0711 /opt/digicool/zope/Zope2/Zope.cgi ------------------------------------------------------------------------------ Creating start script, start chmod 0711 /opt/digicool/zope/Zope2/start ------------------------------------------------------------------------------ Creating stop script, stop chmod 0711 /opt/digicool/zope/Zope2/stop ------------------------------------------------------------------------------ Error at startup =========== [root@srnoix Zope2]# ./start Built-in exception class not found: EnvironmentError. Library mismatch? Warning! Falling back to string-based exceptions Traceback (innermost last): File "/opt/digicool/zope/Zope2/z2.py", line 366, in ? import ZServer File "/opt/digicool/zope/Zope2/ZServer/__init__.py", line 123, in ? from HTTPServer import zhttp_server, zhttp_handler File "/opt/digicool/zope/Zope2/ZServer/HTTPServer.py", line 115, in ? from PubCore import handle File "/opt/digicool/zope/Zope2/ZServer/PubCore/__init__.py", line 86, in ? import ZRendezvous File "/opt/digicool/zope/Zope2/ZServer/PubCore/ZRendezvous.py", line 87, in ? from ZServerPublisher import ZServerPublisher File "/opt/digicool/zope/Zope2/ZServer/PubCore/ZServerPublisher.py", line 85, in ? from ZPublisher import publish_module File "/opt/digicool/zope/Zope2/lib/python/ZPublisher/__init__.py", line 87, in ? from Publish import publish_module, Retry File "/opt/digicool/zope/Zope2/lib/python/ZPublisher/Publish.py", line 97, in ? class Retry(Exception): TypeError: base is not a class object Test of python ========== [root@srnoix bin]# ./python Could not find platform independent libraries <prefix> Could not find platform dependent libraries <exec_prefix> Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>] Built-in exception class not found: EnvironmentError. Library mismatch? Warning! Falling back to string-based exceptions Python 1.5.2 (#1, Apr 14 1999, 10:34:26) [GCC 2.7.2.3] on linux2 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> Test of python with PYTHONHOME='/opt/digicool/zope/Zope2' ============================================= [root@srnoix bin]# ./python Built-in exception class not found: EnvironmentError. Library mismatch? Warning! Falling back to string-based exceptions Python 1.5.2 (#1, Apr 14 1999, 10:34:26) [GCC 2.7.2.3] on linux2 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> >>> Anthony Baxter <anthony(a)interlink.com.au> 23/09/99 02:49:25 >>> >>> Francois Chalaoux wrote > Hi, > I was so happy to install in production a Zope2. It works superfine with > Zserver on my PC and RH6.0 . > when I tried to install Zope2 on my production machine ( My config is PC > i686, RH5.2) I got the following error : It looks like the python install on your production machine is either insane, or old. Make sure you are using Python 1.5.2 on both.

1 0

(Fwd) Re: [Zope] Changing Contexts (Was: [Zope] Acquisition? D
by Rik Hoekstra 23 Sep '99

23 Sep '99

> Paulo Eduardo Neves wrote: > > > > "Jay R. Ashworth" wrote: > > > > > > Got it. Then, I agree with the other folks. How can you override the > > > context of the place where you acquired it _from_ with the context of > > > the place where you acquired it _to_? That would seem to be a very > > > important ability... > > > > It would be really nice. Beyond a /noframes version we'd do things like: > > > > 1) Have a /print folder so if we call /print/mypage instead of /mypage > > the result would be a printable version of the page. > > > > 2) A /text folder where all image objects would be replaced by dtml > > methods giving us a text version of a site. > > > > 3) Any kind of /otherDesign folder with a customized version of your > > site. Nice for syndicalization. > > > > 4) A /german folder that have a LANG="de" property to make a german > > version of a site. It would be easy to have a multilingual site. > > > > Is it possible to code a special kind of folder that changes the > > aquisition order? > > One thing I'd like to point out here, is that you are getting into > something very, very deep. This discussion has gone pretty far, but I > still dont get it. What I want to see is a very, very trivial example > of what you want to do, and why you can't do it now. There may be > another solution. A simplified example (with a verbose introduction :-)) i have a web courses product in the making, which should enable teachers to easily use the web; managers of a courses site should be able to provide a consistent look and feel (that is a user interface, standard components etc) A course is a folder (or folderish product or ZClass instance) with just (possibly complex) content. The user interface is responsible for presenting this to the users (students, teachers etc). For a demo in my faculty I wanted to show that 1. making a course and adding components was easy 2. changing the user interface _and_ standard components was also easy Thus facilitating two types of users (managers and teachers) The easiest way to solve this (i thought until peer acquisition got in the way) was to move the user interface part and friends to a department folder. In this way content would be provided through a URL. /courses/demo/dept1 /courses/demo/dept2 where courses, dept1 and dept2 were all on the same level, and dept1 and dept2 used material from the folder above it (such as an indexing method of the objects in the course - in one case a tree and in another a simple list of components). This did not work because the index_html was inherited from the topfolder. What worked was changing the order of the url (and thus of acquisition) from /courses/dept1/demo/ /courses/dept2/demo/ But this broke the tree indexing method, so it was not the solution. I decided I was to stupid for this and made separate folders courses in the respective dept1 and dept2 folders. This worked, but wasn't quite satisfying. hope this clarifies things Rik

1 0

Newbie unable MySQL connection string
by David Robson 23 Sep '99

23 Sep '99

I installed MySQL on Win NT�it went smoothly thanks to Phip Harris�s very clear How-To (http://zope.org:18200/Members/philh/mysql) In the folder I�m trying to use the �Z MySQL Database Connection� function to create a connection. It fails�rejecting my connection string. The Zope server is named SERV3. I�m using the UserName and Password that I use to log on to the server. (All of the conection string parameters refer to traits on the server, none refer to my remote client PC, right?) Below are some unsuccessful connection strings. Suggestions welcome! Dave MySQL@SERV3 UserName UserPW MySQL@localhost UserName UserPW db@SERV3 UserName UserPW MySQL localhost UserName UserPW Db SERV3 UserName UserPW Db 192.168.1.14 UserName UserPW ===== David Robson robson555(a)yahoo.com Computer Support Towson High School, MD, USA __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com

3 2

Possible Insight, DTML Methods and Documents...
by Tony McDonald 23 Sep '99

23 Sep '99

Hi all, thought I'd share this 'insight' - I could be wrong here though, so YMMV... I saw Loren Staffords' "Breadcrumbs How-to" at the new Zope community site, http://www.zope.org/Members/lstaffor/Breadcrumbs and realised that DTML methods are meant to be used as 'fragments' of a document, whilst DTML documents 'pull everything together' into a coherent web page. If I'm right, I think that the default DTML you get when you create a DTML method isn't that apt. I don't think that it should include the standard_html_header and _footer variables, as it's a bit misleading. I know that in some circumstances, you *want* to use a method as a container for your entire page, (ie I know that methods don't have properties and documents do), it just seems that including the _header and _footer parts in the default DTML of a method can be misleading for beginners (if you're a major Zope player, you know what the difference is! :) Am I right or has this curry addled my noodle? Tone

1 0

losing my zen with external methods...
by Tony McDonald 23 Sep '99

23 Sep '99

Hi all, I've got an external method called minicascade: def minicascade(self, tag_id) .... which works fine, ie it renders HTML, if I do something like .../minicascade?tag_id=13228 but if I try this within a DTML Method (I get the same error if I use a DTML Document); <dtml-var "minicascade(tag_id=13228)"> I get  ...  any ideas? this sort of stuff *always* baffles me with Zope, and I end up getting things done by trial and error... Tone ps amazing what a late night curry does for productivity! (or not!) :)

1 0

AUTHENTICATED_USER in zsql db connections?
by Jim Rowan 23 Sep '99

23 Sep '99

I have a database that has security and logging built in -- (It's a postgresql installation); certain people are allowed to update and others are only allowed to read -- and when people update, we keep track of who changed what. I'd like zope to pass through the AUTHENTICATED_USER to the database -- so that the database log will show who did the update/delete/insert just as it does if we use some other interface. I think that means that I want AUTHENTICATED_USER to be part of the database connection string, and that I want each user to use a different instantiation of the connection... Is there any way to accomplish this? (I tried the obvious, making the connection string be dbname@localhost AUTHENTICATED_USER ; that didn't work... :) Jim Rowan DCSI DCE/DFS/Sysadmin Consulting jmr(a)computing.com (512) 374-1143

3 3

Re: [Zope] Install problem with Zope2.0.1
by Anthony Baxter 23 Sep '99

23 Sep '99

>>> Francois Chalaoux wrote > Hi, > I was so happy to install in production a Zope2. It works superfine with > Zserver on my PC and RH6.0 . > when I tried to install Zope2 on my production machine ( My config is PC > i686, RH5.2) I got the following error : It looks like the python install on your production machine is either insane, or old. Make sure you are using Python 1.5.2 on both.

1 0

Testing if property is acquired
by Paulo Eduardo Neves 23 Sep '99

23 Sep '99

Hi, Is it possible to test if a property is acquired? It looks like we don't have access to aq_base from DTML? thanks, -- Paulo Eduardo Neves maito:neves@email.com

1 0

Catalog error
by Joshua Brauer 23 Sep '99

23 Sep '99

Can anybody help with this error?  I'm trying to setup a Workorder tracking system that looks a little like KMNet News in its structure but when I try to add an item (the lowest level of Zclass) in my instance I get the error mentioned above. Joshua Brauer ___________________________________________ Joshua Brauer joshua(a)brauer.org http://www.brauer.org ___________________________________________

1 0