- Zope - Zope lists

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

RE: [Zope] PHP as a scripting language for Zope
by Farrell, Troy 27 Mar '01

27 Mar '01

Actually, ASP uses server-side JavaScript and VBScript. That is probably where he is refering to. IMO, zope needs more clean up before it gets more features. Troy -----Original Message----- From: Bill Anderson [mailto:bill@libc.org] Sent: Tuesday, March 27, 2001 12:56 PM To: zope(a)zope.org Subject: Re: [Zope] PHP as a scripting language for Zope On 27 Mar 2001 13:30:08 -0300, Luciano Ramalho wrote: > Just as we have Script (Python) and Script (Perl) we should have Script > (PHP) as a standard Zope object. > And while we are at it, why not evaluate the possibility of integrating > JavaScript and VBscript? Because those are CLIENT-side, not server side. Because many of us have browsers that do not use that atrocity known as vbscript, and javascript tends to be rather difficult/time consuming to write in a cross-platform way. We have enough to work on already without adding that stuff. Bill _______________________________________________ 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 )

2 1

SV: [Zope] PHP as a scripting language for Zope
by Geir Bækholt 27 Mar '01

27 Mar '01

I have to agree that adding internal support for more languages beside perl and python would dilute the common effort that brings us forward. What would be really useful , though , would be for someone knowledgeable to write a howto on how to connect to php from external methods. That way one could use the business logic from PHP-scripts (one might have something lying around) and leverage them through the Zope framework. As PHP is runnable from commandline, i cannot see why this should not be possible.. -- Geir Bækholt geirh(a)funcom.com >Well I am making this really complex mediastreaming system, and thought >that Zope could help me with my problems about user privileges. So I >thought: >I'll make the application in PHP and then I just run the scripts through >Zope. Then my application will be very strong, and I won't have to make >my own apllication for handling users. >Guess I was very very wrong. > >I has taken me all day to set up Zope with MySQL and it is still not >working. >Then I tried to run some PHP scripts in Zope - but no. That isn't >possible. > >Maybe it takes some time to add PHP scripts to python. But then Zope >will really become serious > >Regards, > >-- >************************ >Gitte Wange Jensen > >System Squid Developer >MMManager Aps >+45 29 72 79 72 > >gitte(a)mmmanager.org >************************ > > >_______________________________________________ >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 ) >

2 1