May 2001 - Zope - Zope lists

jcNTUserFolder
by Özgür Caner 29 May '01

29 May '01

Hi, does anybody have any experience with Zope on Windows2000 with Active Directory Service and jcNTUserFolder to authenticate Users against Windows? Please contact me... Özgür Caner -- http://teuto.net

1 0

Z2.log time format
by Felipe E. Barousse Boue 29 May '01

29 May '01

Hello all: I believe this has been asked and solved before but, wanted to clarify the issue: Is there a way to control the time zone and time offset that Zope records its log on ? An example: my system has Zope behind apache (which works fine) but the log's times are not the same. [29/May/2001:08:20:14 -0500] This is the time/date logged by apache for a request [29/may/2001:13:20:14 -0500] This is the time/date logged by Zope (Z2.log) for the same request after it passed through and received by Zope. Why is there a 5 hour difference ? What is the best way to set the Zope log times to be the same as apache's ? (and ideally the the same as the system's time) Thanks for your feedback. Felipe Barousse

1 0

repost: standard_error_message and roles
by Danny William Adair 29 May '01

29 May '01

Hi! Strange behavior... While customizing my standard_error_message, I ran into a problem: Someone with the role "Member" is logged in and tries to access a resource that does not exist. Same could happen to someone who doesn't have that role (Anonymous). Now I have two different style sheets for members and non-members: A member might click on a broken link from within the members-only area (having a... pink background), the anonymous user clicked the same broken link from a publicly accessible area of the site (having a... silver background). I would like to keep the different background colors when showing my error message so I put a <dtml-if "AUTHENTICATED_USER.has_role('Member')"> <dtml-var "members_css"> <dtml-else> <dtml-var "public_css"> </dtml-if> in the head section of standard_error_message (these *_css are ZStyleSheets) My problem is, that it's always the public_css that's used. So I checked with <dtml-var "AUTHENTICATED_USER.getRoles()"> in both the members area and standard_error_message. To my surprise the member role was gone: In the members area - after authentication - getRoles() returned ('Member',) while in standard_error_message ( _.str(error_type)=='NotFound' ) it returned ('Anonymous',) btw, the role is not really "lost", I can go back to the members area and click through members-only pages without problems. What's happening?

2 1

RE: [Zope] Seing if an attribute exist in an ObjectManager
by Max Møller Rasmussen 29 May '01

29 May '01

> From: Jerome Alet [mailto:alet@unice.fr] > what you need is: > > if imID not in self.objectIds() : > # doesn't exist > else: > # already exists If I had had half a brain I would have known it myself ... Guess i'm tired :-) Thanks. regards Max M

1 0

Seing if an attribute exist in an ObjectManager
by Max Møller Rasmussen 29 May '01

29 May '01

I have set an image in an ObjectManager object like this: imID = 'laeringsGraf' self._setObject(imID, OFS.Image.Image(imID,'Lærings graf','')) self._getOb(imID).update_data(data) I only want to draw it if it isn't there allready How do I then check if it allready exists? I guess it's something like:: if not hasattr(self, imID): ?? or if not self._has_attr(imID) regarsd Max M

2 1

RESPONSE.setHeader
by Paul Zwarts 29 May '01

29 May '01

Hi, Does anyone know how to setHeader of the RESPONSE to a document in Zope which would ordinarily be read as an html file will now be downloaded? I list some files in a page and then I want to be able to download these documents, but of course the browser will load and render them. I have tried: <dtml-call "RESPONSE.setHeader('Content-Disposition','Attachment; Filename=' + document)"> where document is the &dtml-absolute_url; of the object I want. But it will give me a popup window to save the HTML file of the page that lists the files I want available for download. <dtml-call "RESPONSE.setHeader('refresh', '4;URL=' + document)"> Will of course get me the correct page as well, but again, the browser will render it since it is in fact of DTML Document type... But how do you force a download? Thanks again, Paz

2 2

Re: [Zope] Passing arguments to secondary SQL query
by Oliver Bleutgen 29 May '01

29 May '01

> Greetings, > I am generating a report based on a SQL query, say query1. Using dtml-in > it > iterates over each returned row. Within each row, I would like to create > a > table based on a second query, say query2. Everything works great until I > insert query2 in a second dtml-in statement. I can't figure out how to > pass > query2 arguments, which are dtml-vars from the current loop of query1. I > get the error: Bad Request, Error Value: ['var1']. Here's a simplified > example: > query1: select var1 from mytab; > query2: select newvar from mytab2 where myvar = <dtml-sqlvar var1 > type="string">; > Report: > <dtml-in query1> > <dtml-var var1><br> > <dtml-in query2>  > <dtml-var newvar><br> > </dtml-in> > </dtml-in> try <dtml-in "query2(var1=var1)"> i.e., you have to explicitly pass the arguments. cheers, oliver

1 0

Passing arguments to secondary SQL query
by Matthew Nelson 29 May '01

29 May '01

Greetings, I am generating a report based on a SQL query, say query1. Using dtml-in it iterates over each returned row. Within each row, I would like to create a table based on a second query, say query2. Everything works great until I insert query2 in a second dtml-in statement. I can't figure out how to pass query2 arguments, which are dtml-vars from the current loop of query1. I get the error: Bad Request, Error Value: ['var1']. Here's a simplified example: query1: select var1 from mytab; query2: select newvar from mytab2 where myvar = <dtml-sqlvar var1 type="string">; Report: <dtml-in query1> <dtml-var var1><br> <dtml-in query2>  <dtml-var newvar><br> </dtml-in> </dtml-in> Thanks a bundle in advance for any suggestions. Regards, Matt Nelson Esperion Therapeutics, Inc.

1 0

Connecting to MS SQL
by Luca Manini 29 May '01

29 May '01

Hi, I'm trying to connect to a MS SQL (7) server. I read the note http://www.zope.org/Members/roberth/ZMSSQLServer and I followed all the steps. But I can't get connected (see error below). Other ODBC connections do work (to MDB files). The ODBC Manager seems to be happy with the configuration. And the connection do work with Delphi. Any hint ? Any "strange" constraint (case sensitive, ...) Set up is: NT4 MS SQL 7 (on another NT 4 machine) Zope Version Zope 2.3.2 (binary release, python 1.5.2, win32-x86) Python Version 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform win32 TIA, Luca. Traceback (innermost last): File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\PROGRA~1\Zope\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\PROGRA~1\Zope\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_addZODBCConnection) File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_addZODBCConnection) File C:\Programmi\Zope\lib\python\Products\ZODBCDA\DA.py, line 104, in manage_addZODBCConnection (Object: Traversable) File C:\PROGRA~1\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line 132, in __init__ (Object: RoleManager) File C:\PROGRA~1\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line 161, in edit (Object: RoleManager) File C:\PROGRA~1\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line 240, in connect (Object: RoleManager) File C:\Programmi\Zope\lib\python\Products\ZODBCDA\db.py, line 155, in __init__ BadRequest: (see above)

1 0

Product Developers Guide
by Peter Bengtsson 29 May '01

29 May '01

At http://www.zope.org/Members/mcdonc/PDG You have only published one chapter. Chapter 6 about security. Do you have anything unfinished, because I'm desperate now for this to become ready. Peter

2 1