- Zope - Zope lists

Re: [Zope] mySQL - Z SQL - dtml-var
by Dieter Maurer 17 Jul '00

17 Jul '00

Gijs Reulen writes: > INSERT INTO test1 > ( id, content, phone ) > VALUES ( > <dtml-var 12.12>, > <dtml-sqlvar content type=nb>, > <dtml-sqlvar phone type=nb optional> > ) > > According to the doc I should be able to use dtml-var statements in Z SQL > Methods. However, this returns an error: Error, exceptions.KeyError: 12.12 This is indeed a strange variable name (12.12). Do you mean the floating point value 12.12 rather than a variable of this name? In this case, you should use: <dtml-var "12.12"> > I also tried: > INSERT INTO test1 > ( id, content, phone ) > VALUES ( > <dtml-sqlvar id type=float>, > <dtml-sqlvar content type=nb>, > <dtml-sqlvar phone type=nb optional> > ) > > This also retuns an error: Error, exceptions.ValueError: Invalid > floating-point value for id Obviously, "id" does not contain a floating point value. Dieter

1 0

Re: [Zope-dev] Multi-homed objects?
by Terry Kerr 17 Jul '00

17 Jul '00

Where would the object aquire its attributes from? Would it try one of its folders, then the other? Which order would it choose? Chris Withers wrote: > Shane Hathaway wrote: > > This could be part of a "visitor" interface I've been pondering in the > > back of my mind. It would be capable of traversing, performing an > > arbitrary function, and never falling into a recursive trap. > > Cool :-) > > Let me know when it's available :-) > > Can you see any weirdities that might occur from having an object as an > attribute of more than one object manager / folder? > > Chris > > PS: Do you know the answer to my &dtml.url-; question I asked earlier? > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) -- Terry Kerr (terry(a)adroit.net) Adroit Internet Solutions Pty Ltd (www.adroit.net) Phone: +613 9563 4461 Fax: +613 9563 3856 Mobile: +61 414 938 124 ICQ: 79303381

1 0

Re: [Zope] Zope Knowledge Base on www.faqts.com?
by Dieter Maurer 17 Jul '00

17 Jul '00

Fiona Czuczman writes: > Hi, > > I've been working on a Python knowledge base for the last couple of > months. > > http://python.faqts.com Very good! > Recently I've been thinking about incorporating content from this > mailing list in a folder dedicated to Zope. And sending out my daily > summary to this list as well. Would be great. However, I would prefer a longer posting period, maybe a weekly summary. Dieter

3 2

ZClasses gripe
by Andy McKay 17 Jul '00

17 Jul '00

I hate to do something in ZClasses, but I did today just because I didnt have the energy to write in Python. Oh how I wish I had. It was all so simple except for "DestinationURL" not being implemented or being used patchily. It would be really great if we were able to write our own destination once a form has been filled. This would give us much better access to things like property manager. Oh well back to Python. -- Andy McKay, Developer, ActiveState http://www.ActiveState.com Programming for the People

1 0

Re: [Zope] (no subject)
by Karl Anderson 17 Jul '00

17 Jul '00

"Leichtman, David J" <code(a)ou.edu> writes: > I've previously been a Perl programmer. I did a lot of stuff where I would > have multiple links with different options. > Ex. > > <a href="/path/script.pl/1234">1234</a><br> > <a href="/path/script.pl/2345">2345</a><br> > > Then, in script.pl, I would pick up the extra info on the other side from > $PATH_INFO. > > The problem in Zope is that there is no "end" to the address. Serving from > Apache, it knows that the .pl extension is the end of the path. If there's a > '/' and more after it, it will push it to PATH_INFO. So how do you do this > in Zope? Because it's object names instead of paths in the request, how do > you send optional, additional info through the request as above? You've answered your own question. There is no end in the middle of the path. The publisher picks off each part of the URL from the top down, and at each step, it asks that object if it can provide the next one. Look at traverse() in lib/python/ZPublisher/BaseRequest.py, or step through the publishing process - see <http://www.zope.org/Members/michel/HowTos/TheDebuggerIsYourFriend>. At each step, the publisher checks to see if the parent has the child as an attribute, and if so, continues with the object at that attribute as the parent (so long as other conditions are met, like permissions). You can see this in python products: class Foo: "a python product" ... index_html = HTMLFile("someDTMLFile", globals()) index2_html = "<HEAD><BODY>..." index3_html = aFunction(mood, phaseOfMoon) Since getattr(path.to.foo, "index_html") reaches that html file, ZPublisher.Zope("/path/to/foo/index_html") publishes that file. index_html could be a (badly named) method instead, which has other attributes. It could decide what to publish or how to allow the publisher to traverse the path programmatically. You don't need extra rules that look for foo.pl in the URL (what a kluge - enforce a perl script to sit there until URLs are no more!). For your example, script.pl could have two subobjects or other attributes, 1234 and 2345, and the default index_html. Or script.pl could be a ZClass with those three as DTML methods or other subobjects. __bobo_traverse__ is another attribute that the object may have to drive the publishing process, but I haven't needed to understand why it's useful yet :) -- Karl Anderson karl(a)digicool.com

2 1

Problem with Zope 2.2.0 and changing a ZClass property
by Jochen Knuth 17 Jul '00

17 Jul '00

Hi, trying to update a ZClass based Product to Zope 2.2.0 i get the following Error and Traceback: Error Type: ValueError Error Value: Invalid property value: wrapped object Traceback (innermost last): File /usr/local/Zope-2.2.0/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope-2.2.0/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.2.0/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/Zope-2.2.0/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.2.0/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: postit) File /usr/local/Zope-2.2.0/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: postit) File /usr/local/Zope-2.2.0/lib/python/OFS/DTMLMethod.py, line 167, in __call__ (Object: postit) File /usr/local/Zope-2.2.0/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: postit) File /usr/local/Zope-2.2.0/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval (Object: propertysheets.properties.manage_changeProperties(REQUEST)) (Info: REQUEST) File <string>, line 0, in ? File /usr/local/Zope-2.2.0/lib/python/OFS/PropertySheets.py, line 443, in manage_changeProperties (Object: Traversable) File /usr/local/Zope-2.2.0/lib/python/OFS/PropertySheets.py, line 255, in _updateProperty (Object: Traversable) File /usr/local/Zope-2.2.0/lib/python/OFS/PropertySheets.py, line 208, in _wrapperCheck (Object: Traversable) ValueError: (see above) The error occurs in a method i defined in a ZClass. The beginning of the method is: <dtml-var standard_html_header> <dtml-call "REQUEST.set('editor',AUTHENTICATED_USER)"> <dtml-call "REQUEST.set('edit_date', ZopeTime())"> <dtml-call "propertysheets.properties.manage_changeProperties(REQUEST)"> <dtml-call reindex_object> [...] The method is called from a edit form of a ZClass instance as the form action. Is there anything wrong with the method or is there something other to look at? Ciao, Jochen

2 2

Printing data from a external python method.
by jesse 17 Jul '00

17 Jul '00

Hello, I'm creating a smart forms type product, similar to Smarter Forms. However, smarter forms, while a good product, is not as user friendly or as smooth running as we would like. What I am doing is creating a Index, which calls the form, which once completed posts to the external pythod method formchecker. However, once formchecker checks to see that all the fields were filled out, how can I use the EPM (external python method to print out the data on a dtml method? Thank you for your input, Jesse.

1 0

Re: GUF Permission Problem
by Mario Premke 17 Jul '00

17 Jul '00

Hi - You were absolutely right !!! Thanks a lot! There is still a problem remaining in my User-Authentication. In the DTML-method userList I have the SQL-Method : <dtml-return "sql_get_user_list()"> When I write the usernames in userList everything goes well. Usind the SQL-method results in the Zope-message: 2000-07-17T22:20:44 ERROR(200) GUF An exception was raised by http://134.96.119.88:8080/portal_folder/acl_users/userList (('Unsupported Type', 'userList method returned an unsupported type', <traceback object at 8592580>)) The Sql-method is tested an OK ... What does the error 'Unsupported Type' mean ??? Any hints will be appreciated ... MArio > > Hi Mario, > In reference to your problem where GUF cannot access "real_password", try > turning on "Access contents information" for your role(s) in the security > permissions area of the acl_users folder. I just ran into a similar problem > where I could access my sql methods, but could not access the results from > them. Setting this permission for my user defined role in the acl_users > folder fixed it. > > Let me know how it goes and if you have any questions. > > -=brad=- >

1 0

Problem on install DCOracle
by gustavo 17 Jul '00

17 Jul '00

Hi List, I newbie in Zope and Python. I tried to install DCOracle, but it didn't work properly: make -f Makefile.pre.in boot PYTHON=python rm -f *.o *~ rm -f *.a tags TAGS config.c Makefile.pre python sedscript rm -f *.so *.sl so_locations VERSION=`python -c "import sys; print sys.version[:3]"`; \ installdir=`python -c "import sys; print sys.prefix"`; \ exec_installdir=`python -c "import sys; print sys.exec_prefix"`; \ make -f ./Makefile.pre.in VPATH=. srcdir=. \ VERSION=$VERSION \ installdir=$installdir \ exec_installdir=$exec_installdir \ Makefile make[1]: Entering directory `/usr/local/DCOracle-1.3.1b1/src' make[1] *** No rule to make target `/usr/lib/python1.5/config/Makefile`, needed by `sedscript'. Stop. make[1]: Leaving directory `/usr/local/DCOracle-1.3.1b1/src' make: *** [boot] Error 2 Oracle version is 8.1.5 and Python 1.5.2. Could you help me? Thanks, Gustavo

1 0

Select in ZSQL
by Diego Rodrigo Neufert 17 Jul '00

17 Jul '00

Hi... I'm having problems with this select statement in ZQL using a MySQL db: select table1.id, table2.id from table_x table1, table_y table2 I got this error: Error, exceptions.ValueError: Duplicate column name, id Anyone know how to get this working? -- --------------------------- Diego Rodrigo Neufert -webmaster --------------------------- (Magic Web Design) (email) (diego(a)magicwebdesign.com.br) (curitiba) (pr)

3 2