July 2000 - Zope - Zope lists

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

Re: [Metapublisher] how to get the Catlog to find MP entries? (2nd post) post)
by Sebastian Luehnsdorf 17 Jul '00

17 Jul '00

hi! On Thu, 29 Jun 2000, George Donnelly wrote: > i have several MP instances in subfolders and need to present the most > recent mp entries from any/all of the these MP instances on my index_html > page in the zope root. > > when i add a Z search interface in the zope root it only offers me the > Catalog in the zope root as a searchable object and does not seem to be > aware of any mp_catalog's. > > alternatively i could find all meta entry's to the Catalog in the zope root > but the meta entry meta type does not show up in the selection list. how > could i find the meta entrys without finding all objects? can anybody > recommend an expression? i tried something like meta type==meta entry but > this was a no go -- it returned ALL objects > > the only way i could do it is by adding each individual mp entry's id into > the find to catalog mechanism. for a site with any traffic this could be a > major bummer! > hmmm... a little tricky! i found a workaround which looks like this: if you modify the __init__.py of the MetaPublisher product, so that a MetaEntry object appears in a Folder's available objects, obviously ZCatalog will find MetaEntries. I have created an __init__.py which registers MetaEntry objects properly but uses MetaPublisher's constructors. This means, if you select a MetaEntry to add to some Folder, you will actually add a MetaPublisher. This might not be the cleanest solution but it works :) I attached a sample __init__.py file, which you should copy to 'lib/python/Products/MetaPublisher'. > then the next problem was that when i used the getpath directive to get a > url for the records returned by the Catalog i got a url like this > mpfolder/mp_entries/9995757.435 which plays all kinds of havoc with my > carefully crafted directory structure ;-| depends on your structure... what exactly is the problem? unfortunately, in the current version, the mp_entries folder has to stay. there are early plans to remove it completely but this will take some time before it becomes a reality. > any ideas? some... ;) > Regards, > GEORGE DONNELLY > george(a)cyklotron.com > http://cyklotron.com/ > The smallest minority on earth is the individual. Those who deny individual > rights, cannot claim to be defenders of minorities. --Ayn Rand > > > > _______________________________________________ > MetaPublisher mailing list > MetaPublisher(a)beehive.de > http://mailman.beehive.de/mailman/listinfo/metapublisher > ciao, basti -------------------------------------------------------------------------- sebastian f. luehnsdorf beehive elektronische medien gmbh -------------------------------------------------------------------------- http://basti.beehive.de http://www.beehive.de mailto:basti@beehive.de mailto:service@beehive.de http://www.zope.de fon: (+49 30) 84 78 20 http://www.i-surf.de fax: (+49 30) 84 78 22 99

1 0

Hotfix / 2.2.0 question
by Christopher J. Kucera 17 Jul '00

17 Jul '00

Greetings, fellow Zopers! A quick, non-urgent question for you all: After recently upgrading to 2.2.0, I noticed that under Control Panels/Products, I still had an entry for the security Hotfix from oh, so long ago, despite the fact that it's quite absent from my 2.2.0 Products directory. I just assumed it was safe to delete, so I did, but I'm wondering why it was there, and if, indeed, I should have deleted it. :) Thanks for your help, CJ

1 0

zope.org going down
by ethan mindlace fremen 17 Jul '00

17 Jul '00

for about 35 sec :) because I forgot a very important part :P Thanks for your patience, -- ethan mindlace fremen Zopatista Community Liason Abnegate I!

1 0

RE: [Zope] SECURITY ROLES and < DTML-IN>
by Theodore Patrick 17 Jul '00

17 Jul '00

Brian, Thanks a ton. The patch worked perfectly! As it turns out I was using ODBC with Oracle. Everything works great. Rendering results perfectly. Thanks for the prompt response. As always! Theodore E. Patrick Ishophere.com -----Original Message----- From: Brian Lloyd [mailto:Brian@digicool.com] Sent: Monday, July 17, 2000 10:27 AM To: 'Theodore Patrick'; 'zope(a)zope.org' Subject: RE: [Zope] SECURITY ROLES and < DTML-IN> > I am having trouble rendering a <DTML IN> in ZOPE 2.2.0 to any user > regardless of roles. > > I have allocated the proper rights to all objects used and > nothing happens. > The <IN> will not let any user view its contents. Theodore - I bet you're running into the same problem as the folks using the ODBC adaptor. I've attached the post I made addressing this a few minutes ago. If this fixes your problem, could you send a note to the zope-list and let the folks there know that the fix works for the Oracle DA too? (I'm going out of town today, so I won't be able to forward it if you only reply to me) Thanks! > Hi guys - > > For those of you (I've mostly heard ODBC adapter users) > having authorization problems with your SQL methods, heres > the scoop: > > Database connections use one of two classes in the > framework for wrapping up result data returned from > queries. One of those classes (that understands results > in RDB format) was missing a required security assertion. > > The results returned by the ODBC adapter were bitten by > this - probably there are other adapters that could > be affected. > > I've attached a patch file for the file: > lib/python/Shared/DC/ZRDB/RDB.py > > ...as well as an updated version of the whole file (since > I know a lot of you will be on Windows w/o patch :) Either > patch or replace the file and restart Zope to fix the > problem. > > This is also checked in for a 2.2.1 release that will > probably happen after a few weeks when enough people > have upgraded to shake out any other problems. > Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

mySQL - Z SQL - dtml-var
by Gijs Reulen 17 Jul '00

17 Jul '00

Why does this not work inside a Z SQL Method (using MySQL) ?! 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 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 But it is no problem inserting data by hand into the database using the very same value as I used in these tests (12.12). What am I doing wrong ? Gijs Reulen

1 0

RE: [Zope] ZCatalog
by Chris McDonough 17 Jul '00

17 Jul '00

Jonathan, See http://www.zope.org/SiteIndex/search/view_source > -----Original Message----- > From: Jonathan Desp [mailto:jonathandesp@atomasoft.com] > Sent: Monday, July 17, 2000 4:38 AM > To: Chris McDonough; zope(a)zope.org > Subject: Re: [Zope] ZCatalog > > > Hi Chris, > > If I type "Zope" on the Zope.org search engine, I can see this -> > > Found 918 items matching "zope" > > What is the script behind that, because I'd like to do it for > my site too. > > I didnot find the How to, for that. > > ----- Original Message ----- > From: "Chris McDonough" <chrism(a)digicool.com> > To: "Jonathan Desp" <jonathandesp(a)atomasoft.com>; <zope(a)zope.org> > Sent: Monday, July 17, 2000 3:06 AM > Subject: Re: [Zope] ZCatalog > > > > Jonathan, > > > > Please respond to the list as well as to me so others can benefit. > > > > What's happening here is that your catalog is named "s". I > should have > > noticed this the first time around. But I didn't. The bit > you want is: > > > > <a href="<dtml-var "s.getpath(data_record_id_)">"> > > <dtml-var title> > > > > Whether you use "raw" or "title" depends on what you want > to see. If > > you want to see the "raw" DTML that makes up the object that gets > > referenced in the catalog as a link, use "raw". If you > want to see the > > title as a link, use "title". > > > > If your catalog isn't named "s", and the DTML is actually > wrong where it > > says "<dtml-in s size=50 start=query_start>", change "s" to > whatever the > > catalog is named. > > > > What Zope is doing: > > > > 1. Iterating over the catalog in batches of fifty > responses in the line > > that says: > > > > <dtml-in s size=50 start=query_start> > > > > 2. Doing some stuff at the beginning of the batch (all the "if > > sequence-start" stuff) > > > > 3. Showing results, if any with a link (the bit you're adding) > > > > 4. Doing some stuff at the end of a batch (all the "if > sequence-end" > > stuff) > > > > 5. Showing a meaningful message if there were no results. > > > > > > > > Jonathan Desp wrote: > > > > > > yes, so I quess: > > > > > > <a href="<dtml-var "catalog.getpath(data_record_id_)">"> > > > <dtml-var title> > > > > > > will become: > > > > > > <a href="<dtml-var "catalog.getpath(data_record_id_)">"> > > > <dtml-var raw> > > > > > > then I did it, > > > > > > here I tryed my search: > > > > > > http://www.atomasoft.com/gosearch > > > > > > and it's not working. > > > > > > All is great with my source or I need to shutdown zope if > I want to see > the > > > result working.. ? > > > > > > Do you know if there is any other changing to do? > > > > > > here is my new source again: > > > > > > <dtml-var standard_html_header> > > > <dtml-in s size=50 start=query_start> > > > <dtml-if sequence-start> > > > > > > <dtml-if previous-sequence> > > > > > > <a href="<dtml-var URL><dtml-var sequence-query > > > >query_start=<dtml-var > > > previous-sequence-start-number>"> > > > (Previous <dtml-var previous-sequence-size> results) > > > </a> > > > > > > </dtml-if previous-sequence> > > > > > > <table border> > > > <tr> > > > <th>Raw</th> > > > </tr> > > > > > > </dtml-if sequence-start> > > > > > > <tr> > > > <td><a href="<dtml-var > "catalog.getpath(data_record_id_)">"><dtml-var > > > raw></a></td> > > > </tr> > > > > > > <dtml-if sequence-end> > > > > > > </table> > > > <dtml-if next-sequence> > > > > > > <a href="<dtml-var URL><dtml-var sequence-query > > > >query_start=<dtml-var > > > next-sequence-start-number>"> > > > (Next <dtml-var next-sequence-size> results) > > > </a> > > > > > > </dtml-if next-sequence> > > > </dtml-if sequence-end> > > > > > > <dtml-else> > > > > > > There was no data matching this <dtml-var title_or_id> query. > > > > > > </dtml-in> > > > > > > <dtml-var standard_html_footer> > > > > > _______________________________________________ > 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 ) >

1 0