March 2001 - Zope - Zope lists

Using Zope and MySQL
by Gitte Wange 27 Mar '01

27 Mar '01

Hello, Yesterday I tried to setup Zope with MySQL, but the Product I found on Zope.org to do this, didn't work. Now is there anyone who knows how to setup Zope with MySQL ?? Regards, -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte(a)mmmanager.org ************************

7 14

dtml-in patch
by Oleg Broytmann 27 Mar '01

27 Mar '01

Hello! 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: It seems there is an effort to allow next/prev batches to be used either in the beginnig or in the end of the loop (before, next batch can only be referenced in the end of the loop). If so, it still doesn't work. I have a test case. Or may be I just misunderstand the code? (or even worse - there is a bug in my test case :) Oleg. ---- Oleg Broytmann http://www.zope.org/Members/phd/ phd(a)phd.pp.ru Programmers don't die, they just GOSUB without RETURN.

1 0

interactive linking
by paulousek 27 Mar '01

27 Mar '01

Hello to all! thanks for the tips for chown/chmod! My Zope runs nicely now. I apologize for posting a maybe stupid newbie question, but: what I intend to realize is a CM-system where editors can interactively interlink documents (in the sense of creating HREFs). They must be able to indicate the link's target, which might be either internal (another Zope object/document), or external (a complete URL selected from a list) or even void. The interface should not be typing the target's data/address in, but selecting it from a form-element like a scrollable list. Can this be done easily with Zope or will I have to prepare myself for long Python-programming sessions? (BTW: the same procedure for selecting content should be available for images and downloadable files.) hope I haven't bothered the community... thanks in advance! -- PERCEPT : Paul Paulousek mailto:ppaul@percept.de http://www.percept.de

2 1

SQL methods
by Norman Khine 27 Mar '01

27 Mar '01

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

SQL results
by Alejandro Pancani 27 Mar '01

27 Mar '01

Is there any way to use the results of a query in other SQL sentence (like INSERT) without to have to redefine the variables in the REQUEST. I tried this but didn´t work <dtml-in select_sql_sentence> <dtml-call insert_sql_sentence> </dtml-in> The only way that I found was that: <dtml-in select_sql_sentence> <dtml-call "REQUEST.set('result_of_select', result_of_select)"> <dtml-call insert_sql_sentence> </dtml-in> Of course the SELECT sentence returns only 1 match Alejandro Pancani apancani(a)topgroup.com.ar

2 1

Can't pass 'class' as keyword to .tag()?
by Joel Burton 27 Mar '01

27 Mar '01

To pass extra parameters to an image, so you can create a customized IMG tag, the syntax is <dtml-var "my_pic.tag(alt='My alt', scale=1.5)"> which works fine. However, the parameter I want to pass is the CSS attribute for class. I want to create an IMG tag that looks like this: <img src="foo" height=xx weight=xx class="logo"> I could just type this in directly to the DTML source, but I'd like to have the ALT, HEIGHT, and WIDTH tags calculated by Zope from the image title, and the graphic height and width. However, I can't use the 'class' keyword in Zope, presumably because apparently there's some *other* use of the word class in Python ;-). Is there a way around this? Thanks! -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

3 3

Zope Hosting
by Jan Lentfer 27 Mar '01

27 Mar '01

Hi all, I am very new to this list (joined today), so I don't know if that'S the right place for my question. But I'll try.... I am looking for good an cheap Zope Hosting. I know there is a free hoster, but they don't allow you to create your own products. What I need is a "real" Zope server with the opportunity to add my own products. Here in germany there is www.beehive.de. They offer 100MB webspace and a full Zope Server for 80DEM/month. (That's about 38 USD/month). That's too expensive for me since I am a student and my site is non-commercial. I don't really need much web space (25 MB would be a lot for me). Does anyone know a Zope Hoster that fits my wishes?...... Many thanks in advance, Jan Lentfer -------- Jan(a)MountainbikeHQ.de http://www.MountainbikeHQ.de - Your home for DH,DS and CC Mountainbiking & http://test.MountainbikeHQ.de - the new instance of Mountain Bike Headquarters!

2 1

RE: [Zope] pcgi authorization trouble
by Mayers, Philip J 27 Mar '01

27 Mar '01

Apache must be able to access (for execute) both: /var/lib/zope/Zope.cgi /home/soli-con/ipOffice/Zope.cgi *And* write to the PCGI socket(s) listed inside those scripts, and exec the pcgi-wrapper programs listed inside them as well. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Olaf Marc Zanger [mailto:olaf.zanger@soli-con.com] Sent: 26 March 2001 20:03 To: Zope Subject: [Zope] pcgi authorization trouble hi there, i have two zopes running. the one (zope) i can access, the other one (ip) i get an http error (forbidden you don't have permission to access /ip/ on this server. zope: is running under username:zope ip: is running under username: soli-con the var directory has chmod 777 and chown soli-con.users what is going on ?? thanks for help olaf these are my entries in httpd.conf: ---------------------------------------------- RewriteEngine on RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^/zope(.*) /var/lib/zope/Zope.cgi$1 [e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l] RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^/ip(.*) /home/soli-con/ipOffice/Zope.cgi$1 [e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l] -- soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23, 3013 Bern / Switzerland fon:+41-31-332 9782, mob:+41-76-572 9782 mailto:olaf.zanger@soli-con.com, http://www.soli-con.com _______________________________________________ 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 )

2 1

Authentication
by Amir Pournasserian 27 Mar '01

27 Mar '01

Dear Sir, Sorry about disturbing you. I found your email when I was asking from some people about authentication. Anyway, I want to know: How can I authenticate (web based) with windowsnt, win2000 or IIS4 or 5. Or if you know where can I find some info there please recommand me. Thanks Amir

1 0

SQLSession Transaction.py.patch
by Shai Berger 27 Mar '01

27 Mar '01

Hi guys, The SQLSession documentation claims that the product distribution includes a file Transaction.py.patch that can be used to patch Zope's transaction mechanism. However, I have not been able to find such a file in the distribution. Does anybody know where it might be? Of those who did find it -- did anybody try it with Zope 2.3? Thanks, Shai.

1 0