January 2001 - Zope - Zope lists

Opensource DBMS for WIN?
by Paul Zwarts 24 Jan '01

24 Jan '01

Greetings, Was wondering if there was an open source dbms to use with Zope on a Win2k machine...? I found references of using cygwin to run PGSQL (which we have on our unixbox) but would prefer something that doesnt run over an extender-shell... TIA, Paz

7 6

RE: [Zope] Some help required but no sarcastic comments this time please
by alan 24 Jan '01

24 Jan '01

alan, it seems like people are trying to help you. NOTE: no ones getting paid to answer your questions :) here are binaries for win32 for PostgreSQL and MySQL, http://highqualdev.com/ you can probably try these w/ the existing DA's ~runyaga

1 0

Help: Photo & Jpeg Support Problems
by J. Atwood 24 Jan '01

24 Jan '01

I have been playing around with Drew's photo product and it works great with GIFs but when I try to upload a JPEG into it I get the following Error Type: IOError Error Value: decoder jpeg not available Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addPhoto) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addPhoto) File /usr/local/zope/lib/python/Products/Photo/Photo.py, line 132, in manage_addPhoto (Object: Traversable) File /usr/local/zope/lib/python/OFS/Image.py, line 276, in manage_upload (Object: BZ_li_13.jpg) File /usr/local/zope/lib/python/Products/Photo/Photo.py, line 290, in update_data (Object: BZ_li_13.jpg) File /usr/local/zope/lib/python/Products/Photo/Photo.py, line 319, in _generateDisplays (Object: BZ_li_13.jpg) File /usr/local/zope/lib/python/Products/Photo/Photo.py, line 329, in _generateDisplay (Object: BZ_li_13.jpg) File /usr/local/zope/lib/python/Products/Photo/Photo.py, line 370, in resize (Object: BZ_li_13.jpg) File /usr/local/zope/lib/python1.5/PIL/Image.py, line 634, in resize File /usr/local/zope/lib/python1.5/PIL/ImageFile.py, line 133, in load File /usr/local/zope/lib/python1.5/PIL/Image.py, line 237, in _getdecoder IOError: (see above) I have tried and tried again to recompile jpeg, include the path.. whatever! I am using Zope 2.2.4 , on RH 6.2 Thanks, J

2 2

dtml-in sql => dtml-in anything?
by Joh Johannsen 24 Jan '01

24 Jan '01

Is it possible to replace an existing ZSQL method with an identical Python External Method that behaves exactly the same way? So if I have a ZSQL method "GetThingFromDB" <dtml-in GetStuffFromDB> got a <dtml-var thing> </dtml-in> Can I replace "GetThingFromDB" with a Python External Method? I've discovered that if I return a list, then that list gets returned one item at a time. But what value does each item have? I'd like to just have the external method return exactly the same thing as the ZSQL, but I'm having some problem finding what format (if any) that is. Is this sort of thing even possible? Thanks, JJ

2 1

Re: ZClasses and "title" property
by Tim Moore 24 Jan '01

24 Jan '01

I guessed it was something like this, so this leads me to two followup questions. 1) I'd be happy to use the built-in title property assuming that it won't cause some kind of problem. I just don't know how I can set that in instance objects since it doesn't appear on the property sheet. Can I modify the addForm and add methods for the class to set it there? Do I need to make a custom view? What approach do most people take in this situation, using the built-in title or choosing a different name for a title-like property? 2) The tutorial in the Zope Developer's Guide instructs you to add a "title" property to CDClass (http://www.zope.org/Documentation/Guides/ZDG-HTML/ZDG.6.2.4.html) I haven't actually run through the tutorial exactly, but I assume from my experience that this won't actually work. Maybe this part of the guide should be changed to reflect this (as well as other sections that also use "title" as an example property). Thanks for the responses! "Loren Stafford" <lstafford(a)morphics.com> writes: > "title" is a "reserved" property; i.e. most objects automatically > get a title property when you create them, but you are trying to add > another property with the same name. Either use the "built-in" title > property or use a different id for your title. > > -- Loren > > -----Original Message----- > From: tmoore(a)challah.msrl.com [mailto:tmoore@challah.msrl.com]On Behalf > Of Tim Moore > Sent: Friday, January 19, 2001 14:59 > To: zope(a)zope.org > Subject: [Zope] ZClasses and "title" property > > > Let me start by introducing myself...My name is Tim Moore and I'm > new to the list and Zope in general. I'm still figuring out how > everything works, so forgive me if I'm missing something basic here > :-) > > I'm creating several ZClasses for the site I'm working on. In one > of them I'd like to have a property called "title", but when I try > to add it, I get the following error: > > Error Type: Bad Request > Error Value: The id "title" is invalid--it is already in use. > > I'm confused, because this seems to happen even when I make a > bare-bones minimal class, but a few of the examples I've found on > the web site have ZClasses with title properties. > > I'm using version 2.3b1...is this a recent change in behavior or am > I doing something wrong? If this is a change, does this mean I have > to use a different property name, or is there some other way I can > edit this title property? -- Tim Moore

2 1

Re: [Zope] EMail with uploaded attachments
by Dieter Maurer 23 Jan '01

23 Jan '01

Klaus Herrmann writes: > ... Email with file attachment ... > <dtml-sendmail mailhost=fox> > To: ... > From: ... > Subject: ... > <dtml-mime type=text/plain encode=7bit> > > plain text.... > > <dtml-boundary type=application/octet-stream > disposition=attachment encode=base64> > <dtml-var attached_file></dtml-mime> > > </dtml-sendmail> Almost perfect. Use <dtml-var "attached_file.read()"></dtml-mime> instead. Dieter

1 0

Re: [Zope] Zope, database field formats, output format of queries
by Dieter Maurer 23 Jan '01

23 Jan '01

Michael Schmidt writes: > On Mon, Jan 22, 2001 at 07:50:45PM +0100, Dieter Maurer wrote: > > What do you mean with a Zope based database? > > > > If you mean an external database, look for the datatypes and > > restrictions, they support for column values. SQL 3 may > > give you some of what you want. > > The wording of "Zope based database" may cause a misunderstanding, > what I really meant was a database behind Zope or a database > accessed through the interface of Zope. That is what I have called an external database. You may look what constraints the database allows to define for field values. > > Whether internal or external, you can control what goes through > > Zope to your database. You will probably need External Methods to > > get the full Python power, see "python.org" for documentation > > about Pythons vast library. > > You will be especially interested in the "re" module. > > It implements (Perl style) regular expressions. > > Do these also achieve error handling? No. They allow you to check whether the conditions are met. You are free to decide what you do in this case. The easiest thing is to raise an exception. This results in a preconfigured error response, which probably is not too useful. You may look for a recent message to this list about DTML contracts. It may give you most of what you want. Dieter

1 0

Re: [Zope] Limited folderish objects
by Dieter Maurer 23 Jan '01

23 Jan '01

Nolan Darilek writes: > The Folder class offers quite a bit of the functionality which I need > for a current project. However, what I'm attempting to create isn't a > traditional folder for DTML objects, methods, etc. Instead, I'm > creating a folder which contains subfolders which are intended for > specific objects. The "available objects" list in the parent folder > should only allow the creation of a certain type of object. > > So, how can I do this? I was told that I could modify the permissions > on the folder to prevent other objects from being added, and this > seems to be confirmed by what I managed to find out about > filtered_meta_types, but I'm not sure. Can anyone offer any advice? You should search the (searchable) list archive. You will find at least one thread that discusses this issue. You may also find a HowTo at zope.org. Dieter

1 0

Re: [Zope] Adding users with a PythonMethod
by Dieter Maurer 23 Jan '01

23 Jan '01

Curtis Maloney writes: > I'm trying to add a users from within a PythonMethod. I have searched this > list and found examples of how to add via DTML, but they all seem to require > REQUEST. > ... > So, what I'm left to conclude is it's easier to add a new user from DTML > than it is from a PythonMethod. Can't be! You can use REQUEST in a PythonMethod, too. Either pass it explicitly as parameter or use "self.REQUEST" to access it. Dieter

1 0

Zope is not getting MySQL SELECT results ...
by Gerald Gutierrez 23 Jan '01

23 Jan '01

Hi all. I have set up, in a clean Zope installation, a MySQL database adapter. My connection string is "test test test", indicating a user test with password test connection to the test database. The adapter indicates that it can connect to the database, and I can send queries to the database. CREATE TABLE, INSERT, UPDATE, and other queries work just fine through the "test" tab of the adapter management interface, but it does not seem to be able return any data through a SELECT query. This does not work in the "test" table nor in a SQL method. Using a query, such as "select * from test", it always replies with: -------------------------------------------- There was no data matching this My Query query. SQL used: select * from test -------------------------------------------- I know the queries are reaching the database, because if I give it a bogus command, it gives me an error, and if I give it a command that affects the data, I can see that reflected in the database itself with MySQL's "mysql" client. So what is a problem here? As another test, I tried out the MySQL-python module; it works just fine. I'm using Python 2.0, Zope 2.3b2, ZMySQLDA 1.2.0, MySQL-python 0.3.0. Thanks for any help. Gerald.

1 0