March 2000 - Zope - Zope lists

get OUT args from ZOracleDA
by Chien-pin Wang 21 Mar '00

21 Mar '00

Hi, I have Zope 2.1.5 and Oracle 8.0.5 running on the same Linux box. ZOracleDA was installed successfully and bridged Zope and Oracle. I can call my stored procedure by creating Z SQL Method like: begin procName(arg1, arg2,...); end; But I cannot get return arguments (OUT args) no matter how the Z SQL Method is set. I have tried the interfaces mentioned in DCOracle documents, but failed. The only work-around I've found is creating extenal methods and import DCOracle via python. Is there any way to get the OUT arguments from Z SQL Method? Thanks a lot! Chien-pin

1 0

ZClasses and clone/delete methods
by John Morton 21 Mar '00

21 Mar '00

I need to know whether I can set up clone and delete methods in a Zclass that automatically get invoked any time someone deletes or copies an instance of that class from the management interface (via cut and paste or whatever). What I'm doing is creating a simple link class that just stores the key to a RDBMS row that contains all the details of the link (description, URL, clickthrus etc). The trouble is that when a link is deleted from Zope, it needs to touch the db record or that record will become orphaned - ideally the db record needs to keep a reference count of the number of link objects out their, and they need to increment or decrement that count as they get copied and deleted. So can this be done with a ZClass (if not, why not :-)) and if it can't, how can I do this with a Python Product (given that I've never written one!). TIA, John.

1 0

LocalFS v0.1.7 released
by Jonothan Farr 21 Mar '00

21 Mar '00

I've released LocalFS v0.1.7. It hasn't been tested extensively so I've left the bits for v0.1.6 up on the site. I'm just too excited to wait. :) The url is: http://www.zope.org/Members/jfarr/Products/LocalFS Enhancements in v0.1.7: - Added the ability to customize mappings between file extension, content-type, and Zope object class. - Added the ability to customize content-type to icon mappings. - LocalFS objects now work with the <dtml-tree> tag, so they can be traversed using the navigation menu. (plus a few bug fixes) If you try it out please let me know what you think or if you find any problems. Thanks, -jfarr

1 0

Re: [Zope] worldpilot problem.
by rossini＠biostat.washington.edu 21 Mar '00

21 Mar '00

>>>>> "JS" == John Sutherland <garion(a)garion.mnb.tzo.net> writes: JS> I log into worldpilot, and then the page taht normally has the JS> list of emails in the inbox folder comes up, but with a Zope JS> error message... Traceback as follows: <-- deleted --> JS> Any ideas?? I saw a nearly identical traceback, as well. You might have to: 1. play with the imap settings (probably need to change the LS* variable in IMAPHACK.py, can't recall it's exact name) 2. make sure you are running 1.0.4 (a fairly recent version). best, -tony -- A.J. Rossini Research Assistant Professor of Biostatistics Biostatistics/Univ. of Washington (Th) Box 357232 206-543-1044 (3286=fax) Center for AIDS Research/HMC/UW (M/F) Box 359931 206-731-3647 (3693=fax) VTN/SCHARP/FHCRC (Tu/W) Box 358080 206-667-7025 (4812=fax) rossini(a)(biostat.washington.edu|u.washington.edu|hivnet.fhcrc.org) http://www.biostat.washington.edu/~rossini

2 1

Re: [Zope] Sybase: How generate id keys? (surrogate keys)
by Hung Jung Lu 21 Mar '00

21 Mar '00

>From: "Ross Lazarus" <rossl(a)med.usyd.edu.au> >identity fields are self-incrementing >check out http://sybooks.sybase.com/onlinebooks/group-as/srg1100e/sqlre >f/@Generic__BookTextView/64752;hf=0;cs=default;ts=default#X Unfortunately the IDENTITY column is not a good option. According to our local Sybase expert, The IDENTITY columns are just too buggy to use, even after the newer releases of Sybase. They cause too many troubles, that is why we are looking at alternatives. In older versions of Sybase, the problems were so severe that they would cause the database server to crash. Some drawbacks that were mentioned: (some are fixed, but these are not the only problems...) (1) When database server crashes, apparently the IDENTITY column jumps to the next block of values, so the table index space become sparsely populated, and you may hit the roll-over situation earlier than expected. (2) When using BCP utility to download and upload tables, there are some problems with the IDENTITY columns, too. (3) It is hard to access the values of the IDENTITY column when you are in multiple SQL statements. Anyway, there seem to be too many problems, so the IDENTITY column approach has been discarded. :( regards, Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Proxy Roles
by Suneel Iyer 21 Mar '00

21 Mar '00

Hello all, I have the following code fragment in a method called CategoryCustomizationForm contained in the folder /News: <dtml-if preferences_saved> <hr> <b> Your preferences have been saved </b> <hr> <dtml-call "manage_changeProperties(preferences_saved=0)"> </dtml-if> where "preferences_saved" is a property of the folder /News. In the folder /News, the security view verfies that the permission of "Manage properties" is allowed only by those in the "Manager" role. In order to allow all authenticated users to use the "manage_changeProperties" method in "CategoryCustomizationForm", I assigned the proxy role of "Manager" to "CategoryCustomizationForm". However, zope still only allows users in the role of Manager to access "manage_changeProperties" in my form. In other words, the proxy role assigned to the method "CategoryCustomizationForm" failed to override the permissions of its containing folder /News. As a temporary fix, I gave the "Authenticated" role permission to "Manage properties" in /News. This works with regards to allowing all authenticated users to access "manage_changeProperties" in my form. However, in the long run, I don't want all authenticated users having manager type access to all properties of /News. I have this failure of proxy roles in other areas of development too, such as dtml creation of folders via manage_clone. Is there something I'm missing about how to use proxy roles? Thanks for your time. -- Suneel Iyer Email : suneeli(a)pacsg.css.mot.com Software Engineer Phone : (847) 523-7259 Advanced Technology Software Operations Fax : (847) 523-3867 Motorola Cellular Subscriber Sector Pager : 1-800-759-8352, pin 1273286 600 North U.S. Hwy 45, MS AN363 or email 1273286(a)skytel.com Libertyville, IL 60048-1286

1 0

my zope has got no pid!
by Steffen Lemke 20 Mar '00

20 Mar '00

Hello there, something's strange with my zope. I am running zope as my personal zope-user (at least I have started it this way) but I don't get any pid if I say "ps -a". And I cannot stop the server because the script tells me kill: xxxx - no such pid? What's wrong with it?? Is there any additional flag I have to set or unset in the standard-scripts? Thank you for your help, Steffen

3 2

(no subject)
by tolga sonalp 20 Mar '00

20 Mar '00

Well, I've downloaded and installed Zope on my windows9x and I can't run it. Of course there is no executable component. start.bat and now ... how to use the zope on my windows9x and I wanna learn What,why,how ...... thnx.

3 2

Next try at user auth and role creation
by Oliver Andrich 20 Mar '00

20 Mar '00

Hi, sofar I solved the creation process of user accounts. This was quite easy after I read the code for this. But now I have problems adding new roles via a specialized interface. I setup tghe REQUEST object correctly, then I call manage_defined_roles and I get various errors. Is their any method at all to create Roles besides the management interface of Zope or via External Methods? Setting local roles is easy, but I can get the role added to the system at all. Any help appreciated. Thanks a lot. Bye, Oliver

3 4

Job Opportunity: New Times, Inc.
by Tony Rossignol 20 Mar '00

20 Mar '00

New Times, Inc. is looking for a Web Developer with Zope/Python experience, to work in the Phoenix, AZ corporate offices. Linux, MySQL, Apache, and Perl experience are all big plusses. We are looking for candidates who have a passion for the web and enjoy solving real world problems. Please send resume and cover letter to tonyr(a)ep.newtimes.com. -- ------------------------------- tonyr(a)ep.newtimes.com Director of Web Technology New Times Inc. -------------------------------

1 0