- Zope - Zope lists

RE: [Zope] How to execute multiple SQL statements in one SQL-Method ?
by Mabe, Brad 18 Aug '00

18 Aug '00

SQLSTATEMENT 1 <dtml-var sql_delimiter> SQLSTATMENT 2 -----Original Message----- From: Stuart Foster [mailto:stuartafoster@home.com] Sent: Friday, August 18, 2000 1:14 PM To: Zope List Subject: [Zope] How to execute multiple SQL statements in one SQL-Method ? I know it can be done but forgot how. Stuart _______________________________________________ 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

How to execute multiple SQL statements in one SQL-Method ?
by Stuart Foster 18 Aug '00

18 Aug '00

I know it can be done but forgot how. Stuart

1 0

Setting Default Properties in a Product
by Robert_J_Roberts＠rl.gov 18 Aug '00

18 Aug '00

I have a product I have created. When creating an instance of the product, there are several property field which I pre-populate with default values. Those default values are currently set in my __init__() function. I would like to allow the users to redefine the defaults at the product level. How do I add a default properties page to my product so the user can set them in /root/Control_Panel/Products/{MyProduct} so that each new instance of that products uses their defaults and not my hard-coded defaults? Robert J. Roberts robert_j_roberts(a)rl.gov

1 0

Merging multiple catalogs
by Andy McKay 18 Aug '00

18 Aug '00

Before I go off into coding mode has anybody had to deal with merging results from multiple catalogs? I have several catalogs and I would like to make this transparent by only having one search results interface. I quickly made one Catalog indexing multiple Catalogs but the result is multiple sets of records returned... Thanks. -- Andy McKay, Developer, ActiveState http://www.ActiveState.com Programming for the People

1 0

RE: [Zope] Strange behaviour on authorization
by Casey Duncan 18 Aug '00

18 Aug '00

Jarkko Veijalainen wrote: > i have been trying to figure this out and get help to this almost one > week... ... > Zope loads login form with no problem (it's basicly static page) but when i > try so POST data to email_headers with login form, popups Authorization > failed window. I have tried to use my manager and superuser name and same > values that i submitted, but nothing is accepted to auth. window. ... > so i have authenticated user and i still can't login. All these documents > work like they're supposed to in Zope 2.1.6, but not anymore when i > installed Zope 2.2.0 on Solaris. Why is Zopesecurity trying to validate > 'cn', which is value that i submit to another document. > > What went wrong here and how i fix this problem? Aha, it worked in 2.1.6 eh? That's the tip off. A *major* change between 2.1.x and 2.2.x is in the security dept. 2.2.x runs all methods using the security level of the _owner_ of the method, regardless of whether this is a lower or higher level than the currently authenticated user. My guess is that your method has no owner (which is what pre-2.2.x objects default to when run under 2.2.x). This means it is running as anonymous which does not have rights to do what you want. Specify an owner for the method that has sufficient rights to do what you want and try it again. Good luck, -Casey Duncan

1 0

Re: [Zope] [Ann] Another Zope Book
by Max Møller Rasmussen 18 Aug '00

18 Aug '00

Fra: Kapil Thangavelu [mailto:kthangavelu@earthlink.net] >I think most developers are forced to learn >through trial and error because the docs don't do the components justice >since they tend to focus on working understanding of zope's framework >from dtml. and in the end they are forced to turn to the source which >can be confusing without knowing the parts of the framework from a >fundamental not a working perspective. >comments? 2 right you are. We need more info about Zope from a Python programmers POW. Setting pages up in dtml is not that interresting from my point of view. We need more detailed documentation on all the seperate modules, and far more/better on making products. dtml is not for programming and business logic, only for presentation. Max M

2 1

Re: Xron test
by Loren Stafford 18 Aug '00

18 Aug '00

Nick, Two other Zopistas reported similar problems. Both succeeded eventually in getting Xron started, but we didn't succeed in diagnosing the problem, nor in determining precisely how to work around it. I myself haven't been able to reproduce the problem. The problem seems to occur only on Linux, but it does not always occur. Some users have successfully started Xron on Linux with no problem. The problem seems to have to do with contention for a lock on ZODB. Did you see any log or console message that would confirm this? One user went to the console and killed all the Zope processes that were running at the time, then restarted Zope from the command line. The second time, Zope started up correctly with Xron. Another user thought that he had mistakenly tried to start Zope while logged in as root. When he restarted as a different user, Zope started up with Xron correctly. I suspect that the user was not relevant to the Xron problem (it is normal in some installations to start as root), but that the restarting was the key. One user thought that the monitor process contributed to the lock contention. I don't know, but it might be worthwhile to try to restart Zope without the monitor (changing the start-up options to disable the monitor). The problem seems to relate to Xron's creating the Schedule catalog the first time the Xron product is loaded during Zope start-up. If you succeed in creating the Schedule one time, the problem will not recurr, as Xron will just use the existing Schedule. I hope that helps you get started. Let me know how it goes. I'll copy this email to the zope list in hopes that someone else can shed some light on the problem. -- Loren ----- Original Message ----- From: "Nicholas Lo" <nicklo(a)siliconcreation.com> To: <lstaffor(a)dynalogic.com> Sent: August 18, 2000 12:41 AM Subject: xcron test > Hi Loren, > > I have a problem with installing Xron 0.9 onto my machine. Currently, > I'm running SuSE Linux 6.4 on a 600MHz/128Mb/20Gb PC. I have followed > the release note and set the STUPID_LOG_FILE environment variable to > point the log file, and Xron itself is, of course, resides in the > /Products directory. When I start Zope, the console looks okay. However, > the browser keeps on loading and loading and could not show the Zope > management screen. I have also tried Xron on my notebook, which is > running Win98. Everything works just fine. I just wonder what's gone > wrong. > > Thanks. > > Nick >

1 0

Can't change title of a common instance property sheet
by Jeff Sasmor 18 Aug '00

18 Aug '00

I suppose this is some sort of lack in the Zope management UI, but maybe someone else knows how to do this: If you create a ZClass property sheet you can pick an ID and a title. But you don't seem to be able to EDIT the title of the property sheet ever again. Is there some magic property sheet property name or is there just no way to edit the title from the management interface? The other bizzare thing is that you can export a property sheet, but there seems no obvious way to import one anywhere. Anyone have a clue on this? What's it there for? TIA Jeff Sasmor jeff(a)sasmor.com

1 0

Pb getting local roles ... strange
by Didier Georgieff 18 Aug '00

18 Aug '00

Hello, I'm on 2.1.6. I'm trying to have an information box with all roles. <dtml-in "AUTHENTICATED_USER.getRoles()"> <dtml-var sequence-item> </dtml-in> works OK. But doesn't give the local roles. So i tried <dtml-with URL0> <dtml-in "get_local_roles()"> <dtml-var sequence-item> </dtml-in> </dtml-with> But it only gives ['owner'] and not the other local role ['roleFoo']. But the response is correct if i test with <dtml-if "AUTHENTICATED_USER.has_role('roleFoo',this())"> is True. Is it a bug or a misunderstanding ? I found nothing on the archives. Thanks in advance. -- Didier Georgieff DDAF du Bas-Rhin - Cellule SIG 2, rue des Mineurs 67070 Strasbourg Cedex tél : 03.88.25.20.33 - fax : 03.88.25.20.01 email : didier.georgieff(a)agriculture.gouv.fr GéoWeb http://10.67.90.3 (Intranet Agriculture) GéoWeb http://sertit10.u-strasbg.fr (Internet)

2 1

Add a folder anywhere from anywhere
by Francois-Regis CHALAOUX 18 Aug '00

18 Aug '00

Hi, USE CASE ======== How to test if an "idFolder" exist in my "topFolder"? If the "idFolder" does not exist I would like to add it to "topFolder" Question ====== Who know why this code in an external method (EM) does not work? Code ==== def addFolder(self, idFolder, topFolder): self=self.this() if not hasattr(topfolder,idFolder): self.getattr(self,topFolder).manage_addFolder(idFolder) PS: How to add a folder anywhere in the ZODB tree with an EM also located anywhere? Bye, FR.

1 0