June 1999 - Zope - Zope lists

Re: [Zope] (no subject)
by Joachim Schmitz 30 Jun '99

30 Jun '99

Hi, I'm using this for example: SELECT * FROM ADRESSEN WHERE vorname LIKE  AND name LIKE  AND organisation LIKE  AND strasse LIKE  AND plz LIKE  AND ort LIKE  AND tel LIKE  AND fax LIKE  ORDER BY  On 30 Jun 1999, CURTIS David wrote: > Friends of Zope, > I am a newbie who wants to know how to search for for data on a MySQL database using the SQL LIKE command. I used the tutorial and found it helpful but It show how to search for exact matches only. I suppose this is easily done, Any ideas? > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) > Gruß Joachim Schmitz WWW-Consultant email: js(a)ac-copy.net tel: +49-241-89491-0 fax: +49-241-89491-29

1 0

Re: [Zope] (no subject)
by Alex Rice 30 Jun '99

30 Jun '99

On 30 Jun 1999 11:53:01 -0700, CURTIS David <David.Curtis(a)state.or.us> said: CURTIS> Friends of Zope, I am a newbie who wants to know how to search CURTIS> for for data on a MySQL database using the SQL LIKE command. I CURTIS> used the tutorial and found it helpful but It show how to search CURTIS> for exact matches only. I suppose this is easily done, Any CURTIS> ideas? See the Mysql manual, section 7.10 "Select Syntax" and 7.3.6 "String comparison functions". % and _ are the wildcard characters in Mysql like. select colname from tablename where colname like '%substring%' Alex Rice | alrice(a)swcp.com | http://www.swcp.com/~alrice Current Location: N. Rio Grande Bioregion, Southwestern USA

1 0

(no subject)
by CURTIS David 30 Jun '99

30 Jun '99

Friends of Zope, I am a newbie who wants to know how to search for for data on a MySQL database using the SQL LIKE command. I used the tutorial and found it helpful but It show how to search for exact matches only. I suppose this is easily done, Any ideas?

1 0

RE: [Zope] zcatalog always catalogs whole site when using 'Find' tab.
by Michel Pelletier 30 Jun '99

30 Jun '99

> -----Original Message----- > From: Anthony Baxter [mailto:anthony@interlink.com.au] > Sent: Wednesday, June 30, 1999 1:11 AM > To: zope(a)zope.org > Subject: [Zope] zcatalog always catalogs whole site when using 'Find' > tab. > > > first off, the ZCatalog tutorial has a chunk that includes > example HTML, > without quoting it - search for 'Replace it with this:', it's the line > before and the line after. > > next thing - if I add a ZCatalog to a subfolder, and do a 'find into > catalog', the search will start at the top of the Zope tree. > This seems > unintuitive to me - it should only do the find from the folder object > containing the ZCatalog. (This is more in keeping with the > behaviour of the > existing 'Find' tab) > > the following will change ZCatalog to have this behaviour: > > --- ZCatalog.py Wed Jun 30 15:00:23 1999 > +++ ZCatalog.py.orig Wed Jun 30 14:56:10 1999 > @@ -248,11 +248,11 @@ > obj_permission=None): > > """ Find object according to search criteria and Catalog them > """ > > - results = self.ZopeFind(REQUEST.PARENTS[1], > + results = self.ZopeFind(REQUEST.PARENTS[-1], > obj_metatypes=obj_metatypes, > obj_ids=obj_ids, > obj_searchterm=obj_searchterm, > obj_expr=obj_expr, > obj_mtime=obj_mtime, > > Does this seem reasonable? Or should it be a checkbox in the 'Find' > page to specify whether to search the entire site? > You are correct, and it's fixed in the latest CVS. Thanks for the tip. On another catalog Note, for those of you who are keeping up with the development of the Catalog in CVS, you must make sure that you update your Zope as well. For example, to keep the Catalog's memory consumption resonable, it uses the shiny new sub-transactions. To use subtransactions, you must have the latest CPickleCache and ExtensionClass compiled in your Zope. -Michel > Anthony > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

2 1

unable to reach root Zope security page
by Michael Wang-Helmke 30 Jun '99

30 Jun '99

hi all, I recently installed Zope 1.10.3 for win32 over my existing Zope (which I think was an earlier 1.10). Everything has seemed to be fine but when I go to the root folder and click on the security tab, I get the traceback at the end of this message. I tried uninstalling zope (though not the win32 registry keys) and then re-installing (thinking the object database might be corrupt) but still have the same behavior. I'll probably get around to doing a full fresh reinstall of 1.10.3 (cleaning everything) later today but was wondering if anyone as run into this before? thanks greatly, Michael Wang-Helmke <html> <head> <title>exceptions.TypeError</title> </head> <body> Sorry, an error occurred.<p>  </body> </html>

1 0

Read-only mode
by JP Glutting 30 Jun '99

30 Jun '99

Hi, After using Zope for several months now, and working on it today, I suddenly started to get this message: ! Attempt to perform a write operation while the database is in read-only mode. I have never seen this, and am not sure what exactly caused this problem. The only strange things I have noticed lately is that the ZHTTPServer has been shutting itself off while it is unattended. Has anyone ever had this problem? How does one put the database in write mode? Thanks, JP *************************************************** JP Glutting The Spanish Cochrane Centre Institut Universitari Fundació Parc Taulí Parc Taulí s/n 08208 Sabadell (Barcelona) Phone: (34) 93 723.40.94 Fax: (34) 93 716.38.04 Email: jpglutting(a)cspt.es http://www.cspt.es/cochrane/lc_crg.htm ***************************************************

1 0

Zope 2 Beta soon?
by Kevin Dangoor 30 Jun '99

30 Jun '99

Hi, I have a bunch of work to do with Zope 2 for the next phase of my site(s), but I'm using a Windows machine. Is the Zope 2 beta coming soon? Or should I invest time in getting the user-contributed Windows binaries working? Kevin

2 1

RE: [Zope] ftp editing methods
by Brian Lloyd 30 Jun '99

30 Jun '99

> This probably isn't a new idea but: > > How about having the ability to define in the Zope UI certain > protocols > (or Roles+Protocols) as "editing" protocols instead of "publishing" > protocols, like WebDAV and FTP for example. When objects are accessed > via those protocols, instead of seeing a single object, you > see all it's > properties, meta type, etc as sub-objects which you can edit > individually. This is still a harder problem than it appears on the surface. For example, it is not possible to tell for sure during a GET whether the client is a DAV client or not - this is a lamosity that I hope to get the time to address with the IETF WebDAV group at some point. FTP is a little more clear-cut, but there are still problems with trying to graft capabilities like property management onto a protocol that was never designed to support it. Perhaps you could see properties as a "subobject" of a DTMLDocument for example, and if you accessed the properties via FTP maybe you would get some sort of xml representation of them which you could edit and save to update the properties. But what does that mean for FTP clients? Everything will look like a directory, and things begin to behave less like you would expect if you don't know much about what's going on. One of the goals of FTP/DAV integration is to allow a greater range of users to interact with Zope in a way that fits their tool prefs and level of knowledge -- for example, WYSIWYG tools like Dreamweaver, etc. could use FTP behind the scenes and act as a non-threatening front end to Zope for less experienced users. I suspect that such tools would not behave quite in the expected way if all documents suddenly looked like containers :( Making FTP more useful is certainly a Good Thing, but exactly how we do that will require some careful consideration - especially in terms of hijacking the protocol to do Zope-specific things, since invalidating the expectations of clients would foil much of what we'd hoped to achieve with FTP integration. Just my $0.02... Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

hidding Zope´s traceback info
by Joachim Schmitz 30 Jun '99

30 Jun '99

Hello, is it possible to switch of the error-traceback at all, so that the user gets only the "sorry an error occured" ? Gruß Joachim Schmitz WWW-Consultant email: js(a)ac-copy.net tel: +49-241-89491-0 fax: +49-241-89491-29

1 0

RE: [Zope] ftp editing methods
by Michel Pelletier 30 Jun '99

30 Jun '99

> -----Original Message----- > From: Will Fife [mailto:will@techfuel.com] > Sent: Tuesday, June 29, 1999 1:04 PM > To: Michel Pelletier > Cc: 'Stefan Bund'; zope(a)zope.org > Subject: RE: [Zope] ftp editing methods > > > Would it be possible to have a comment of some sort on the > top line of the > file that would tell the server what type of file that it is? > Yes, this suggestion was forwarded by Hadar, but it makes me shudder a bit. Sniffing content is never a very deterministic way of doing things. It could be done, I guess, as a configurable option. -Michel

3 2