- Zope - Zope lists

Re: [Zope] Help with Nested ZSQL methods
by Pavel V. Piankov 29 Nov '00

29 Nov '00

try calling like this : <dtml-in "sql_get_items(_.None,_)"> also you might what to use dmt-sql var instead of dtml-var inside ZAQL Methods. regards -- pashah >Here's the operative part of the dtml method that calls these methods: >============================================== ><dtml-in sql_get_schedules> > <TABLE BORDER="3"> > <TR><TH>Item No.</TH><TH>Description</TH><TH>Mn/DOT >No.</TH><TH>Units</TH></TR> > <dtml-in sql_get_items> > <TR> > <TD><dtml-var ItemNo></TD> > <TD><dtml-var Description></TD> > <TD><dtml-var MnDOTNo></TD> > <TD><dtml-var UnitDescription></TD> > </TR> > <dtml-in> > <TABLE> ></dtml-in> >============================================== > >I get the error: > >Error Type: Bad Request >Error Value: ['SchedID'] > >I suspect there is some type of namespace-related problem going on here >where the var SchedID is not getting passed to the internal ZSQL method. > >P. Johnson

1 0

ZopeFind expression
by Oliver Bleutgen 29 Nov '00

29 Nov '00

I fear this is anywhere in some howtos, but I couldn't find it. How can I get properties of a DTML-Documents parentfolder as expression in ZopeFind? At least I couldn't get the "Find" in Zope's webinterface to show all DTML-Documents whose parent-folder has a certain property. I guess I'm missing a method which gives me the Parent-object without the REQUEST object. cheers, Oliver

1 0

Re: [Zope] VHost logs.
by Oliver Bleutgen 29 Nov '00

29 Nov '00

> Jason C. Leach wrote: >> hi, >> >> Has anyone implemented there own logging for Virtual Sites? >> >> I was thinking in the site rules an External Method could be called, >> passed the Request obj, and from that generate logs for virtual sites. >> >> If anyone has done that, or knows of a better way I'd be interested in >> hearing it. > I'm not exactly sure what your goal is... but if you're just trying to > generate separate log files for each of your virtual sites, I'm > accomplishing > that by having my virtual sites proxied behind Apache (using SiteAccess > and > the ProxyPass directive) and specifying the log files for each VirtualHost > in > my httpd.conf file. You can control the contents of the logs using the > LogFormat directive; I use the same format for all of my virtual hosts, > but I > think you can specify a different log format for each host if you desire. > If you're trying to accomplish something else which requires you to handle > the > logging on the Zope side of things, then it seems to me that your idea > would > work, although I'd want to find out how my server performance would be > affected... I also would prefer to split the log via regexp-filters just before doing statistics or rotating (ie. not in zope). A pure logfile doesn't reveal useful informations anyway without some processing. Related question: Is there away to stop zope's logging, as apache as proxy logs fine for me? cheers, oliver

1 0

Help with Nested ZSQL methods
by paul_s_johnson＠urscorp.com 29 Nov '00

29 Nov '00

I thought I saw this answer to this one time on http://www.zope.org once, but for the life of me I cannot seem to find it. I have two ZSQL methods, both tested and work. ZSQL method 1 =========================== method id= sql_get_schedules SELECT * FROM Schedules WHERE JobID = <dtml-var JobID> ORDER BY SchedSeq ZSQL method 2 =========================== method id= sql_get_items SELECT * FROM Items WHERE SchedID = <dtml-var SchedID> ORDER BY ItemNo These two tables are linked by the common field "SchedID" Here's the operative part of the dtml method that calls these methods: ============================================== <dtml-in sql_get_schedules> <TABLE BORDER="3"> <TR><TH>Item No.</TH><TH>Description</TH><TH>Mn/DOT No.</TH><TH>Units</TH></TR> <dtml-in sql_get_items> <TR> <TD><dtml-var ItemNo></TD> <TD><dtml-var Description></TD> <TD><dtml-var MnDOTNo></TD> <TD><dtml-var UnitDescription></TD> </TR> <dtml-in> <TABLE> </dtml-in> ============================================== I get the error: Error Type: Bad Request Error Value: ['SchedID'] I suspect there is some type of namespace-related problem going on here where the var SchedID is not getting passed to the internal ZSQL method. P. Johnson P.S.: I must Lotus Notes ( http://www.iarchitect.com/lotus1.htm ) at my place of employment. Any errantly inserted HTML or other weird garbage not intentional.

1 0

exchange parameters between DTML Documents
by Andrei Belitski 29 Nov '00

29 Nov '00

HI! In dependance of a link I would like to pass some document name as parameter to another DTML Document which displays for example the properties of the parameter document. How can I do it? I would appreciate any hints, thank you in advance

2 1

Zope restarting itself?
by Martin Winkler 29 Nov '00

29 Nov '00

Hi listies, maybe someone of you heard of a feature that Zope can restart itself when it dies abnormally. (Linux/Unix version). I found such a service for Windows NT, but not for Linux, although I am sure that I saw it a while ago somewhere... Is this just a parameter for z2.py or is there a special program for this task? Hoping for help, Martin -- Sent through GMX FreeMail - http://www.gmx.net

3 2

ANNOUNCE: Zope 2.2.4 (final) released...
by Brian Lloyd 29 Nov '00

29 Nov '00

Hello all, Zope 2.2.4 has been released - you can download it from Zope.org: http://www.zope.org/Products/Zope/2.2.4/ This release supercedes the 2.2.3 release, which had an error that prevented permissions from being acquired correctly. Until the testing infrastructure that has been started in the 2.3 CVS is more mature and there is a useful regression test rig, we'll be planning for at least one (short) beta period for third-dot releases. This bug-fix release contains the fixes for all released Hotfixes to date, as well as fixes for a memory leak in the Acquisition module, various ZCatalog fixes and a fix for the infamous "__call__" bug. It also contains a fix for a problem in header parsing in the dtml sendmail tag that has affected some users recently. The problem with caching of ImageFile objects (mainly icons in the Zope management interface) in the 2.2.4 beta is also fixed (and verified using the Cacheability Engine (http://www.web-caching.com/cacheability.html) For more information on what is new in this release, see the CHANGES.txt and HISTORY.txt files for the release: - http://www.zope.org/Products/Zope/2.2.4/CHANGES.txt - http://www.zope.org/Products/Zope/2.2.4/HISTORY.txt Note that we have also posted "diff" updates as .tgz files that will let you easily upgrade an existing 2.2.x site. These updates are available for those currently using the 2.2.x source release or the 2.2.x binary releases. To apply a differential update to your site: - download the appropriate .tgz file from zope.org - shutdown your Zope process - copy the .tgz to your Zope directory and extract it - run w_pcgi or wo_pcgi *if you are not using a binary release* - restart your process Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 2

Help!!
by Ot Ratsaphong 29 Nov '00

29 Nov '00

Hi, I'm new to Zope and have just installed Zope on a Win98 PC. I'm trying to install squishdot and TinyTable, but Zope tells me that superuser has no permission to install the above products. I have created another user called 'admin' with Manager priviledges but I don't know how to logout of superuser and login as 'admin'. I have tried shutting down Zope and closed off internet explorer and restarting again but I still get into superuser. If I need to login as a non superuser, how do I do this? I have looked for all relevant documentation but can't find anything on this. Your help would be appreciated. TIA Ot Ratsaphong Canberra, Australia

5 5

Re: [Zope] [BUG] [Zserver] GET and HEAD give different MIME types
by Hamish Lawson 29 Nov '00

29 Nov '00

Martijn Pieters wrote: > Note that you don't want the DTML code to be called on a HEAD request; > it may have side effects a mere tpc_abort won't roll back. If the implication here is that the corresponding GET request could have meaningful side effects (i.e. not just changes to caches, logs or hit counters), then strictly it would be breaking the semantics of GET, which is meant to be idempotent - capable of being called multiple times without meaningfully changing the state of the server-side system or application. Requests that can change the state are supposed to use POST. Hamish Lawson

1 0

Re: [Zope] strange behaviour of ZSQL methods
by Oliver Bleutgen 29 Nov '00

29 Nov '00

> At 15:30 29.11.2000, Oliver Bleutgen wrote: >>You didn't tell what SQL-Database you use, but Postgres and Mysql allow >>logging/monitoring of the queries they get. So you are able to get the >>information straight before/while it hits the backend. > Yes, I'm using Postgres - just discovered the "-o"-flag, but I don't know > exactly how to log all SQL-queries right now. Guess, I'll read a bit in > the > Postgres book and the manpages. Perhaps this spares some time, digged out of my .bash_history, a relic from LoginManager experiments (really handy there...). First stop postgres and then ... /usr/local/pgsql/bin/pg_ctl -o "-i -d 3" -D /var/lib/pgsql/data start (YMMV with the path etc...) This logs everything to the console. You can vary the debugging level, 3 is a bit "vocal", try 2. cheers, oliver

1 0