July 1999 - Zope - Zope lists

RE: [Zope] Bulk insert in Zope's ZPyGres
by Rob Page 22 Jul '99

22 Jul '99

Anthony Baxter wrote: > >>> Paul Chung Chee Soong wrote > > What do you mean by the ? > > Rob meant to type , I think. > > It's a magic variable that you can use to have multiple SQL statements > in the same Z SQL method. However, only the last of the > queries in the > Z SQL Method can be a select. Yeah... that! --Rob

1 0

Problem with file upload
by Thierry MICHEL 22 Jul '99

22 Jul '99

Hi ! I have some problem with file upload with python and Zope. Can someone help me ? I just want to import a gif or jpg file from a client to Zope ! Thanks Thierry thierry(a)glisco.it

1 0

Z PyGresql DA questions
by HCSCCS＠prudential.com.my 22 Jul '99

22 Jul '99

Hi. I'm building a loan system with Zap and I have a SQl statement problem. Let's say I have 2 table: loan and doc Fields in doc: pno * doctype * docloc ... Fields in loan: usrid * pno * doctype * ... Note: * means primary key What I want to query is how do I get all the pno and its according type, that doesn't exist in the loan table? This is to make sure that the borrower does not select a document that had been loaned!!! In other words, all documents except those that are being borrowed. Please reply to hcsccs(a)prudential.com.my as well. Many thanks, Paul Chung Paul Chung Executive IT Department Prudential Assurance Malaysia Berhad

1 0

Re: [Zope] how to delete objects with " in id?
by Service Informatique CHSR 22 Jul '99

22 Jul '99

I had the same problem. I ended up deleting it directly from python (shutdown Zope, then import the Main package from python, and then delete the relevant data. Don't forget to commit the transaction) This problem is due to the lack of  (notice the html_quote) in various part of the DTML sources shipped with Zope. Alternatively, you could patch your DTML to include the html_quote attribute to be able to delete the folder. > >I created a folder with double quotes in the id. It created fine, but >I couldn't delete it. It gave the error: > > > Sorry, a Zope error occurred.<p> ><!-- >Traceback (innermost last): > File /opt/zope/lib/python/ZPublisher/Publish.py, line 256, in publish_module > File /opt/zope/lib/python/ZPublisher/Publish.py, line 161, in publish > File /opt/zope/lib/python/ZPublisher/mapply.py, line 154, in mapply > (Object: manage_delObjects) > File /opt/zope/lib/python/ZPublisher/Publish.py, line 98, in call_object > (Object: manage_delObjects) > File /opt/zope/lib/python/OFS/ObjectManager.py, line 384, in manage_delObjects > (Object: t) >BadRequest: asdfasf does not exist > >The actual id of the object was asdfasf"asfasf"asfasfdasf" > >I ended up having to delete the parent folder. If I had done this in >/ how could I have deleted the object? > >Thanks, >^Roman

1 0

RE: [Zope] Bulk insert in Zope's ZPyGres
by HCSCCS＠prudential.com.my 22 Jul '99

22 Jul '99

What do you mean by the ? ---------- From: Rob Page Sent: Wednesday, July 21, 1999 11:12 PM To: HCSCCS Cc: zope Subject: RE: [Zope] Bulk insert in Zope's ZPyGres MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.1960.3) Content-Type: text/plain > Thanks. But how do use insert statements thru Z SQL Mtehod > submitting it > again? We will need to submit the web page a lot of times to > get the > variables across, wouldn't we? How do we address this problem ? <SNIP> if the checkboxes are called: list_of_things:list then in the SQL Method:  INSERT INTO data_table (field1, field2, field3) VALUES ( , ,  )   --Rob

2 1

Re: Zope XML Roadmap
by Michael Rose 22 Jul '99

22 Jul '99

<Disclaimer> I am very new to Zope and have just begun evaluating it, and it's XML capabilities in particular. </Disclaimer> First, I am very impressed with the Zope architecture and am happy to see XML being integrated into the process. I will defer specific comments on the XML roadmap but use the opportunity raise a more general question. There is a fair amount of XML capability in the Python XML-SIG, but there is even more capability in various Java/XML packages and with the use of JPython these packages can be integrated seamlessly with the XML-SIG packages - no glue code required. If Zope could run under JPython then a very large amount of XML/XSL/DOM capability would be automatically available. As an experiment I tried making the Zope python packages under JPython instead of CPython, and I only experienced one minor hitch so far, most everything compiled straight from the make files. That of course leaves the problem of all the parts of Zope which are written in C, and I have no idea how much of a problem it is porting that to Java (or constructing a JNI interface). But it might be worth comparing the effort required to get Zope working on JPython to the effort to port existing XML/XSL and other existing Java packages to Zope (Python or C-Extensions) Aside from the porting effort I realize that there are speed issues, but for some of us portability and the simple extensibility offered by the JPython /Java combination outweigh speed considerations. Hope this wasn't too off-topic, Michael ************************************************ Michael Rose Center for Tele-Information, Technical University of Denmark mailto:rose@tele.dtu.dk http://www.cti.dtu.dk/personal/rose Multimedia in the Home - http://mmhome.cit.dk 'and what is the use of a computer' thought Alice 'without pictures or conversation' with apologies to Lewis Carroll *************************************************

3 2

ZClasses: Object Manager's containing renameable Object Manager's
by Roman Milner 22 Jul '99

22 Jul '99

I've created a ZClass that inherits from Object Manager. I want it to hold another type of ZClass/Object Manager. The problem is I need to manage_renameObject() the Object Managers that are inside Object managers and when I do I get "The object foo does not support this operation." The sub-object managers were created in side the method's view of the parent-object managers. So, I tried inheriting from Folder instead of Object Manager and I can't get the option to add the sub-folder objects to show up on the menu. Any help is greatly appreciated. ^Roman

1 0

RE: [Zope] Bulk insert in Zope's ZPyGres
by Rob Page 22 Jul '99

22 Jul '99

> Thanks. But how do use insert statements thru Z SQL Mtehod > submitting it > again? We will need to submit the web page a lot of times to > get the > variables across, wouldn't we? How do we address this problem ? <SNIP> if the checkboxes are called: list_of_things:list then in the SQL Method:  INSERT INTO data_table (field1, field2, field3) VALUES ( , ,  )   --Rob

1 0

RE: [Zope] Z PyGresql DA questions
by Rob Page 22 Jul '99

22 Jul '99

> Hi. I'm building a loan system with Zap and I have a SQl statement > problem. Let's say I have 2 table: loan and doc > > Fields in doc: pno * > doctype * > docloc > ... > > Fields in loan: usrid * > pno * > doctype * > ... > Note: * means primary key > > What I want to query is how do I get all the pno and its > according type, > that doesn't exist in the loan table? This is to make sure that the > borrower does not select a document that had been loaned!!! > In other > words, all documents except those that are being borrowed. How 'bout: SELECT * from doc WHERE pno NOT IN (SELECT pno FROM loan) --Rob

1 0

FYI: Zope Weekly News
by Amos Latteier 22 Jul '99

22 Jul '99

Zope 2.0 beta one should be out *very* soon. This week saw a lot of screw tightening in preparation for the beta release. The public CVS archive is temporarily frozen due to some re-organization but will open up again when the beta release comes out. Most of the traffic on the Zope lists was devoted to Zope community members helping each other solve their various real world problems. One of the most notable discussions this week started with a comparison between Zope and other web development platforms with respect to xml facilities. Folks at DC weighed in with their 2 cents on the subject which includes the imminent release of a Zope product which will allow access to xml objects in Zopish ways. Interestingly many community members have similar ideas of what Zope needs in terms of xml support. It will be exciting to see how Digital Creations and community members collaborate on XML development efforts. * Chris Petrilli announced an new Zope mailing list, zope-announce. If you're overwhelmed with the volume of the currently Zope lists, this one could be for you. http://www.zope.org/mailman/listinfo/zope-announce/ http://www.zope.org/pipermail/zope/1999-July/006993.html * Amos Latteier posted a roadmap details some plans for XML development in Zope. Digital Creations will release an alpha XML Zope product in the next couple days. http://www.zope.org/pipermail/zope/1999-July/007010.html * One of the best IT magazines on the German market, iX Magazine, has a Zope article available in the August 1999 issue by Frank Tegtmeyer. http://www.heise.de/ix/ http://www.heise.de/ix/artikel/1999/08/064/ * Andreas Kostyrka announced Navigate 0-0-4. This product allows you to control which objects are displayed. http://www.zope.org/pipermail/zope/1999-July/006969.html http://www.zope.org/Download/Contrib/ * Arpad Kiss announced a simple Zope chart drawing tool. http://www.zope.org/pipermail/zope/1999-July/006964.html http://starship.python.net/crew/arpadk/downloads/Chart0.3.0.tar.gz * Andy Dustman announced a new Python interface for MySQL, MySQLdb-0.0.3. This package includes a patch to use it with Zope's MySQL database adapter. http://www.zope.org/pipermail/zope/1999-July/006946.html http://starship.python.net/crew/adustman * Hurrah Internet now offers Zope hosting. http://www.hurrah.com/ http://www.zope.org/Community/ZHP * Chris Petrilli posted a note about BLOBs and Zope database adapters on the zope-dev list. http://www.zope.org/pipermail/zope-dev/1999-July/000863.html See you next week. -- Amos Latteier mailto:amos@digicool.com Digital Creations http://www.digicool.com

1 0