July 2000 - Zope - Zope lists

Zope-killer: zSQL method that crashes Zope
by Andy Gates 21 Jul '00

21 Jul '00

Here's a thing. Those problems I was having with some sort of Zope-killing page have been tracked down to a particular zSQL method. The zSQL method is duff, in that is should fail - the perils of late-night coding on decaf, I fear - but it should fail neatly with a Zope error, not crash out the Python interpreter and force some poor schmuck to restart the limping Zope process. I don't know whether this is a peculiarity to my setup (NT4SP6, IIS4, Zope2, Access97 database) or a general problem; perhaps some of the developer-hatted Zopistas could take a look? The poison SQL is this: select (<dtml-var field>, field2) from tablename where (field1= <dtml-sqlvar parameter1 type=string> and <dtml-var field> <> '') Where two parameters are passed to the method, namely "field" and "parameter1". parameter1 is fed in as a dtml-sqlvar and searches against the table's field1 column. field is passed in as a dtml-var and is used to define which of the table's other fields is retruned. field2 is always returned. What makes the SQL duff is the parentheses around the fields in the first part of the SELECT. They're not required and if you remove them to produce the zSQL below, it works fine. select <dtml-var field>, field2 from tablename where (field1= <dtml-sqlvar parameter1 type=string> and <dtml-var field> <> ' So why does it kill Python? I'm only vaguely concerned now that I've found the fault, because of course the SQL is canned and no developer could get their hands on it - but this experience redoubles my acceptance of the notion of canned SQL! AndyG "I don't suffer from stress. I'm just a carrier."

4 4

RE: [Zope] ZCatalog & dynamic sites
by Chris McDonough 21 Jul '00

21 Jul '00

Dimitris, Yes, ZCatalog cannot index methods which require call arguments. Pages generated from SQL data either use "brains" of SQL methods or squery string arguments of a DTML method, and therefore need to be passed arguments and cannot be cataloged. -----Original Message----- From: dandraka(a)arcas.nuclear.mech.ntua.gr [mailto:dandraka@arcas.nuclear.mech.ntua.gr] Sent: Friday, July 21, 2000 2:44 AM To: zope(a)zope.org Subject: [Zope] ZCatalog & dynamic sites Hi all, I have a Zope site that uses MySQL to dynamically create some pages. What I want is the ability to search throughout the site, INCLUDING the pages that are database-driven. It seems to me that ZCatalog only finds items that exist *in zope*. Is it something ZCatalog can't do or am I missing anything obvious ? -- Dimitris http://atlas.central.ntua.gr:8000/~mc94068

1 0

zzLocale 0-0-3a released on Zope Japan
by Yves-Eric Martin 21 Jul '00

21 Jul '00

Hi Zopistas, This is the second alpha release of zzLocale, a Zope locale support Product. zzLocale provides a framework for Zope interface internationalization (Zope and Products management screens). The localization is done on a per request basis, which allows developers from different countries to work on the same Zope while each of them having an interface in his native language. With zzLocale, Product developers can easily provide localized interfaces for their Products. All that is needed is to put the localized interface DTML templates in a "locales/[lang]" subdirectory of the Product, and zzLocale does the rest. This version of zzLocale is pretty useable, and usually falls back nicely when something goes wrong. However, it is still alpha, and we would not recommend using it on a production server. This release includes a complete (I mean, as complete as current zzLocale features permit) French interface, and a partial Japanese one. Tranlators are welcome to provide other languages. Please send us your translated templates so that we can include them in the next release. For more information and download: http://www.zope.ne.jp/users/yemartin/zzLocale Regards, -- Yves-Eric Martin Digital Garage Inc. yemartin(a)garage.co.jp

2 1

Enitity syntax and 2.2
by Chris Withers 21 Jul '00

21 Jul '00

Hi, Just wondering if the entity syntax has been updated in 2.2 yet so I could do something like the following: &dtml.url-/folder/object/method; cheers, Chris

4 9

ZUBB/Ztree permission problem
by Riku Voipio 21 Jul '00

21 Jul '00

Unless the ZDiscussion object has Anonymous/access information permission, nobody, including manager and owner, can't access the The Zdiscussion which has any content. running ZDiscussions-0.3.2 on Zope 2.1.6-5 Debian/Frozen. traceback follows: Traceback (innermost last): File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/lib/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: index_html) File /usr/lib/zope/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: index_html) File /usr/lib/zope/lib/python/DocumentTemplate/DT_String.py, line 504, in __call__ (Object: index_html) File /usr/lib/zope/lib/python/TreeDisplay/TreeTag.py, line 154, in render (Object: a tree tag) File /usr/lib/zope/lib/python/TreeDisplay/TreeTag.py, line 245, in tpRender (Object: ElementWithAttributes) File /usr/lib/zope/lib/python/TreeDisplay/TreeTag.py, line 321, in tpRenderTABLE (Object: ElementWithAttributes) Unauthorized: [0, 1, 2, 3] -- Riku Voipio riku.voipio(a)tietoenator.com 09-862 60764

1 0

Re: [Zope] all DTML Methods of current folder and subfolder
by Gerard Metrailler Jr. 21 Jul '00

21 Jul '00

Hello, At 07:21 21.07.2000 +0000, Wolfgang Klinger wrote: >I have a dtml method in a folder which should >display all "document_title"s of all >"DTML Method"s in the current folder and >all sub folders! > >(should work as navigation frame) > >How can I do that? > >I tried ><dtml-in "Info.objectValues(['DTML Method'])"> >where "Info" is the current folder where the >method itself is stored >but that didn't work ... :-( Try using PARENTS[0] instead of Info if you want to display the current folder content. I am using the following (with a few sorting options for the dtml-in tag) in a ZClass (inheriting from CatalogAware and Folder) I created to render the content of the current folder. <dtml-in "PARENTS[0].objectValues(['DTML Method'])"> <dtml-var title_or_id> </dtml-in> Best regards, Gérard Métrailler Jr.

2 1

namespace problem??
by Marcus Mendes 21 Jul '00

21 Jul '00

Hello, How can I get the contents of variable out of my <dtml-in> </dtml-in> code? For example: <dtml-in "_['sequence-item'].objectValues(['TSubRegiao'])"> <dtml-call "REQUEST.set('HORA', horacondicaoatual)"> </dtml-in> I need get the variable HORA and I couldn't. Thanks Marcus Mendes

1 0

namespace ??
by Marcus Mendes 21 Jul '00

21 Jul '00

Hello, How can I get the contents of variable out of my <dtml-in> </dtml-in> code? For example: <dtml-in "_['sequence-item'].objectValues(['TSubRegiao'])"> <dtml-call "REQUEST.set('HORA', horacondicaoatual)"> </dtml-in> I need get the variable HORA and I couldn't. Thanks Marcus Mendes

1 0

second step (many of You are going to laungh ;-)
by Vincent 21 Jul '00

21 Jul '00

Hi, I just download Zope today, and I am wondering how I am going to start toding something. May somebody tell me whath is the first step to do to put a custom HTML page into ZOPE ? (I started the server, I can access the 'manage' tools -> server:8080/manage), I guess I need to creat my HTML page with notepad, ultraedit or whatever, but the next step ? Creat a ZOPE object linked to this HTML page ? No idea how to do that... Thanks a lot Vincent

4 3

(XML-RPC) Calling Database.manage_pack
by Oleg Broytmann 21 Jul '00

21 Jul '00

Hello! I wrote a simple script to pack Data.fs on a regular basis. It is very simple, actually, just urllib.urllretrieve("http://my.zope/Control_Panel/Database/manage_pack?days:float=3") (a little bit harder than that, but I did it) Now I am trying to achieve the same with XML-RPC. No luck. How can I pass "days" parameter? server = xmlrpclib.Server("http://my.zope", BasicAuthTransport(login, password)) server.Control_Panel.Database.manage_pack(3) does not work - Zope returns an error abou invalid value, server.Control_Panel.Database.manage_pack(days=3) does not run at all - args expected to be a list, not a hash... Oleg. (All opinions are mine and not of my employer) ---- Oleg Broytmann Foundation for Effective Policies phd(a)phd.russ.ru Programmers don't die, they just GOSUB without RETURN.

1 0