May 2000 - Zope - Zope lists

ZCatalog
by Markus Hochreiter 08 May '00

08 May '00

hi, i have the problem when I am searching in the ZCatalog I can not search for thing like email adress because of the "@" and not for strings like "123" (only digits)! I don't use the Index of the Catalog!!!! mex

2 1

Re: [Zope] MySQL - PostgreSQL - ZODB
by J. Atwood 08 May '00

08 May '00

I have had way too many bad experiences with MS SQL 7.0. Here are just a few. 1) It is a pig. It wants at "LEAST" 128 MB for itself (NT wants another 128) 2) It is not stable. Ask most NT network admins and they will admit to having a 'AT' command to reboot every night. 3) It is proprietary and subject to too many bugs/security holes. If IIS, ASP, Office and Outlook have taught us anything it is that security is not number one on the list of priorities for Microsoft. Can you say "ILOVEYOU?" Here is why I like PostgreSQL 1) It is stable. It goes up and stays up. Period. 2) It is Open Source. Many eyes means less bugs and less security holes. 3) It is easy. It comes installed on RH 6+ and is ready to go. Many more but I am probably opening this up to a huge debate that I do not want to. In the end, use the tool that you are comfortable using and fits within your overall plan. J > From: Richard Moon <richard(a)dcs.co.uk> > Date: Mon, 08 May 2000 14:36:31 +0100 > To: "J. Atwood" <jatwood(a)bwanazulia.com> > Subject: Re: [Zope] MySQL - PostgreSQL - ZODB > > >> MS SQL 7.0 I will not comment about since >> I would never run a production website with that product. > > Can you explain why not ? > > > > Richard Moon > richard(a)dcs.co.uk > >

1 0

ZCatalog, ZClass
by Markus Hochreiter 08 May '00

08 May '00

Hi, I have a problem with the zCatalog! I have created a APerson product with a ZClass (CatalogAware as base Class). Below are the Form and the Methode to insert a Instance procrammatically. After adding a Aperson, I get no result when I'm searching(with a normal ZSearch Interface) in the Catalog! So my question: Is there anything wrong in my methods, or is this a problem from zope, or are there parameters in zope which I have to set up? thanks for your help mex Form: <H2>Add APerson</H2> <form action="adressbuch_add_processor"> <table> <tr><th>Vorname</th> <td><input type=text name=name></td> </tr><tr><th>Nachname</th> <td><input type=text name=nname></td> </tr><tr><th>Email</th> <td><input type=text name=email></td> </tr><tr><th>TelephonNr</th> <td><input type=text name=phone></td> </tr><tr><td></td><td><input type=submit value=" Add "></td></tr> </table></form> Add methode: <dtml-call "REQUEST.set('name',name)"> <dtml-call "REQUEST.set('nname',nname)"> <dtml-call "REQUEST.set('email',email)"> <dtml-call "REQUEST.set('phone',phone)"> <dtml-with "manage_addProduct['APerson']"> <dtml-call "APerson_add(_.None, _, NoRedir=1)"> </dtml-with> Thanks! APerson_add Methode: <dtml-call "REQUEST.set('ts', ZopeTime())"> <dtml-call "REQUEST.set('id', _.str(_.int(ts)))"> <dtml-with "APerson.createInObjectManager(REQUEST['id'], REQUEST)"> <dtml-call "propertysheets.Properties.manage_editProperties(REQUEST)"> <dtml-call reindex_object> </dtml-with> <dtml-if NoRedir> <dtml-else> <dtml-if DestinationURL> <dtml-call "RESPONSE.redirect(DestinationURL+'/manage_workspace')"> <dtml-else> <dtml-call "RESPONSE.redirect(URL2+'/manage_workspace')"> </dtml-if> </dtml-if>

2 1

Freelance Programmers?
by Brendon Grunewald 08 May '00

08 May '00

Dear Zopers, Does a freelance / "Sourcexchange(tm)" type thing exist that caters best for Zope / Python programmers? What is the best place to find programmers for specific (feature / module) as well as less specific tasks (like Webmaster)? Brendon Grunewald 70South: The No1 source for Antarcticles(tm). --------------------------------------------------------------------------------------------------- For the latest news and views on Antarctica visit http://www.70south.com

1 0

Re: [Zope] Interbase DB
by bobc＠p-wave.com 08 May '00

08 May '00

Interbase 6.0 will be open source for all platforms according to the open source Q&A at interbase.com : http://www.interbase.com/open/community/opensource_qa.html. The current version (5.6) is still commercial however. The 6.0 version comes with a user defined function library which includes date functions (I had the same problem when I started to use Interbase - found a UDF library, from Canada I think - NT only however) It also now has an Extract operator to work with the datetime datatype. I've been using Interbase since version 4.0 (about four years). I have it in use with up to 35 users simultaneously. I don't know how well it would scale to very large systems. I also would like to see an Interbase DA for Zope. I'm not enough of a Python programmer yet to do it myself, but I might have to bite the bullet and try. Bob Corriher Original Message Message: 55 Reply-To: "Ian Sparks" <isparks(a)wmute.u-net.com> From: "Ian Sparks" <isparks(a)wmute.u-net.com> To: <bkc(a)murkworks.com>, <zope(a)zope.org> Subject: Re: [Zope] Interbase DB Date: Fri, 5 May 2000 18:42:54 +0100 charset="iso-8859-1" This may not help at all but I know there is a Perl interface to Interbase - saw it at www.interbase.com a while back. Can I ask why the interest in Interbase over, say, PostgreSQL I've been using Interbase on NT for a few years now. It's stable, zero maintenance, hard-to-kill and has decent features like triggers, stored procedures etc. The one thing that lets it down is the built-in functions - you really need to get a User Defined Functions (UDF) library from day 0 and install it to do any sort of date manipulation for instance. My problem with this is that it makes your DB code hard to port between platforms - that UDF lib you use on NT won't work on Linux - esp. since UDF libs are often written in Delphi and thus tied to Win32 (at least until Kylix is released). I also notice that Interbase don't seem to offer a free version to NT users - that's because they have so many NT customers who already bought licences who will want refunds! One final notice is that Interbase only became Open Source after its key members of its development team walked out in protest over the way that the parent company was pushing (or not) the product. How can Interbase.com turn this crisis into an opportunity? OpenSource it! - Ian Sparks. ----- Original Message ----- From: "Brad Clements" <bkc(a)murkworks.com> To: <zope(a)zope.org> Sent: Friday, May 05, 2000 3:25 PM Subject: Re: [Zope] Interbase DB On 5 May 2000, at 9:38, Olivier Deckmyn wrote: > When looking for Interbase on python.org, one can find : > > http://www.python.org/topics/database/modules.html > > where there seem to exists at least one python module to connect to > Interbase RDBMS ... > > This could be a starting point for a DAInterbase? Yes, thats Kinterbasdb. I wrote to the author a few weeks ago, but never received a reply. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements __________________________________________

4 6

ZAG for Unix?
by Stephen 08 May '00

08 May '00

Folks - Maybe I'm just missing something as a very fresh newbie, but I can't find the Zope Administrators Guide for Unix anywhere. Just the (ugh) NT version. Can someone give me a hand? Thanks. - Steve Sign up for a free About.com Email account at http://About.com

2 1

RE: where has the REQUEST-object gone???
by Andy Pahne 08 May '00

08 May '00

OK, I found the solution in the FAQ. It was just a matter of calling the helper-method get_text the solution was: <dtml-var "get_text(_.None, _, id_to_get=xxxx)"> Andy ----- Original Message ----- From: Andy Pahne <ap(a)net22.net> To: <zope(a)zope.org> Sent: Monday, May 08, 2000 2:38 PM Subject: where has the REQUEST-object gone??? > > > hi, > > at the moment we are builduing a database-enabled three-language website. we > have the contents (texts) for the site already in a database. I wrote a > Z-SQL-Method sql_get_text which takes id_to_get as argument. So, when I > call > > <dtml-in "get_text(id_to_get=xxxx)"> > <dtml-var text_value> > </dtml-in> > > I get the text I was looking for. (Note that this ZSQL-method will return > only one result, because id_to_get is the primary key of the database table > and therefore unique). > > > I wanted to make things a bit easier for the people who generate the > templates for the site. So I coded a helper-method named get_text which also > takes id_to_get as argument. It holds exactly the code-snippet from above. > By doing so I wanted the HTML-Coders to type > > <dtml-var "get_text(id_to_get=xxxx)"> > > so that they do not have to worry about the dtml-in-tag. It did not work. I > get an error-message that Zope can not find the ZSQL-method sql_get_text > method. Here is the traceback: > > Traceback (innermost last): > File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line > 214, in publish_module > File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line > 179, in publish > File /usr/local/src/Zope-2.1.6-src/lib/python/Zope/__init__.py, line 202, > in zpublisher_exception_hook > (Object: ElementWithAttributes) > File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line > 165, in publish > File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line > 160, in mapply > (Object: content) > File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line > 102, in call_object > (Object: content) > File /usr/local/src/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line 150, > in __call__ > (Object: content) > File > /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py, line > 502, in __call__ > (Object: content) > File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, > line 335, in eval > (Object: _['content-ms']) > (Info: _) > File <string>, line 0, in ? > File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, > line 161, in careful_getitem > File /usr/local/src/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line 146, > in __call__ > (Object: content-ms) > File > /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py, line > 502, in __call__ > (Object: content-ms) > File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, > line 335, in eval > (Object: get_text(id_to_get='AXIN_001')) > (Info: get_text) > File <string>, line 0, in ? > File /usr/local/src/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line 146, > in __call__ > (Object: get_text) > File > /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py, line > 502, in __call__ > (Object: get_text) > File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_With.py, > line 132, in render > (Object: REQUEST) > KeyError: (see above) > > > > My next idea was: > > <dtml-with REQUEST> > <dtml-in "get_text(id_to_get=xxxx)"> > <dtml-var text_value> > </dtml-in> > </dtml-with> > > I don't know why, but the <dtml-with REQUEST> fixed a lot of errors before, > so I just gave it a try. But then I received and error-message telling me > that I am trying to refference the non-existing object REQUEST. > > Now, why doesn't it find my method and why did the REQUEST-object > disappear??? > > PS: I am doing Zope for half a year now but the namespace-stack is still > mysterious to me. > > > Andy Pahne, ap(a)net22.net > > net22 GmbH > Bad Meinberger Strasse 1 > 32760 Detmold > 0 52 31 - 580 640 > > http://www.net22.net >

2 1

Re. MySQL - PostgreSQL - ZODB
by Jerry Spicklemire 08 May '00

08 May '00

Here's a brief review (ZDNet) of Interbase, PostgreSQL, and MySQL. http://www.zdnet.com/pcweek/stories/news/0,4153,2436153,00.html General consensus is, for high-read / low write, MySQL is fastest, but in a dynamic environment PostreSQL shines. Some caching issues with the current Intebase for Linux hampers performance, but that should be resolved as things evolve. Here's a thread from /. with some good discussion. http://slashdot.org/askslashdot/99/08/10/0416205.shtml

1 0

where has the REQUEST-object gone???
by Andy Pahne 08 May '00

08 May '00

hi, at the moment we are builduing a database-enabled three-language website. we have the contents (texts) for the site already in a database. I wrote a Z-SQL-Method sql_get_text which takes id_to_get as argument. So, when I call <dtml-in "get_text(id_to_get=xxxx)"> <dtml-var text_value> </dtml-in> I get the text I was looking for. (Note that this ZSQL-method will return only one result, because id_to_get is the primary key of the database table and therefore unique). I wanted to make things a bit easier for the people who generate the templates for the site. So I coded a helper-method named get_text which also takes id_to_get as argument. It holds exactly the code-snippet from above. By doing so I wanted the HTML-Coders to type <dtml-var "get_text(id_to_get=xxxx)"> so that they do not have to worry about the dtml-in-tag. It did not work. I get an error-message that Zope can not find the ZSQL-method sql_get_text method. Here is the traceback: Traceback (innermost last): File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/src/Zope-2.1.6-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: content) File /usr/local/src/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: content) File /usr/local/src/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: content) File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: content) File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: _['content-ms']) (Info: _) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, line 161, in careful_getitem File /usr/local/src/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line 146, in __call__ (Object: content-ms) File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: content-ms) File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: get_text(id_to_get='AXIN_001')) (Info: get_text) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/OFS/DTMLMethod.py, line 146, in __call__ (Object: get_text) File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: get_text) File /usr/local/src/Zope-2.1.6-src/lib/python/DocumentTemplate/DT_With.py, line 132, in render (Object: REQUEST) KeyError: (see above) My next idea was: <dtml-with REQUEST> <dtml-in "get_text(id_to_get=xxxx)"> <dtml-var text_value> </dtml-in> </dtml-with> I don't know why, but the <dtml-with REQUEST> fixed a lot of errors before, so I just gave it a try. But then I received and error-message telling me that I am trying to refference the non-existing object REQUEST. Now, why doesn't it find my method and why did the REQUEST-object disappear??? PS: I am doing Zope for half a year now but the namespace-stack is still mysterious to me. Andy Pahne, ap(a)net22.net net22 GmbH Bad Meinberger Strasse 1 32760 Detmold 0 52 31 - 580 640 http://www.net22.net

2 1

non static size parameter in dtml-var
by Scott Parish 08 May '00

08 May '00

I have a dtml-var tag that is being repeated over and over inside of a dtml-in tag. I would like the client to be able to custimize the maximum amount of text output they see, so i did something like the following: <dtml-var "item['title']" size="getTitleLen()"> Where getTitleLen is a method which returns an integer of how many characters max the title is to be. However, when i have this dtml method rendered, i get the following error: a size attribute was used in a var tag with a non-integer value. Is there a do what i am trying to do? If so, how could i do it? If not, why isn't this possible? thanks sRp -- Scott Parish http://srparish.net

2 5