March 2001 - Zope - Zope lists

Who is willing to write a new database adapter?
by Ulrich Wisser 30 Mar '01

30 Mar '01

Hi, we use the Adabas D database. I did not find any Python or Zope database adapter for it. I tried to use the Perl-DBI drivers but these have a lot of bugs. Is there anybody willing to write a phyton driver and zope adapter for Adabas D? We would be willing to donate some money and of course all software should be GPL. If you are interessted, please contact me at u.wisser(a)publisher.de Thanks Ulrich -- Searchengine Know How - Webpromotion - Optimization - Internal Search World Wide Web Publisher, Ulrich Wisser, Odensvag 13, S-14571 Norsborg http://www.publisher.de Tel: +46-8-53460905 Fax: +46-8-534 609 06

1 0

Images again
by Patrick 30 Mar '01

30 Mar '01

Hi all, Sometime back I posted something about ftp security and since then I have grown to appreciate the way Medusa tries to deal with the possibility of an acl folder appearing further down the trees. I solved my ftp worries (hopefully) by having my firewall allow ftp to that port ONLY from my LAN... Thanx for all who chipped in. Anyhow, now I am back to another post of mine. I posted something about having a site display random images from a folder , say images and thanks Tino and Dieter for the info in whrandom. I now have to take that further. The scenario is this. I want to be able to have a web based login screen as well as a sign up one. I have read the posts on using Login Manager or UserDB... but what I want is to have on the signup page a section that requests for things like hobbies and preferences and stores it in a database. Question is .. which of the two (Login manager or UserDB) will better suit my requiements and could someone give me a hint on how I would implement this? Also if I have images in folders say a_fold and b_fold and I have set a string property to the folders say like and in a_fold the value is "a" and in b_fold it is "b". Assuming that I have a database of someone's preferences and in it I have a string like which either has 'a' or 'b' or 'both' as it's value. How do I display random images from the folders according to what is in the database (assume its a mysql database)? Sorry for the lllooong set of probably unclear requests and thanks for any help anyone can give. Patrick.

1 0

BUG ? in 2.3.1b3
by Jerome Alet 30 Mar '01

30 Mar '01

Hi, I don't know if I've done something wrong or not but on a fresh 2.3.1b3 install there seems to be no index_html document in the root folder, this leads to an error when trying to access the site. I've noticed that the QuickStart has gone away, but maybe index_html was too much. on another topic, it seems that the root folder doesn't have a getId() method. IMHO it should have one, returning an id which can't conflict with user defined ones, like "#ROOT#" for example: then it should be easier to make method which traverse the folder tree from the leaves to the root. bye, Jerome Alet - alet(a)unice.fr - http://cortex.unice.fr/~jerome Fac de Medecine de Nice http://wwwmed.unice.fr Tel: (+33) 4 93 37 76 30 Fax: (+33) 4 93 53 15 15 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE

1 0

dtml-sqlgroup question.
by Jeremy Cowgar 30 Mar '01

30 Mar '01

I have created code that uses dtml-in ... sequence tags and I want to be able to use the same page (mfgList) to access diffrent sets of that data. For instance, say I have three companies in my manufacturers table: Borland, Microsoft and Novel. I want to be able to see all entires (using the great PREV/NEXT tags that sequences provide) but then I also want to use the same page to display filtered data (only companies in Washington for instance). My problem lies in that I do not always pass the parameters. Here is my sql code: <params>mfg_id mfg_name</params> select * from mfg <dtml-sqlgroup where> <dtml-sqltest mfg_id op=eq type=int optional> <dtml-and> <dtml-sqltest mfg_name op=like type=string optional> </dtml-sqlgroup> order by mfg_name and here is sniplet's of my dtml code (mfgList.z): <dtml-in mfgSelect.sql size=10 orphan=1 start=query_start> ... all the stuff to display the info, prev and next tags ... </dtml-in> What happens is Zope err's when all the parameters are not sent. From another page, I may reference a URL like: mfgList.z?mfg_name=Bor What I want that to do is display everything that is like Bor ... but it complains that it did not recieve enough parameters. Can anyone help me with this problem? Thanks! Jeremy - jeremy(a)cowgar.com

1 0

Newbie Zope Question
by Ixokai 30 Mar '01

30 Mar '01

I've been looking over the Zope website, and basically like the idea that each page should have its own folder, with a single 'index_html' in the root directory that handles a uniform design for the rest of the site. But, its not perfect. For instance, I want my first page to be a splash page that doesn't conform to this uniform pattern, and I don't nessecarily want the rest of the site to be based off of a sub-directory. For instance, http://mydomain.org/ is a splash-screen, and I wish http://mydomain.org/Topic1 through Topic9 to all conform to my Sitewide Style. I suspose I could have a http://mydomain.org/Main that is the true 'main index' page, and put everything off of it, e.g. http://mydomain.org/Main/Topic1 ... but that is not optimal. Anyways, what's the best way to do this? I tried to do a minimal bit of DTML, for instance, checking for the existance of a property (<dtml-if OverrideIndex> <dtml-var override_html> <dtml-else> <dtml-var header> ...etc... </dtml-if>), but properties are inherited down the line, and I would rather not have to specifically set 'OverrideIndex:0' on all of the sub-folders.... If thats the only or best way, though, I'll deal. :) Thanks for any help. --Ixokai

2 1

Re: dtml-with and dtml-sqltest
by alan runyan 30 Mar '01

30 Mar '01

Lee, the zope mailing list is more appropriate for ZOPE inquiries. there is a larger community focused solely on that domain. please direct email to zope(a)zope.org. I dont really know what sqltest does, I have never used it. you can try this: sqlMethod - arguement - aaa=1 SELECT * FROM table WHERE id=<dtml-sqlvar aaa type="int"> dtmlMethod: <dtml-let aaalist="[1,2,3]"> <dtml-in aaalist> <dtml-call "REQUEST.set('aaa', _['sequence-item'])"> <dtml-in getPhById> <dtml-var PH> </dtml-in> </dtml-in> </dtml-let> the dtmlMethod should probably be in a PythonMethod that looks like: aaalist=[1,2,3] stuff = [] for aaa in aaalist: for sql in container.getPhById({'aaa': aaa}): # _TRICKY_ ZSQLMethods *DO NOT* use DTML namespace stuff.append(sql[0]) # position in sql row returned return stuff Lessons learned: PythonMethods are cleaner (on a whole), ZSQL doesnt get a DTML namespace, Dieter Maurer has most of the answers on the ZOPE mailing list, just search through it @ egroups. ~runyaga

1 0

"structured text docs" stupid question
by Ruberl Michele 30 Mar '01

30 Mar '01

> Hi all, > I'd like to know if STXDocument 1. 2 by Tres Seaver still needs Renderable > ZClass or if DC added it in the 2.3.0 version. > ... or if there is something even newer about Structured text docs! > Thanks! > Michele >

4 3

RE: [Zope] Opinions sought on acquisition issue
by Randall F. Kern 30 Mar '01

30 Mar '01

BTW, I have a product called "CascadingFolders" that does exactly this. If you need something like that let me know and I'll upload it to Zope.org. -Randy > -----Original Message----- > From: Chris McDonough [mailto:chrism@digicool.com] > Sent: Thursday, March 29, 2001 6:33 PM > To: The Famous Brett Watson; zope(a)zope.org > Subject: Re: [Zope] Opinions sought on acquisition issue > > > > The reason that this is an issue at all, however, is because > > identically-named container objects to not acquire the > contents of the > > containers they mask, if any. The "images" folder in the > "log" folder > masks > > the "images" folder at the root, thus *hiding* the contents > of that folder > > rather than *acquiring* the contents of that folder. What would the > > implications be for Zope if acquisition meant that a failed method > > invocation resulted in further traversal of the namespace > stack instead of > > immediate failure? Thus, if I try to reference > "images['site-logo.jpg']", > > and the first "images" object found does not contain > 'site-logo.jpg', > would > > it be a good, bad, or ugly thing for Zope to *continue* the > search for > > "images" objects containing a 'site-logo.jpg'? > > It would probably be not so good. It's my belief that we're > trying to move > to more explicitness, and this magic is hard to document. > That's not to say > that you can't make a container like this and hook > __getattr__ and keep > going! > > > > > _______________________________________________ > 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

Zope Misconfiguration
by Adam Ray 30 Mar '01

30 Mar '01

When i was configuring a site root for zope, i put the base as my site (www.whatever.com) but when i put in the path i put in the local path (/www/www.whatever.com) now whenever i try to log in to zope it tries to go to www.whatever.com/www/www.whatever.com/manage what file can i edit to fix this? Adam

2 1

PythonScript calling a DTML method and passing a list
by Ronald L. Roeber 30 Mar '01

30 Mar '01

Hello, I am still unclear on how to call a DTML method with a script while passing the results of that script. For example. The results of some long form call a PythonScript called makeSummary I want the results of makeSummary called MyList to be passed to a DTML Method called printResults ---makeSummary PythonScript----- REQUEST = context.REQUEST RESPONSE = context.REQUEST.RESPONSE """ Magic Python Code that generates a summary list""" MyList=['one','two','three',...] # Simuation print context.printResults( MyList, context, context.REQUEST ) return printed -----end of script------ --section of printResults DTML method--- <dtml-in MyList> Score Priority <dtml-var sequence-item> </dtml-in> ----------- Zope returns a Key Error: and states that "This resource (printResults) may be trying to reference a nonexistent object or variable MyList". It seems MyList is either gone or not in the namespace of the printResults DTML method. What am I doing wrong? I can't seem to find or (more likely) don't understand how do this from the documentation. Ronald L. Roeber University of Nebraska

2 1