September 2001 - Zope

Trying to get Form/Checkbox value into Python Script
by Ronald L. Chichester 29 Sep '01

29 Sep '01

I've found the problem with getting data into a python script. It is with the checkboxes. If the checkbox is checked, the parameter is passed and the boolean property is set properly. However, if the checkbox is unchecked, I get a Zope error indicating that the parameter was NOT passed. Same form, same everything except in the test second test case the checkbox was unchecked. In essense, it only passes the checkbox value when the checkbox is checked. Does anyone know what I'm doing wrong? How do you pass boolean values (i.e., from checkboxes) to a python script when the box is unchecked? Thanks, Ron

3 2

Re: [Zope] setting cookies in a python script? (OmniWeb issue)
by Marc Dumouchel 29 Sep '01

29 Sep '01

Oleg wrote: > Why Python Script? Just set the cookie with explicit path in DTML. I did try that first, but it didn't work, and I couldn't find any reference material on how to do it properly. What I tried was: RESPONSE.setCookie('bandwidth', 'high', domain='su.ualberta.ca', path='/', expires='Wed, 19 Feb 2020 14:28:00 GMT') Can you tell me what is wrong with that call? TIA, marc

2 1

Invalid connection string: when using ZODBC Connection with a MsAccess Db
by Hamzat kamal 29 Sep '01

29 Sep '01

Good day, For the first time I was trying to create a Db connection with ZODBC Adapter to my MSAccess Db. This was the error displayed when I clicked Add . Invalid connection string: trans hamzat webmaster Traceback (innermost last): File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\WebSite\lib\python\Zope\__init__.py, line 226, in zpublisher_exception_hook (Object: LockableItem) File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_addZODBCConnection) File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_addZODBCConnection) File C:\Program Files\WebSite\lib\python\Products\ZODBCDA\DA.py, line 104, in manage_addZODBCConnection (Object: LockableItem) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\Connection.py, line 132, in __init__ (Object: RoleManager) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\Connection.py, line 161, in edit (Object: RoleManager) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\Connection.py, line 240, in connect (Object: RoleManager) File C:\Program Files\WebSite\lib\python\Products\ZODBCDA\db.py, line 155, in __init__ BadRequest: (see above) trans -is my specified data source name( the name of my MSaccess Database) hamzat -is my specified user id webmaster -is my specified password. Kindly help to correct what I am doing wrong. Another thing that is not clear to me is that do I have to move the Db to a particular directory in the zope installation directory. Thanks. Kamal

1 0

dtml-sqlgroup where question
by Juergen Gather 29 Sep '01

29 Sep '01

I'm looking for an easy way to find out, if dtml-sqlgroup where generated a where clause or not. Problem: If nothing is entered in my search form, there is no where-clause and I get all DS as result - what I'm looking for is way to add something like where 1=2 if there is no where clause generated by dtml-sqlgroup where - of course I could check each of my 64 input fields ;-) if they were all left blank but I hope there is a better way do achieve this. Any hints ? Thank you, Juergen

1 0

List handling and Python Products
by Andrew Kenneth Milton 29 Sep '01

29 Sep '01

Periodically I don't seem to be able to get lists out of REQUEST when in a Python Product method. I'm running 2.4.1 with python 2.1. I'm sure this worked before. REQUEST['foo'] gives me the first entry in the list, not the list. I've verified that this does work under 2.3.1, and 2.3.2 Anyway in case it's just me, here's a set of tests to try. <form method="POST" action="someMethod"> <select name="foo:list" multiple> <option value="1" selected>1 <option value="2" selected>2 <option value="3" selected>3 </select> <input type="submit" value="Go"> </form> def someMethod(self, REQUEST): print REQUEST['foo'] print type(REQUEST['foo']) def someMethod(self, foo=[], REQUEST): print foo print type(foo) print REQUEST['foo'] print type(REQUEST['foo']) -- Totally Holistic Enterprises Internet| | Andrew Milton The Internet (Aust) Pty Ltd | | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm(a)theinternet.com.au|

1 0

Problem with local roles
by Danni Efraim 29 Sep '01

29 Sep '01

Hi, people. I've got a problem I was hoping someone would be able to help me with. I'm working on a site where people can log in using a web form, and then administer any pages they happen to have administration rights to. I want people to be able to use the login form anywhere on the site (it's in the navigation panel), but the administration links will only appear when the actual rights to administer a page are present, and the administration methods are of course restricted. Anyway, the solution I thought would be adequate would be the following: * Have a top-level UserFolder in which the content managers exist, but having only the restricted role "Guest". * Any user who's supposed to be able to administer a page will have the local role of "ContentManager" in that folder. This, however, does not work at all. No administration links appear, and attempting to access the editing methods doesn't work. And now to the weirder part. Adding a UserFolder to the folder, and adding a user with the same name and password, and the role "ContentManager" works just fine. Keeping dual user entries seems like a maintenance nightmare, though. I'm using Zope 2.3.3, with Python 2.1 on a Linux 2.4.7 (all those lovely numbers!). Am I doing something stupid, or is Zope being mean to me? /Danni

2 1

Copying files from a SiteRoot folder
by Trevor Toenjes 29 Sep '01

29 Sep '01

SiteRoot seems to be preventing me from using ZMI to copy/cut files to other areas in Zope. Is there a solution? (OR is there a different SiteRoot-type product that allows this?) TIA, Trevor

3 2

setting cookies in a python script? (OmniWeb issue)
by Marc Dumouchel 29 Sep '01

29 Sep '01

On our Zope site (www.su.ualberta.ca) we have a splash page that lets users choose which version of the site they want to see. That page has links to two methods, each of which set two cookies: splash --> gets set to 'yes', this prevents the user from encountering the splash page on subsequent visits. bandwidth --> gets set to either 'high' or 'low', depending on which method they click through to. The code for one of the methods, "setBandwidthHigh", (the other is almost identical): <dtml-call "RESPONSE.setCookie('bandwidth', 'high', domain='su.ualberta.ca', expires='Wed, 19 Feb 2020 14:28:00 GMT')"> <dtml-call "RESPONSE.setCookie('splash', 'yes', domain='su.ualberta.ca', expires='Wed, 19 Feb 2020 14:28:00 GMT')"> <dtml-call "RESPONSE.redirect('index_html')"> The problem I have is with a browsers such as OmniWeb 4.0.5 (Mac OS X). OmniWeb adds the path of the method to the cookie, so the cookie gets listed in this form: domain: su.ualberta.ca path: /setBandwidthHigh name: bandwidth value: high Other browsers simply list the path as /, and work just fine. Omniweb doesn't work, because when index_html checks for the cookie, the cookie as listed doesn't show up because the path is too specific. Doing a <dtml-var REQUEST> shows no cookie entries under OmniWeb (unless I include the path in the URL- e.g. "www.domain/setBandwidthHigh/samplepage/". Instead, the splash page just comes back up. I'm still pretty new to Python, but I was thinking that if I put a form button on the page to select the site version, I could have a Python script execute when it clicked that set the cookie properly in OmniWeb (i.e., with a path of '/'). Can I set cookies from within a Python script? Any other suggestions to solve my problem?

2 1

RE: [Zope] dtml-sqltest
by Montagne, Michael 28 Sep '01

28 Sep '01

You doofus!! If you pass an argument named tblProjData.MktSectorID then all is well. -mjm -----Original Message----- From: Montagne, Michael [mailto:montagne@BOORA.com] Sent: Friday, September 28, 2001 4:15 PM To: 'zope(a)zope.org' Subject: [Zope] dtml-sqltest The following string in a ZSQL method will not include any where clause. What is wrong? The MktSectorID field occurs in both tables so I need to specify it with the dot notation. Could that be it? If I remove the optional, I get the same result. SELECT tblProjData.projnumb, tblProjData.projname, tblProjPhase.ProjIsActive, tblProjMktSector.projtype, tblProjData.MktSectorID FROM (tblProjData INNER JOIN tblProjMktSector ON tblProjData.MktSectorId = tblProjMktSector.MktSectorID) INNER JOIN tblProjPhase ON tblProjData.ProjPhaseID = tblProjPhase.StatusID <dtml-sqlgroup where> <dtml-sqltest tblProjData.MktSectorID type="int" op="eq" optional> </dtml-sqlgroup> ORDER BY tblProjData.projnumb; _______________________________________________ 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

dtml-sqltest
by Montagne, Michael 28 Sep '01

28 Sep '01

The following string in a ZSQL method will not include any where clause. What is wrong? The MktSectorID field occurs in both tables so I need to specify it with the dot notation. Could that be it? If I remove the optional, I get the same result. SELECT tblProjData.projnumb, tblProjData.projname, tblProjPhase.ProjIsActive, tblProjMktSector.projtype, tblProjData.MktSectorID FROM (tblProjData INNER JOIN tblProjMktSector ON tblProjData.MktSectorId = tblProjMktSector.MktSectorID) INNER JOIN tblProjPhase ON tblProjData.ProjPhaseID = tblProjPhase.StatusID <dtml-sqlgroup where> <dtml-sqltest tblProjData.MktSectorID type="int" op="eq" optional> </dtml-sqlgroup> ORDER BY tblProjData.projnumb;

1 0