November 1999 - Zope-Dev

ZOracleDA and select LONGs, for more than one row.
by Anthony Baxter 03 Nov '99

03 Nov '99

(wah. www.zope.org/Collector gone away) Can someone verify that I'm not going insane? Doing a select on a table with a column of type LONG works, but only where the select returns a single row. Any that returns more than one row breaks with an IndexError (exception included below). given the following table: SQL> desc testlongs ; Name Null? Type ------------------------------- -------- ---- ID NUMBER(38) DATA LONG And the following SQL method: select * from testlongs It works when there's only one row in the result. SQL> insert into testlongs values ( 1, 'helllohelllohellllhelllohelllohelllohehellohello' ) ; SQL> insert into testlongs values ( 2, 'helllohelllohellllhelllohelllohelllohehellohello' ) ; select * from testlongs where id = 1 works. select * from testlongs where id = 2 works. select * from testlongs where id < 3 fails, with exceptions.IndexError: 1 Traceback (innermost last): File /export/zope/zope2/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /export/zope/zope2/lib/python/ZPublisher/Publish.py, line 176, in publish File /export/zope/zope2/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: testlong) File /export/zope/zope2/lib/python/ZPublisher/Publish.py, line 161, in publish File /export/zope/zope2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /export/zope/zope2/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /export/zope/zope2/lib/python/Shared/DC/ZRDB/DA.py, line 316, in manage_test (Object: testlong) File /export/zope/zope2/lib/python/Shared/DC/ZRDB/DA.py, line 297, in manage_test (Object: testlong) File /export/zope/zope2/lib/python/Shared/DC/ZRDB/DA.py, line 401, in __call__ (Object: testlong) File /export/zope/zope2/lib/python/Products/ZOracleDA/db.py, line 202, in query File /opt/zope/zope2/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 340, in fetchmany File /opt/zope/zope2/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 311, in fetchone IndexError: (see above) I've had a look at the code, and I really really can't see what's going on here. Anyone? Anthony

4 3

Questions on XML and XSL
by Gilles lavaux 03 Nov '99

03 Nov '99

Hello, Is someone successfully using .XSL to format a XML documents? If yes the document probably look nice, but how does it looks during editing?? Is there some demo online where it is possible to edit a XML document, modify/add/delete nodes? (I used the sax python library to do it, but without XSL/CSS the document looks ugly) The only library I found for XSL and python is 'xslpattern', has anybody used it? Thanks for any hint. Gilles lavaux

1 0

Re: FW: [Zope-dev] pam authentication support with PyPam
by Michel Pelletier 03 Nov '99

03 Nov '99

Alexander Staubo wrote: > > Have you given any thoughts to my comments? Yes, sorry for the delay. > > > > > There are two aspects of the current security subsystem that bug me. > > > > The first is the fact that only user folders are accumulative > > only at folder boundaries. You cannot create one UserFolder > > and one NTUserFolder at the same level and have them co-opt > > the user authentication responsibility. I think this is a good idea, I wonder if the Generic User Folder recently prototyped (hey, who did that? I can't find any artifacts to it anywhere) does this. > > > > The second, more serious gripe is with the security > > permission model. Look at NT 4.0 and the security UI that > > comes with SP4/SP5's Security Configuration Manager for a > > good example (installing it will upgrade NT's security > > dialogs with a new UI). <snip good stuff> There are really deep and fundamental issues, I can see exactly what you're talking about, but implimentation could take a while, last time i looked at the security system I shuddered. Have you looked into implimentation? This is sort of a seperate issue from the user folder abstraction thing. -Michel

2 1

Pointer-to-Object Properties, ObjectManagers and Z2 Conflicts
by gtk 02 Nov '99

02 Nov '99

[Jim -- some detail on tangled objectmanagers?] > A small step up from this is to replace the second list (a list > of authors in a Book object) with a Catalog. The Book can determine all > of it's authors by searching the index of 'book-list' properties. > > With this change you never break data integrity by changing the list, > although it is possible to break it by deleting a Book. All you need to do is arrange for self.unindex_object to be called by self.manage_beforeDelete, I think. Oh, wierd! I just figured out why it's so hard to untangle the relationship between ObjectManagers and their children. The children are stored as attributes of the ObjectManager itself, NOT in a dict. This makes some sense from an acquisition point of view, but probably means that there are a whole bunch of "reserved ids" like manage_beforeDelete. Error Type: Bad Request Error Value: The id manage_beforeDelete is invalid - it is already in use. Yup! Can anyone tell me why Zope doesn't use __getattr__ to handle access to children of ObjectManagers and store the mapping to those children in a dictionary? That way we might have half a chance of preventing ZODB conflicts when adding multiple children simultaneously without losing the protection of ZODB conflicts when overlapping transactions try to modify the same attribute. Regards, Garth. -- <gtk(a)well.com>

1 0

Help with Sendmail Mail!
by Victor.Zhai＠ogilvy.com 02 Nov '99

02 Nov '99

Hi, my name is Victor, and I'm a programmer and developer for an Interactive agency in China. This is my first time working on a Zope-based project. Due to my lack of Zope experience, I've been getting into some problems, and I hope your experience can help me. My SendFeedback.dtml file is: <dtml-sendmail smtphost="firewall.ogilvy.com.cn"> To: Feedback Recipient <cosix(a)tonghua.com.cn> From: Zope Feedback Form <zgxbj(a)yahoo.com> Subject: <dtml-var subject> Comments: <dtml-var body> </dtml-sendmail> <h1>Thank you for your input!</h1> <p>Your comments have been sent.</p> My Feedback.dtml file is: <H2>We want your input!</H2> <form action=SendFeedback> Your Name: <input type=text name="subject" size=40> <br> <textarea name="body" rows=10 cols=50> </textarea> <br> <input type=submit value="Send Feedback"> </form> This does not work after display the information: "Your comments have been sent".I have not get one mail yet.Why! "WorldSecure Server <ogilvy.com>" made the following annotations on 11/02/99 07:04:34 ------------------------------------------------------------------------------ Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor endorsed by it. ==============================================================================

2 1

Re: [Zope-dev] Help with Sendmail Mail!
by Simon Michael 02 Nov '99

02 Nov '99

Victor.Zhai(a)ogilvy.com writes: > To: Feedback Recipient <cosix(a)tonghua.com.cn> > From: Zope Feedback Form <zgxbj(a)yahoo.com> Does it work if you use: > To: cosix(a)tonghua.com.cn > From: zgxbj(a)yahoo.com ? I think the sendmail tag is a bit fragile in 2.0. If I remember correctly it ignored the subject header too - add a body='Subject: ' + subj + '\n' + body to SendMail.send() in MailHost.py Also, if possible test against an smtp server where you can access the logs - this will help figure out what's going on.

1 0

Job announcement: Zope programmer
by Bjorn.Stabell＠ogilvy.com 02 Nov '99

02 Nov '99

Hello, OgilvyInteractive is seeking people enthusiastic and knowledgable on Internet technologies, in this case especially Zope, to join their team in Beijing, China. We can offer a competitive package, challenging and fun work, in a great environment. OgilvyInteractive is expanding rapidly and has the unique feeling of a small and exciting internet startup, but with the safety of a big company. Our clients include foreign multinationals (IBM, Nokia, Kraft, ...) as well as many local brands. OgilvyInteractive has 1,000 employees world-wide and is headquartered in New York. Applicants should speak and read Chinese. Please send applications to vivien.fan(a)ogilvy.com Kind regards, -- Bjorn Stabell <bjorn.stabell(a)ogilvy.com> CTO OgilvyInteractive, Beijing, China "WorldSecure Server <ogilvy.com>" made the following annotations on 11/02/99 01:38:07 ------------------------------------------------------------------------------ Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor endorsed by it. ==============================================================================

1 0

In search of an exchange server
by Ben Leslie 02 Nov '99

02 Nov '99

Hi everyone, In the recent days I have been heavily revising/updating the NotMail product. A new version should be available in the next few days. I am working in a Linux environment and as a result have only been able to test the product aginst the UW Imap server. Whilst I have tried to follow the IMAP standrad I would like the ability to test against an Exchange server as well. If anyone out there would be kind enough to give me a guest account on an exchange server for a couple of days so I can thoroughly test NotMail before releasing it I would really aprreciate. Cheers, Benno

1 0

Comparison: Frontier vs. Allaire Spectra
by Patrick Phalen 02 Nov '99

02 Nov '99

http://discuss.userland.com/msgReader$12608

1 0

PTK Packaging Thought
by Kevin Dangoor 01 Nov '99

01 Nov '99

Hi, In working on KM|Net News, it has come to my attention that ZClass-based products are very easy to modify, but not very easy to upgrade once you have made changes. You could subclass the ZClasses, and make your changes in there. But, your new ZClasses have to be in the same product (making upgrades more difficult) and, if there is a factory, both ZClasses show up in your add list. I think this will be pretty relevant to the PTK. Let's say that the "News Item" does just about everything I can do with KMNN, but does not have the feature that allows readers to rate the articles. It would be nice if there was a mechanism allowing me to create my own extended News Item with extra properties and methods, but to still be able to easily upgrade when new versions of the PTK are released. Maybe a solution is to have ZClasses be subclassable between Products (even if there is no factory). Then, the PTK Product could have the basic "News Item", but the Zope user can subclass this in their own Product and delete the original factory so that only their new News Item shows up. Upgrading then becomes easy... just drop in the new Product and remove any unwanted factories. Does any of this make sense, or have I had a little too much Halloween candy? Kevin

2 1