- Zope - Zope lists

SQL call inside <dtml-let> (Somebody help please I'm goin' INSANE !!!!!!!!!)
by Δημήτρης Ανδρακάκης 27 Mar '01

27 Mar '01

(I think the subject says it all :-) So I've got this dtml method, which is called by a form. It used to be something simple like: <dtml-var standard_html_header> <dtml-call sqlInsertAnnouncement> <h2>Thank you</h2> <dtml-var standard_html_footer> Now I want to make it more sofisticated, so that the user enters less data. I came up with this: <dtml-var standard_html_header> <dtml-let date="_.str(ZopeTime())" folderid="date[5:7]+date[2:4]" fileid="file.filename[_.max(_.string.rfind(file.filename, '/'), _.string.rfind(file.filename, '\\'), _.string.rfind(file.filename, ':'))+1:]" link="folderid+'/'+fileid"> <dtml-comment> <dtml-call sqlInsertAnnouncement> </dtml-comment> <dtml-var link><br> <dtml-var ann_title><br> <dtml-var comment><br> <dtml-var category><br> </dtml-let> [there are more stuff here, but they work fine... what they do is upload a file] <dtml-var standard_html_footer> Notice the <comment>s around the sql call. Once I remove them. I get a "Bad Request". I've put the <dtml-var>s so I can see if the vars the sql method requires (link, ann_title, comment, category) are ok --and they are. I've tested it 1000s of times, it all works fine except for the <dtml-call>. Is it some bug ? Does the call not work inside <dtml-let> ? Is it something else I'm missing ? Any guru please, it's driven me crazy ! I'm using zope 2.2.2 behind apache 1.3 (.19 I think) and RH 6.2. Dimitris @ Nuclear

3 2

ZClass question
by Samuel D. Gendler 27 Mar '01

27 Mar '01

I think I remember seeing someone mention this in an email, but I couldn't find it... Has anyone thought about a method of allowing ZClasses to be CREATED inside a folder, rather than the Control Panel, so that users of shared zope environments such as hosting or inside CMF can build ZClass based products without access to Control Panel. I know that ZClasses are no longer considered the wave of the future, so maybe there is something being thought about by the CMF folks so that Product Development does not have to occur at such a high level within the security framework. --sam

1 0

Re: Re: [Zope] ZSQL & LIKE Operator
by Donald Braman 27 Mar '01

27 Mar '01

Thanks! That worked! -Don ---------Included Message---------- Date: Tue, 27 Mar 2001 23:00:27 +0100 From: "tom smith" <tom(a)othermedia.com> Reply-To: "tom smith" <tom(a)othermedia.com> To: <donald.braman(a)yale.edu>, <zope(a)zope.org> Subject: Re: [Zope] ZSQL & LIKE Operator on 3/27/01 10:56 PM, Donald Braman at donald.braman(a)yale.edu wrote: > I'm trying to get Zope to submit a "like" statement to MS Access (please > don't ask why I'm using MS Access; it's a temporary situation). Anyway, > I can't get a working ZSQL method LIKE and a wildcard. > > I try: > SELECT * > FROM Cases > WHERE Short_Case_Name LIKE 'Plessy v. Ferguson' > works fine; I try: > WHERE Short_Case_Name LIKE 'Plessy*' I use the % sign with Access and it seems to work OK WHERE Short_Case_Name LIKE 'Plessy%' Cheers tom -- tom smith | tom(a)othermedia.com http://www.othermedia.com/blog tel 020 8541 5355 | fax 020 8541 5507 11 penrhyn road, kingston-upon-thames, london KT1 2BZ ---------End of Included Message---------- Donald Braman donald.braman(a)yale.edu

1 0

Re: [Zope] interactive linking
by Dieter Maurer 27 Mar '01

27 Mar '01

paulousek writes: > I apologize for posting a maybe stupid newbie question, but: > what I intend to realize is a CM-system where editors can interactively > interlink documents (in the sense of creating HREFs). They must be able to > indicate the link's target, which might be either internal (another Zope > object/document), or external (a complete URL selected from a list) or even > void. The interface should not be typing the target's data/address in, but > selecting it from a form-element like a scrollable list. > Can this be done easily with Zope or will I have to prepare myself for long > Python-programming sessions? > (BTW: the same procedure for selecting content should be available for > images and downloadable files.) > > hope I haven't bothered the community... You have not... But I do not understand where your problem is: 1. build the scrollable list? 2. implement the linking? 1. is trivial once you know which elements should be part of the list and how to get them. For 2., I would use either a relational database or the ZCatalog if the links are not embedded arbitrary in the text but presented together at well defined places and query the database at these places to obtain the targets (identified via URL's). Dieter

1 0

Re: [Zope] ADD ACL USER?
by Dieter Maurer 27 Mar '01

27 Mar '01

=?iso-8859-1?Q?Daniel_Corr=EAa_de_Azevedo?= writes: > How could I create a document with a customized form for adding users to > Zope and to authenticate them? You build your form and use "acl_users/manage_users" either directly as action or indirectly. More details in the (searchable) mailing list archives (an excellent resource!). Search for "manage_users". Dieter

1 0

Re: [Zope] List of DB error
by Dieter Maurer 27 Mar '01

27 Mar '01

=?iso-8859-1?Q?Daniel_Corr=EAa_de_Azevedo?= writes: > Where can I find a list of the possible zope message errors types while > using a DB connection. > I need that because of need to implement all the <dtml-except ERROR_TYPE> > for operations with a DB. I guess there is no compiled list. All exceptions I have seen so far for database accesses came from the Python interface to the database, usually a DB-API interface. I think, there is a quasi-standard, to have an object called "error" in the implementing object and use that to report database problems. However, the module may raise standard errors as well, such as "ValueError". I fear, you will need to look at the documentation (or even source) of your specific database interface implementation. Dieter

1 0

Re: [Zope] Aquisition..hurts so good
by Dieter Maurer 27 Mar '01

27 Mar '01

Mike Webb writes: > .... > <dtml-var expr="aq_parent.aq_parent.learnix_984971699.index_html()"> > > index_html contains: > > <dtml-var raw_index> > > With raw_index being a method of the ZClass of the learnix_984971699 object. > I get the error: > > Error Type: KeyError > Error Value: raw_index Your problem has nothing to do with acquisition.... It is a standard error made over and over again: DTML objects are called with two positional parameters called "client" and "REQUEST". When you let DTML call the object, then it calls it with "_.None" and "_" as parameters. The "_" propagates the namesspace. When you call the object explicitly (as you do) and do not pass the namespace, a DTML Method starts with an empty namespace and any access to a Zope object will give you a KeyError. Details in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html Dieter

1 0

Re: [Zope] Some ideas about the future of Zope products...
by Dieter Maurer 27 Mar '01

27 Mar '01

Philippe Jadin writes: > "What seems to be a pain when creating a product is the fact that you need > to provide your own User Interface. Why do I need to create a specific UI to > let the user update the title of my product? And if I want to have my user > edit the title trough ftp? Webdav? Do I have to take care of this as well? > We should easily agree that UI is not a part of the product, but a part of > Zope." I recently learned GIMP (URL:http://www.gimp.org) It was very nice to see, how script interfaces were build from a very compact and easy parameter description. Should not be too difficult to build. However, I doubt very much, that many Zope users (!) will be satisfied with such interfaces. While the GIMP interfaces are for developers (and therefore, there is not need for Corporate Identity or extensive design) many Zope interfaces are for consumers. Such interfaces will need much more noise (in form of colors, logos, CI, SchnickSchnack,...) and will suffer from a restriction to the bare functionality. Dieter

1 0

Too early initialization of property sheets?
by John R. Daily 27 Mar '01

27 Mar '01

Under Zope 2.3.0, with ZClasses I'm defining within Zope: I have a method defined in a base class to loop through all property sheets in the newly-created object and capture properties which are stored in the REQUEST object. I invoke it during the manage_add<product> method for inheriting classes. An example: --- # Defined on behalf of class Foo def manage_addFoo(id, title=""): foo = context.Foo.createInObjectManager(id, context.REQUEST) foo.private_init_defaults() foo.request_set_properties(context.REQUEST) --- # Defined in inherited class VirtualFoo def request_set_properties(REQUEST): sheets = container.propertysheets for sheet in sheets.values(): for prop in sheet.propertyIds(): if REQUEST.has_key(prop): sheet.manage_changeProperties({prop:REQUEST[prop]}) --- Unfortunately, the sheets at this point in time seem to be immutable. I get errors which look as if property_extensible_schema__() is returning 0. The properties can be modified through the administrative interface after initialization, so I'm confident that I'm not somehow accidentally inheriting FixedSchema. In an earlier version of this product I invoked foo.propertysheets.default.manage_editProperties(context.REQUEST) at the same point in manage_addFoo, but in this case I want to make certain that all inherited property sheets are handled in an automated fashion. Am I approaching this in the wrong manner? -- -- John R. Daily jdaily(a)progeny.com Systems Programmer Progeny Linux Systems Master of the ephemeral epiphany

1 0

Re: [Zope] Can I trust the variables?
by Dieter Maurer 27 Mar '01

27 Mar '01

Jan-Frode Myklebust writes: > I'm doing a external method that's supposed to zip-up files selected via > LocalFS, and I'm wondering if I can trust the special variables set in a > request. Can I trust that f.ex. URL/URLn/URLPATHn are from where the external > method was called, and not set by the user via http-headers? We recently discovered a bug in Zope (--> list archives): a REQUEST parameter named URL lets Zope create a really strange URL. In Zope 2.3, URL<i> and friends are not affected. HTTP Header should not be a problem, as they are prefixed with "HTTP_". Dieter

2 2