August 2001 - Zope - Zope lists

SortEx module feature request thinking
by Peter Bengtsson 28 Aug '01

28 Aug '01

If you pass an argument to sort on to the SortEx and pass also 'nocase' it breaks if the thing to sort on cannot be case insensitive. This works: r=SortEx(sequence, ( ( 'companyName' , ) , ) ) # and this r=SortEx(sequence, ( ( 'companyName' , 'nocase' ) , ) ) # and this r=SortEx(sequence, ( ( 'modificationTime' , ) , ) ) # But this breaks! of course r=SortEx(sequence, ( ( 'modificationTime' , 'nocase' ) , ) ) Sensible. But suppose that one really doesn't know what one is sorting one? * If its a string property, I want it case-insensitive. * If its a date property, don't pass the 'nocase' thing Maybe there is a way to do this, but I don't know how. So how? If there isn't a way to do this, can I suggest a syntax like this: r=SortEx(sequence, ( ( REQUEST.foobar , 'nocase' , 'anyproperty' ) , ) ) ...or... r=SortEx(sequence, ( ( REQUEST.foobar , 'nocase_nocomplain' ) , ) ) Regards, Peter

2 3

retro-fit zClasses with ObjectManager base class
by Trevor Toenjes 28 Aug '01

28 Aug '01

Hi all. I am new to Zope and trying to follow the subclass thread...it seems to relate to my current problem. So I was hoping to get some advice to what I think is a more basic issue. I am in a project using many zClasses and now need to add images to them. However, I did not set them up with ObjectManager. Is there a way to add ObjectManager to an existing zClass? If not, is there a shortcut to import all the data from the existing zClass to the new zClass(with images)? Thanks for the help. -Trevor Toenjes

1 0

CMFCalendar
by Todd Loomis 28 Aug '01

28 Aug '01

When I try to install the CMFCalendar i get the following error: Error Type: TypeError Error Value: Catalog addIndex now requires the index type to be resolved prior to adding; create the proper index in the caller. How can I fix this? Thanks, Todd

1 0

rendering accented characters from postgres
by Sion Morris 28 Aug '01

28 Aug '01

Hello, ** Many apologies for sending this message as HTML before. ** I'm having problems rendering accented characters from Postgres. A table with publication titles, mostly english, but also with welsh, french and spanish titles does not render accented characters properly in IE or Netscape. Using telnet on a Mac to access Postgres on Linux with psql renders the titles correctly. The postgres table is Latin 1 encoded. Telnet does not attempt any translation as far as I can tell but can display the text correctly. IE has the default character set of Western (Latin 1) but does not render the text correctly; instead of é it displays Z. But, when I change the character set in IE to Western Mac the characters display properly. Clients on Windows do not have this character set. Does anybody have any idea what I'm doing wrong or which is the best way to do this? Hwyl, Sion

1 0

rendering accented characters from postgres
by Sion Morris 28 Aug '01

28 Aug '01

1 0

DateTime under phyton script
by Kerekes Lajos 28 Aug '01

28 Aug '01

Hi! I have a form. It contains 3 drop-down boxes, named start_year:int, start_month:int, start_day:int. How can I use them, to make a datum object under phyton script? I try starttime = DateTime(container.REQUEST.start_year, container.REQUEST.start_month, container.REQUEST.start_day) but it gives an error Error Type: TypeError Error Value: illegal argument type for built-in operation Could anybody help me? Thanks: Lajos Kerekes

2 2

Re: [Zope] More Zope/PostGreSQL/PoPyDA.
by acg 28 Aug '01

28 Aug '01

----- Original Message ----- From: "Jim Penny" <jpenny(a)universal-fasteners.com> To: "acg" <acarrasco(a)udiberica.com> Sent: Monday, August 27, 2001 10:00 PM Subject: Re: [Zope] More Zope/PostGreSQL/PoPyDA. > On Mon, Aug 27, 2001 at 02:28:09PM +0200, acg wrote: > > My personal configuration: > > ZPoPyDA 2.0.7 > > Zope 2.4.0 > > Python 2.1.1 > > Debian/GNU Linux > > > I don't know. Frankly, I do not like the -sqltest and -sqlgroup > tags because I can hardly ever figure out what they do. But, I > think that they in fact expand to a simple text string long > before the database adapter sees it. So I am purely guessing > that you will see the same independent of DA. Yes, I think so too. "before the database adapter sees it." > > > Another bug or is it only a bad dtml construction? > > Again from ZopeBook I see this > > > > Examples > > > > Sample usage: > > > > select * from employees > > > > <dtml-sqlgroup where> > > > > <dtml-sqltest salary op=gt type=float optional> > > > > <dtml-and> > > > > <dtml-sqltest first op=eq type=string multiple optional> > > > > <dtml-and> > > > > <dtml-sqltest last op=eq type=string multiple optional> > > > > </dtml-sqlgroup> > > > > (...) > > > > If salary is 50000 and last is Smith it renders: > > > > select * from employees > > > > where > > > > (salary > 50000.0 > > > > and > > > > last='Smith' > > > > ) This example is from Chapter 10, Dinamic SQL Querys, Creating complex queries with sqlgroup tag. > > Actually, yes, this does look right. > > > > > Mmmm..., is ZPoPyDA supposse to do that? I don?t think so. My code: > > > > And from here on, I get lost with what functions you are calling and what > parameter values are being used. This is the ZSQLMethod selectDepartments I use to have a combo box with all departments. This is what i have in the management interface to try with it before I use it. I test this with blank arguments (nothing in an input text) and I get this (in spanish): <<< There was no data matching this Mostrar Departamentos query. ---------------------------------------------------------------------------- ---- SQL used: SELECT * FROM Departamentos where nombre = '' ORDER BY idDepartamento >>>>> Mmmm... It´s supposse to do a SQL like "SELECT * FROM Departamentos ORDER BY idDepartamento" because the argument "nombre" is optional and it hasn´t to be rendered by Zope > > > Arguments: id, name.> > > > SELECT * FROM Departments> > <dtml-sqlgroup where>> > <dtml-sqltest id op=eq type=int optional>> > <dtml-and>> > <dtml-sqltest name op=eq type=string optional> IT WORKS!!! with the fix by Jim Penny> > </dtml-sqlgroup>> > ORDER BY id> > > > My Query Result without blanks arguments, Zope renders...> > > > SELECT * FROM Departments> > where> > name = ''> > ORDER BY idDepartamento> > > > Ups! Is it my code or is it a new bug? I?m thinking about change to psicopg... Is it a good idea?> > > > Antonio Carrasco> > > > > > > > >

1 0

Re: DateTime under phyton script
by Juan García García 28 Aug '01

28 Aug '01

Hi, You must change two things, the first one is to change the type of the three drop-down boxes, instead of int, put string, the second is in the python script, write: starttime = DateTime(container.REQUEST.start_year + '/' + container.REQUEST.start_month + '/' + container.REQUEST.start_day) I think it will work. Bye. >Hi! >I have a form. It contains 3 drop-down boxes, named start_year:int, >start_month:int, start_day:int. >How can I use them, to make a datum object under phyton script? >I try >starttime = DateTime(container.REQUEST.start_year, >container.REQUEST.start_month, container.REQUEST.start_day) >but it gives an error >Error Type: TypeError >Error Value: illegal argument type for built-in operation

1 0

sizeof(folder or object)?
by marc lindahl 28 Aug '01

28 Aug '01

is there any Pythonic way of getting the size (as in, how much room in data.fs, and/or memory) of an object, like a folder or a basic item? The only thing I could find was a package called mxTools...?

1 0

Zope Users in Nevada?
by Michael R. Bernstein 28 Aug '01

28 Aug '01

Ok, my search for zope users in Southern Nevada has not borne any fruit, so I figured I'd ask if there were any other Zope users anywhere in Nevada at all (north or south). Anyone? Michael Bernstein.

1 0