- Zope - Zope lists

Webdrive/FTP woes
by Chris Withers 28 Mar '01

28 Mar '01

Hi, Dunno whether this is a Webdrive or a Zope FTP Server problem so I though I'd ask here first. I really like Webdrive, but when using it to edit Python Scripts using Zope's FTP server, it has a habit of cutting the script in half and loosing the second half :-( Have any other Webdrive/Zope users experienced this? Did anyone find a solution? cheers, Chris

1 0

Counter Rentrancy
by David Kyte 28 Mar '01

28 Mar '01

Hi, If I have a DTML document for generating and tracking say order numbers, is the code rentrant/Atomic? <dtml-call "REQUEST.set('counter', counter + 1)"> <dtml-call "manage_changeProperties( counter=REQUEST['counter'] )"> <dtml-return counter > What I'm really asking is how many threads run in parallel, and how would multiple threads accessing this code react. Do I need some form of transation or locking? Thanks in anticipation David Kyte

2 1

Re: [Zope] ZMySQLDA connection error when adding
by Gitte Wange 28 Mar '01

28 Mar '01

It says a file is missing ... is that a permissions problem ? I have chowned my entire Zope directory to nobody.nobody but the problem is still there ? What should I look for ? Gitte On 28 Mar 2001 10:15:49 +0100, Phil Harris wrote: > Permissions problem > > ----- Original Message ----- > From: "Gitte Wange" <gitte(a)mmmanager.org> > To: <zope(a)zope.org> > Sent: Wednesday, March 28, 2001 9:08 AM > Subject: [Zope] ZMySQLDA connection error when adding > > > > Hello again, > > > > I hope not you are tired of my newbie questions already :-) > > Finally I succeed in adding MySQL functionality to Zope but I can't add > > a connection. > > This is the error I get when I try: > > > > Error Type: IOError > > Error Value: [Errno 2] No such file or directory: > > > '/usr/local/Zope-2.3.0-linux2-x86/lib/python/Shared/DC/ZRDB/connectionAdd.dt > ml > > > > Traceback (innermost last): > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line > > 222, in publish_module > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line > > 187, in publish > > File /usr/local/Zope-2.3.0-linux2-x86/lib/python/Zope/__init__.py, > > line 221, in zpublisher_exception_hook > > (Object: ApplicationDefaultPermissions) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line > > 171, in publish > > File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/mapply.py, > > line 160, in mapply > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line > > 112, in call_object > > (Object: manage_addZMySQLConnectionForm) > > File /usr/local/Zope-2.3.0-linux2-x86/lib/python/App/special_dtml.py, > > line 127, in __call__ > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 479, in __call__ > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 408, in cook > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 400, in read > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 580, in read_raw > > (Object: manage_addZMySQLConnectionForm) > > IOError: (see above) > > > > > > Any good ideas ? > > > > Regards, > > > > -- > > ************************ > > Gitte Wange Jensen > > > > System Squid Developer > > MMManager Aps > > +45 29 72 79 72 > > > > gitte(a)mmmanager.org > > ************************ > > > > > > _______________________________________________ > > 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 ) -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte(a)mmmanager.org ************************

2 1

FW: Filling lists from SQL methods
by Norman Khine 28 Mar '01

28 Mar '01

> Hello, > Can any one help me understand the concept behind this example: > > In the How-To from http://www.zope.org/Members/AlexR/SelectionLists sub > section Filling lists from SQL methods, we have a method > > <SELECT name="myList"> > <dtml-in mySQLQuery> > <OPTION VALUE='<dtml-var Field1 null="">'> > <dtml-var Field2 null=""> > </dtml-in> > </SELECT> > > How can I create a second list so that when I select Field1, the list is > updated from another SQL query using the value of Field1 as the variable. > > So for example, I have two tables: ProductGroups and Products > ProductGroups has ProductGrpID, Description > Product has ProductID, Description and FK_ProductGrpID > > Therefore if the user select ProductGrp =1 then the second drop-down menu > will only select Products where FK_ProductGrp = 1. > > Thanks > > Norman

1 0

ZSQL & LIKE Operator
by Donald Braman 28 Mar '01

28 Mar '01

I'm trying to get Zope to submit a "like" statement to MS Access (please don't ask why I'm using MS Access; it's a temporary situation). Anyway, I can't get a working ZSQL method LIKE and a wildcard. I try: SELECT * FROM Cases WHERE Short_Case_Name LIKE 'Plessy v. Ferguson' works fine; I try: WHERE Short_Case_Name LIKE 'Plessy*' I get no data matching query. I can run the query through MS Access SQL view just fine; not sure why it's not working with ZSQL. Donald Braman donald.braman(a)yale.edu

4 3

Re: [Zope] indirect calling of methods with parameters
by Dieter Maurer 28 Mar '01

28 Mar '01

Bernd Worsch writes: > .... > I'm trying to call a method that needs parameters indirectly. Reading the "Name Lookup" section in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html will make such things easy (I hope, at least). Dieter

2 1

Re: [Zope] dtml-in patch
by Dieter Maurer 28 Mar '01

28 Mar '01

Oleg Broytmann writes: > Can anyone (especially from DC) explain the lates patch to DT_In.py? > > < if index==first and index > 0: > --- > > if index==first or index==last: The original patch came from me. And indeed, it was supposed to provide uniform navigation both at the start and end of the sequence. It worked nice for us. I posted the original patch to the Collector (ages ago). You may find it also under: URL:http://www.dieter.handshake.de/pyprojects/zope/dt_in.pat I did not yet check the changes as applied in Zope 2.3.1. This will happen mid April. Dieter

2 1

Re: [Zope] integration w/ Lotus Notes
by Simon Coles 28 Mar '01

28 Mar '01

On 27/3/01 1:16 am, "Sundar Narasimhan" <sundar(a)ascent.com> wrote: > Hi, Does anyone have any help/suggestions wrt. how I can go about > connecting a Zope app. to Lotus Notes? > > Has anyone attempted/done such a thing already? You'd be surprised how many people in the Zope world came from Notes/Domino :-) "connecting a Zope app. to Lotus Notes" can cover whole range of things. We've got Zope and Domino working together in a single system, in a variety of ways. What is the specific problem you are trying to solve? Simon -- --------- My opinions are my own, NIP's opinions are theirs ---------- Simon J. Coles Email: simon(a)nipltd.com New Information Paradigms Work Phone: +44 1344 753703 http://www.nipltd.com/ Work Fax: +44 1344 753742 =============== Life is too precious to take seriously ===============

2 2

How do I get a string value of a DateTime object, in a given format
by Chris Beaumont 28 Mar '01

28 Mar '01

Hello, I'm sorry to ask such a basic DTML question...I just haven't been able to get this to work.. I'm hoping to use the Python slicing format to extract the various parts of a "pCommon" or aCommon" format date (the output from an SQL query) so that I can use them individually.. What is the syntax to get the string value of this non-strftime format date object, so that I can put it into a string variable for slicing? Thank you, Chris

2 1

ZMySQLDA connection error when adding
by Gitte Wange 28 Mar '01

28 Mar '01

Hello again, I hope not you are tired of my newbie questions already :-) Finally I succeed in adding MySQL functionality to Zope but I can't add a connection. This is the error I get when I try: Error Type: IOError Error Value: [Errno 2] No such file or directory: '/usr/local/Zope-2.3.0-linux2-x86/lib/python/Shared/DC/ZRDB/connectionAdd.dtml Traceback (innermost last): File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.0-linux2-x86/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/App/special_dtml.py, line 127, in __call__ (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 479, in __call__ (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 408, in cook (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 400, in read (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 580, in read_raw (Object: manage_addZMySQLConnectionForm) IOError: (see above) Any good ideas ? Regards, -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte(a)mmmanager.org ************************

7 11