- Zope - Zope lists

Do While Loop Equivalent
by McDonnell, Larry 22 May '03

22 May '03

Hi, I have been searching for a while but I am coming up empty. I am writing a module that needs to create a block of records in the db so they can be updated at a later time. In the good old days, I would use a do while loop (do something while x < 10). How can this be done? And as always any pointers will be appreciated, thanks. Larry McDonnell Proton Energy Systems 10 Technology Drive Wallingford, CT 06492 (203) 678-2181 Email:lmcdonnell@protonenergy.com www.protonenergy.com

5 4

Filesystem Permissions for a Zope Install
by Edward Pollard 22 May '03

22 May '03

Hey Guys, Got some angst about permissions on the server we have Zope installed on. Up to now, world has had read access to the entire Zope tree. We need to turn that off since there are users that can access this server that should not be allowed to peruse the Python code we've been writing. However, the only immediate alternative seems to be to add Apache to the "Zopeadmins" group we have, but that has read-write, and letting Apache have write is a potential security hazard. Can anyone with greater knowledge of the interaction of Zope and Apache tell me if I can be more selective about my permissions? And, more generally, how have other people solved these problems? Edward

5 6

Which Postgres is best for Zope/Plone on OS X, package or fink install?
by Chris Beaumont 22 May '03

22 May '03

Hello, I am using my OS-X iBook as a devlopment platform and I have recently installed the combination Plone/Zope install.. I'm hoping to use this install with Postgres, but there are several installation options.. There is a OS-X 'package' (which comes off the Postgres official site) and.. There is a Fink package (which is basically a OSX version of a Debian package) or.. I could insall Posgres from source.. The primary reason for installing Postgres is to use it with Zope, so ease of interfacing the two is my main concern, since I've had problems getting Psycopg to do this in the past.. Does anyone have any suggestions? -Chris

2 1

setting date to Null in MS SQL?
by Kelley, Sean 21 May '03

21 May '03

I have a simple app where I need to let people set dates to null via a form. I am trying to test for an empty form field and set the value to NULL if empty. It seems to work on form submission but when I do a database query I see it is actually set to 1/1/1900 I have found a way to update a record if it already has a value and you clear the form field, but for some reason this same method does not work for an initial insert. In both of my sql methods I have: <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> What am I missing?

1 0

Can't save Version in 2.6.1, please help!
by Ken Causey 21 May '03

21 May '03

I know, I'm an idiot for using Versions, but they've worked reasonably well for me for a while and they are very handy for my situation allowing me to make modifications in the background and more or less instantaneously commit them for all to see. I have a Version I've been working in now for about 3 weeks. I've modified and/or created around 50 new objects. No matter what I do I can neither Save or Discard this version. I've tried doing while working in the version, while not working in the version. I've packed the database two or three times. I've gone through and while working in the version I've resaved every single modified object. Nothing I do will result in the version being saved. At this point I've even tried to discard the version so it will free up the locks on the objects and even that won't work. I'm using Zope 2.6.1 with Python 2.1.3. If there is any other information I can provide please let me know. I'm getting desperate for a solution to this. Help me this time and I swear I will never use Versions again. Ken Causey

4 6

How to get the value of form data in Page Template itself?
by saravanan annamalai 21 May '03

21 May '03

Hi All, I have a form in a page template. Submission of the form calls the same page again with some other parameters. I want to get the value of the parameter(form data) in the Page Template itself. Its very urgent for me... Hope somebody helps me regards saravanan A ___________________________________________________ Impress your clients! Send mail from me @ mycompany.com . Just Rs.1499/year. Click http://www.rediffmailpro.com to know more.

3 2

ldapuserfolder
by Adriana Chirita 21 May '03

21 May '03

Hello I've installed LDAPUserFolder and it works great when I look for members in the LDAP Base. But when I try to enter my site authenticating under ldap, I've got a big bug in python.exe: "the instruction at "0x696d5320" uses the memory adress "0x696d5320". Memory can't be "read"" (sorry, it's translated from french...). I'm developping under windows 2000, with Zope2.6.1 and the latest version of plone, and the ldap server is an openldap 2.07 running under a woody machine. Does someone have an idea?

2 1

Dynamic Folders in <dtml-in>
by Dieter Fischer 21 May '03

21 May '03

Hello I have the following struture in my folders: sql - oracle - postgresql - odbc I've the idea to share most of the SQL-Methods via aqusition (they are in sql), but have the specific ones (not ANSI SQL) in the db folder (e.g Oracle with it's to_date function. I've tried this statement for an <dtml-in>: <dtml-set query="sql.oracle.browse()"> #1 See bottom <dtml-in "query" size=12 start=query_start> which works fine. I'd like to have it more dynamicly, so I tried: <dtml-set query_string="'sql.'+getDatabase()+'.browse()'"> #1 See bottom <dtml-set query="_.getitem(query_string)"> #1 See bottom <dtml-in "query" size=12 start=query_start sort="code,bez"> getDatabase is a Python-Script which get's the db for the folder (oracle,postgresql,odbc). But it doesn't find the object: Error Type: KeyError Error Value: sql.oracle.browse() This resource may be trying to reference a nonexistent object or variable sql.oracle.browse Anybody can give me an advice for the correct syntax? Thanks Dieter #1 I'm using the dtml-set tag, so <dtml-call "REQUEST.set(foo, 10)"> is: <dtml-set foo='10'>

5 8

Other content types and ZPT
by Jeremy Cook 21 May '03

21 May '03

Hi, I want to create a real audio metafile (.ram extension) on the fly using templates but am struggling with this. A .ram file should contain a single line with the URL of the media file that I want the client browser to play. I want to create this URL using ZPT so that the correct URL relative to the portal home is given. I don't want to use a hard coded URL because that would mean that my media content wouldn't work when I move my portal to another location for off-line editing. It would also mean that links could be broken in an obscure way some time in the future. If I create a 'page template' called 'RMTheJam.ram' with a simple line pointing (for now) to a hardcoded URL: http://217-13-29-76.dd.nextgentel.com/KSMi/interactive/TheJamBam.rm and then in the Page template editor change the content_type from text/html to audio/x-pn-realaudio then I get an error "cannot import name expat". Any ideas how to achieve a dynamic real audio metafile? I am running zope 2.6.1 Thanks, -- Jeremy Cook <Jeremy.Cook(a)ii.uib.no> Parallab

3 2

formulator form.header() problem
by Mark Nenadov 21 May '03

21 May '03

Hello all, I'm making a form with the latest version of Formulator. When I call form.header() it gives me a "mutilated" form header like so: <form enctype="multipart/form-data" method="POST" name="add_vehicle_form" action="addVehicleMethod enctype="multipart/form-data">" > It doesn't put the last quote after my action and it adds the enctype line again. This obviously causes problems. I've confirmed that I didn't make any mistakes in the form settings I'm using Zope 2.6.1 and Formulator 1.4.0. I'd appreciate any feedback. ~Mark

2 1