- Zope - Zope lists

a question about role
by Luby Liao 08 Aug '01

08 Aug '01

I defined a role intended to allow my students to read the source code. After I log in with this role, called 'friend', I was able to read the PythonScript source, but not DTMLs which would be rendered. Even though I can get around this by providing them with 'viewsource', I am wondering how I can make the management interface display the source of DTMLs, rather than the randered pages. Any help is most highly appreciated. cheers, Luby

2 1

Re: [Zope] Virtual Site Hosting
by Stephan Goeldi 07 Aug '01

07 Aug '01

ProxyVia On? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Goeldi.com -- Internet Services Zope Folders, Instances and Servers http://www.goeldi.com/e/hosting_preise ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >From: mixo <mixo(a)beth.uniforum.org.za> >To: zope(a)zope.org >Subject: [Zope] Virtual Site Hosting >Date: Tue, 07 Aug 2001 16:17:00 +0200 > >I have created a folder called "test1' through the management >interface., >which I can access by typing "lynx http://myhost:11011/test1". In >my "httpd.conf" I have >++++++++++++++++++++++++++++++++++++++++++++++++++ ><VirtualHost 192.168.1.1> > DocumentRoot /var/www/html > <IfModule mod_rewrite.c> > RewriteEngine On > RewriteLog "/var/log/httpd/rewrite_log" > RewriteLogLevel 0 > RewriteRule ^/local/ - [L] > RewriteRule ^/(.*) http://myhost:11011/test1/$1 [P] > </IfModule> ></VirtualHost> >+++++++++++++++++++++++++++++++++++++++++++++++++ > > > >Whenever I try to acces "192.168.1.1" I get the following error in my >log file: >++++++++++++++++++++++++++++++++++++++++++++++++++++ >[Tue Aug 7 15:33:18 2001] [error] [client 192.168.1.1] attempt to make >remote request from mod_rewrite without proxy enabled: >proxy:http://rmyhost:11011/test1/ >++++++++++++++++++++++++++++++++++++++++++++++++++++ > >And I get the following through a browser: >++++++++++++++++++++++++++++++++++++++++++++++++++++ > 403 >Forbidden > > Forbidden > > You don't have permission to access / on this server. > _________________________________________________________________ > >++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > >What can I do to get around this? > >Mixo Shiburi > >P.S I am running Zope 2.5-6 and Apache 1.3-19 on Redhat linux 7.1 >(kernel 2.4.x) > > >_______________________________________________ >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 ) _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

1 0

RE: [Zope] Sql questions.
by CHOY,CHARLENE (HP-Boise,ex1) 07 Aug '01

07 Aug '01

Thanks Eric and Jim. I reread that section and found a better way to implement my sql. Have a nice day!^_^ -Charlene -----Original Message----- From: Eric Walstad [mailto:eric@walstads.net] Sent: Tuesday, August 07, 2001 3:13 PM To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail) Subject: RE: [Zope] Sql questions. Hi Charlene, Have you read the section of the Zope book regarding Dynamic SQL Queries? In particular, look for info on the "sqlgroup" tag. ( http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml ) and about 2/3 down the page you will see a heading that reads "Creating Complex Queries with the Sqlgroup Tag" If you need more detailed help, it would be helpful for us to see the SQL you are using now. Eric. > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > CHOY,CHARLENE (HP-Boise,ex1) > Sent: Tuesday, August 07, 2001 1:54 PM > To: Zope List (E-mail) > Subject: [Zope] Sql questions. > > > Hi, > The following is my problem. I have created a search form to > look up some > data from a database. The result of the search needs to be able to return > the searched data in certain order. How do I set condition in the sql > method so that it will return the object that I want and also specific > sorting_method that the user had chosen in the form. > I have attempted to solve this problem. I have created two sql methods > but both of them perform two differenct tasks. One of them is able to > return the searched data that I want, but the data are not in order. The > second sql will return correct order, but it includes some other > serch data > that I don't want. Does anyone know to combine both of them so that the > users can get the data that they are looking for in the sorting > method that > they have chosen? > I would also like to know is there anyway that i can set some > if/elif/else > condition in the dtml-sql? If so how can I do it. > > -Charlene > > _______________________________________________ > 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

Problems with Zope 2.4.0 and OpenBSD 2.8
by Pat Ritchie 07 Aug '01

07 Aug '01

Hi, I'm having all sorts of problems getting Zope running on my i386 OpenBSD box. I am using python 2.1.1 compiled with --with-threads. The first problem I had was compiling Zope, I got this error: make: don't know how to make ././src/Splitter.c. Stop I read the docs (doc/FAQ.txt) and It said for some BSD systems you need to use make -k, I made this change and it compiled. Once compiled I edited z2.py to use port 80 (8080 is blocked by my firewall) and then ran start. It seems to start up and run fine but when I go to myserver.com/manage it asks me for my name and password and then stalls loading the page. Log file output: B 10064236 2001-08-07T21:09:40 GET /manage I 10064236 2001-08-07T21:09:40 0 A 10064236 2001-08-07T21:09:40 200 1106 E 10064236 2001-08-07T21:09:40 B 10064108 2001-08-07T21:09:41 GET /manage_top_frame I 10064108 2001-08-07T21:09:41 0 A 10064108 2001-08-07T21:09:41 200 1404 E 10064108 2001-08-07T21:09:41 B 10065740 2001-08-07T21:09:41 GET /manage_workspace I 10065740 2001-08-07T21:09:41 0 A 10065740 2001-08-07T21:09:41 302 421 E 10065740 2001-08-07T21:09:41 B 10066220 2001-08-07T21:09:41 GET /manage_menu I 10066220 2001-08-07T21:09:41 0 A 10066220 2001-08-07T21:09:42 200 2773 B 10065740 2001-08-07T21:09:42 GET /p_/zopelogo_jpg I 10065740 2001-08-07T21:09:42 0 E 10066220 2001-08-07T21:09:42 A 10065740 2001-08-07T21:09:42 200 3090 E 10065740 2001-08-07T21:09:42 B 10065740 2001-08-07T21:09:42 GET /manage_page_style.css I 10065740 2001-08-07T21:09:42 0 A 10065740 2001-08-07T21:09:42 200 2894 E 10065740 2001-08-07T21:09:42 B 10067788 2001-08-07T21:09:42 GET /manage_main I 10067788 2001-08-07T21:09:42 0 This could be related to the original compiling problem as the -k flag tells make to "Continue processing after errors are encountered, but only on those targets that do not depend on the target whose creation caused the error" ... In other words I might now be missing an essential bit of Zope? Should this message be sent to the Zope-dev list as well? Thanks, Patrick

1 0

Building a page from multiple paramatised queries
by Giles Chamberlin 07 Aug '01

07 Aug '01

I'm a zope novice so I'm probably missing something obvious. My intent is to build a web page from the results of two queries, each of which are paramatised by the same value. I've got a single query working fine: FeatureDetailQuery has a parameter ID and SQL: select * from Feature where <dtml-sqltest Id op=eq type=int> FeatureDetail is a simple web page: <dtml-var standard_html_header> <h1><dtml-var Name></h1> <dtml-var standard_html_footer> and I bind the two together by referencing them with the a href = FeatureDetailQuery/Id/<dtml-var Id>/FeatureDetail All's well. My problem is that I want to add the output of another query, also parametised by Id to the same web page and I'm stumped as to how to go about it. Any suggestions? Giles Chamberlin

2 1

Sql questions.
by CHOY,CHARLENE (HP-Boise,ex1) 07 Aug '01

07 Aug '01

Hi, The following is my problem. I have created a search form to look up some data from a database. The result of the search needs to be able to return the searched data in certain order. How do I set condition in the sql method so that it will return the object that I want and also specific sorting_method that the user had chosen in the form. I have attempted to solve this problem. I have created two sql methods but both of them perform two differenct tasks. One of them is able to return the searched data that I want, but the data are not in order. The second sql will return correct order, but it includes some other serch data that I don't want. Does anyone know to combine both of them so that the users can get the data that they are looking for in the sorting method that they have chosen? I would also like to know is there anyway that i can set some if/elif/else condition in the dtml-sql? If so how can I do it. -Charlene

2 1

Regarding Mysql Query
by sudhakar 07 Aug '01

07 Aug '01

hi guys, i am very new to zope . i executed a query that will print 25 column. i don't want to hardcode the column name.i am getting the column name by below python script test.py rec = context.DbQuery1() print "names: ", rec.names(), "\n" return rec.names() using the column name i want to print the corresponding data. <dtml-in test.py> <dtml-in DbQuery1 size=10 start=query_start> <dtml-let names="_.getitem('sequence-item')"> <dtml-var names> </dtml-let> </dtml-in> </dtml-in> but it's printing the object. <r instance at 02FF5E50> <r instance at 02FF5730> <r instance at 02FF5200> <r instance at 02FF59A0> <r instance at 02FF54F0> <r instance at 02FF5B60> <r instance at 02FF5180> <r instance at 02FF64A0> <r instance at 02FF68B0> <r instance at 02FF6500> can any one help me . regards, S.Sudhakar Sys Admin, Progammer Mindscape Computing (P) Ltd., Bangalore

3 2

ScriptSearch.com: Link Added!
by gwinfield＠internet.com 07 Aug '01

07 Aug '01

Hello Digital Creations, Inc.: Thank you for visiting ScriptSearch.com! We've added your resource listing in our directory like this: Resource ID : 3009 Title : Zope URL : http://www.zope.org Summary : Web application framework Description : Zope is a framework for building web applications. A web application is a computer program that users access with a web browser over the Internet. You can also think of a web application as a dynamic web site that provides not only static information to users but lets them use dynamic tools to work with an application. Version : Price : ZPL Download URL : Editor's Pick: No Contact Name : Digital Creations, Inc. Contact Email: zope(a)zope.org And, A few other relevant URLs to keep close by. . . . Your resource is listed under: http://www.scriptsearch.com/Python/Scripts_and_Programs/Content_Management/ Your resource's details page is at: http://www.scriptsearch.com/details/3009.html Modify your resource listing by going to: http://www.scriptsearch.com/cgi-bin/modify.cgi?ID=3009&email=zope@zope.org We encourage you to place a rating form for your resource on your site. Just follow the steps at: http://www.scriptsearch.com/cgi-bin/get_rated.cgi?ID=3009 Please also add a link back to ScriptSearch from your site, like this: <A HREF="http://www.scriptsearch.com">ScriptSearch.com</A> Sincerely, Ronnie T. Moore ScriptSearch.com Note: Replies to this email will bounce. Email us at http://www.scriptsearch.com/cgi-bin/contact.cgi ) ScriptSearch Admin only: If mail bounces, delete resource: http://www.scriptsearch.com/cgi-bin/admin/admin.cgi?db=links&delete_records…

1 0

RE: [Zope] Pluggable Brains
by Montagne, Michael 07 Aug '01

07 Aug '01

Thank you my friend. It works now. -mjm -----Original Message----- From: J. Cone [mailto:jcone@g8labs.com] Sent: Tuesday, August 07, 2001 12:08 PM To: Montagne, Michael; 'zope(a)zope.org' Subject: Re: [Zope] Pluggable Brains Suggest you try: python Employee.py in the extensions directory and see if you get better information cheaper. At 11:54 07/08/01 -0700, Montagne, Michael wrote: >I'm trying to create a Pluggable Brain so I can incorporate various >functions involving employees from my ZSQL Method. > <snip> >This is the Employee.py file in the Extensions folder: >"""Employee class for extra innformation""" >class Employee: > def fullName(self): > """Returns full name for employee using nickname if any""" > if self.nickname: > return self.nickname + ' ' + self.emplastn > else: > return self.empfirstn + ' ' + self.emplastn <snip>

1 0

Pluggable Brains
by Montagne, Michael 07 Aug '01

07 Aug '01

I'm trying to create a Pluggable Brain so I can incorporate various functions involving employees from my ZSQL Method. This is the SQL code: SELECT StaffId, empfirstn, emplastn, nickname, extension, initials FROM tblHRPersonnel INNER JOIN tblS4Emp ON tblHRPersonnel.empidno = tblS4Emp.empidno WHERE tblS4Emp.empactive='Y' AND tblHRPersonnel.FilterOutofWeb=False ORDER BY tblS4Emp.emplastn; This is the Employee.py file in the Extensions folder: """Employee class for extra innformation""" class Employee: def fullName(self): """Returns full name for employee using nickname if any""" if self.nickname: return self.nickname + ' ' + self.emplastn else: return self.empfirstn + ' ' + self.emplastn This is the error: Traceback (innermost last): File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 223, in publish_module File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 187, in publish File e:\Program Files\Zope\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: ActiveStaff) File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 171, in publish File e:\Program Files\Zope\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_advanced) File e:\Program Files\Zope\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_advanced) File E:\Program Files\zope\lib\python\Shared\DC\ZRDB\DA.py, line 299, in manage_advanced (Object: ActiveStaff) File E:\Program Files\zope\lib\python\App\Extensions.py, line 238, in getBrain File E:\Program Files\zope\lib\python\App\Extensions.py, line 217, in getObject (Info: ('e:\\Program Files\\Zope\\Extensions\\Employee.py', 'Employee')) SyntaxError: (see above)

2 1