- Zope - Zope lists

ZCatalog problem on insert
by Menard.Jean-Francois＠hydro.qc.ca 14 Nov '00

14 Nov '00

I'm experiencing some problems with the zCatalog. I made some customized forms for inserting data. Yes, I use the <...reindex_object>. And Yes, I use <...manage_addProduct>. I can see the objects in the Catalog, but my search results are always empty! If I update the Catalog manually (in the "Cataloged Objects" tab), everything is OK, until I insert data again. It only happens when I insert data, not when I modify or delete an object. So, as soon as I insert objects via my custom form, my Catalog search stop working ! Am I the only one experiencing this problem ? I use Catalog in a lot of sites, it's the first time I have such problem. Any clue would be very appreciated... I'm supposed to demo the site tomorrow morning... :\ Jean-François Ménard Intranet DPAS Pratiques d'affaires et orientations * (514) 840-3000 poste 3939 * (514) 840-5585 * menard.jean-francois(a)hydro.qc.ca * 855 Ste-Catherine est, 6e étage Montréal, Qué. H2L 4P5

1 0

Problen wtih dtml-in inside Zsql method
by Alejandro Pancani 14 Nov '00

14 Nov '00

---------------------------------------------------------------------------- ------------------------------------- I have a problem using a 'dtml-in' tag inside of a Zsql method and I'm wondering if anybody can help me I´m using a sequence in ORACLE (called 'seq') and I need to obtain the following value of that sequence before execute other Zsql methods. For that, I define a Zsql method (called sql_select_nextval) that returns the following value of the sequence and other Zsql method (called sql_2 ) that executes another actions. The problem is that when I execute the Zsql method 'sql_2' it seems to execute the sql_select_next_val method two times because at the next time that I execute 'sql_2' the value returned from sql_select_next_val is incremented in 2 in comparison with last value returned. I need it to be incremented in 1. the code of sql_select_nextval method is the following: SELECT seq.NEXTVAL val FROM DUAL the code of sql_2 method is the following: <dtml-in "sql_select_nextval"> insert into anytable (oid_anytable, name) values (<dtml-var val>, 'john') <dtml-var sql_delimiter> select * from anytable where oid_anytable = <dtml-var val> </dtml-in> The code used to create the sequence is the following: CREATE SEQUENCE seq START WITH 1 NOCYCLE NOCACHE; ---------------------------------------------------------------------------- -------------------------------------------- Note: if I put the dtml-in outside of the Zsql method it seems to work correctly... Alejandro Pancani alejandrop1(a)topgroup.com.ar

3 3

Zope and Windows DB's = NOT! ?
by Mark Pratt 14 Nov '00

14 Nov '00

hi, is anybody successfully using a Windows DB such as MS SQL server 7 with Zope? it seems that the ODBC adaptor is ancient and very error prone .... so can i conclude that Zope and DB integration under windows is not an option? regards, mark -------------------------------------------------------------- mark pratt (managing director) mark(a)beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

5 7

Re: Advanced search in ZCatalog PartII
by michael Kobald 14 Nov '00

14 Nov '00

Hi, First Part: Create Index First, create the index "name of mymethod" in the Catalog. ZCatalog can only index objects he knows of ! eg. use "find item to ZCatalog" tab, use the index method or use CatalogAware as base Class for ZClass. Additionally you have to reindex your object if its content changes (via DTML-Call....reindex.) What does the ZCatalog for you ? He takes your object, applies all the indexes that are possible, and reads his data. (so we´re back, you have to return something from your method). This data is store in the Catalog itself, and not in the object. Second Part: OR Query: mmmh, did i get you right ? I Think it´s this way: 1. Case: looking for a or b or c -> type 'a b c' as query string 2. Case: looking for a and b and c -> type 'a AND b AND c' as query string 3. Case: looking for a and b or c -> type 'a AND b OR c' as query string 4. Case: looking for 'a b c' -> type '"a b c"' as query string OR Did you mean somthing like this ? return self.Catalog( {'meta_type' : ['pressemitteilung','volltext','kommentar','kurztext'], 'rubrik_id' : self.id, 'review' : 0 } ) Regards Michael Kobald

1 0

Re: [Fwd: [Zope] Re: Advanced search in ZCatalog (Micha)]
by daniel dias 14 Nov '00

14 Nov '00

Hi, Ok, I could achieve something with this approach. But it's not clear for me how to set the ZCatalog to create an index from the result of an external method. Can you please explain how to achieve this? Also, the ZCatalog queries use an "and" chain for each token provided (eg. if a query is requested for "a b c" it will be interpreted as "a" and "b" and "c"), and I'd like to implement an "or" chain in the queries. Thanks for the help, Daniel --- Maik Röder <roeder(a)berg.net> wrote: > Hi Daniel ! > > daniel dias wrote: > > > > you've a copy of this python method to send me? > > thanks maik! > > Look at what Michael Kobald wrote: > > Regards, > > Maik > > michael Kobald wrote: > > > > Hi, > > I played with ZCatalog and ZClasses a time ago. > > Due to the fact that ZCatalog can Index all > Objects - You Can Index a > > Method, .....!!! > > This Methods can be External-, Phython-, or > DTML-Methods. > > But they have to return something to the catalog > (DTML-RETURN Tag). > > You can give this method a name like > "PrincipiaSearchSource" or what the > > hell you think of. > > > > In my case I index about 10 different ZClass, 100 > Instances of them, with a > > PythonMethod called text_inhalt (text_contents) > > Param: self > > Code > > return string.join((self.id, self.inhalt), '; ') > > > > Or in an subclass > > return string.join((self.id, self.teaser, > self.gericht, self.keys, self.art, > > self.norm, self.parteien), '; ') > > > > Be warned you can use a DTML Method and return > something with the > > dtml-return tag, but this is not working very well > within a ZCLass, !!! > > ?????? > > > > P.S.: > > If you want to call a resultObject (e.g. a ZClass) > directly through > > Zope/DTML/Python use the PyMethod "fetchObj" much > cooler than only via > > catalog.getpath (which is link /hfg/kkjk/) > > > > to do somthing like this: > > > > <dtml-in mein> ****Result from a canned search > > > > <dtml-call > > > "REQUEST.set('meineURL',fetchObj(_,Catalog.getpath(_.int(_['sequence-item']) > > )))">****convert /parent/child to an real object > parent.child > > > > <dtml-var meineURL> *** points to a ZClass > [Base:Renderable] calling the > > Object/Class directly, which renders itself > > > > </dtml-in> > > > > use something like this: > > > > Python Method: fetchObj > > > > Param: _,fetchStr, attr=None > > > > obj = _ > > for p in string.split(fetchStr, '/'): > > obj = obj[p] > > if attr is None: > > return obj > > else: > > return render(_.getattr(obj, attr)) > > > > Greetings from Heidelberg > > > > Michael Kobald > > > > _______________________________________________ > > 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 ) ________________________________________________________________________ Do You Yahoo!? Crie o seu e-mail grátis do Yahoo! Mail com 6 Megabytes livres! http://mail.yahoo.com.br

2 1

Website search
by Stephan Goeldi 14 Nov '00

14 Nov '00

All the docs I found about searching are for searching inside the manage interface or for dtml-code only etc. I am just looking for a simple description, of how to include a simple search interface on my website (not in the manage interface). The available descriptions of ZCatalog are so complicated and programmer-oriented that I am not sure, if it is really the thing I need. So what's the simplest way to do a search on a website? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

4 4

why DTML confusing
by Spicklemire, Jerry 14 Nov '00

14 Nov '00

Irene says: > I get so frustrated with DTML, I want to scream. > Please don't tell me to buy the Zope book, > DTML should be more intuitive. > DTML maybe the heart of Zope, > but it's also it's achilles heel. You're right about the confusion, frustration, nor are you alone. Still, DTML isn't the heart of Zope, it's more like the fascia. DTML was intended to make the task of delivering dynamic content wrapped up in HTML-ish Templates easier. It evolved, and took on a broader scope that made it enticing for lot's of "other stuff". Like most evolution, there are obvious benefits, and some unfavorable outcomes. The most glaring problems show up when you start trying to do things that seem to be just a step or two more sophisticated than simple examples that "just work". There's good news. Python Methods, or whatever we end up calling them, make actually implementing such things as easy as Py(thon). For some folks, it may look like the bad news is, "Now I have to learn Python". In perspective, learning Python is way better than wading through the Zope API via DTML. Way way better. So, the moral is, keep the DTML as simple as it can be. For anything else, reach for another tool. Zope has bunches of them. BTW, the <dtml-if "_['sequence-item'}"> stuff is the tip of the DTML Complexity Iceberg. The sooner you get comfortable with Python Methods, ZClasses, etc., the happier you'll be. One last point. Python Methods (a.k.a. Restricted, Internal, or some other as yet unheard of alternative, which we are all anxiously awaiting) is an add-on at this point. Target date for inclusion as part of the standard "Core Zope" is Zope v.2.3. For now, see: http://www.zope.org/Members/4am/PythonMethod Later, Jerry S.

2 1

Deleted product breaks SQL_Method Advanced tab - How to fix?
by Brad Clements 14 Nov '00

14 Nov '00

Zope 2.2.2 binary on Linux (also shows up on Windows version) I'm looking for suggestions on how to fix this, I can't access the advanced tab of any of my SQL_Methods. I had played with some products, deleted them from the file system and removed them from the products list in Zope (is order important here?) Now when I choose Advanced on any SQL Method, I get this: ImportError Sorry, a Zope error occurred. Traceback (innermost last): File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/bkc/door2door/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: SQL_GetOrgList) File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/bkc/door2door/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_advancedForm) File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_advancedForm) File /home/bkc/door2door/lib/python/App/special_dtml.py, line 120, in __call__ (Object: manage_advancedForm) (Info: /home/bkc/door2door/lib/python/Shared/DC/ZRDB/advanced.dtml) File /home/bkc/door2door/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: manage_advancedForm) File /home/bkc/door2door/lib/python/Shared/DC/ZRDB/DA.py, line 508, in manage_product_zclass_info (Object: SQL_GetOrgList) File /home/bkc/door2door/lib/python/ZODB/Connection.py, line 447, in setstate ImportError: No module named ZamlBase And this appears from the python process 2000-11-14T14:42:42 ERROR(200) ZODB Couldn't load state for '\000\000\000\000\000\000\036\031' Traceback (innermost last): File /home/bkc/door2door/lib/python/ZODB/Connection.py, line 447, in setstate ImportError: No module named ZamlBase How can I remove this object from the zodb? How do I find it? Any idea why SQL_Method even cares about this? Thanks for any suggestions 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

2 1

RE: [Zope] Zope and Windows DB's = NOT! ?
by Farrell, Troy 14 Nov '00

14 Nov '00

I've been using ZODBCDA 3.1.0b3 for 3 months on MS Acccess with no problems. Zope 2.2.2 Access 97 SR2 NT 4 SP6a 100MHz P5 32MB Ram Troy

1 0

Re: [Fwd: [Zope] Re: Advanced search in ZCatalog (Micha)]
by daniel dias 14 Nov '00

14 Nov '00

Hi, Ok, I could achieve something with this approach. But it's not clear for me how to set the ZCatalog to create an index from the result of an external method. Can you please explain how to achieve this? Also, the ZCatalog queries use an "and" chain for each token provided (eg. if a query is requested for "a b c" it will be interpreted as "a" and "b" and "c"), and I'd like to implement an "or" chain in the queries. Thanks for the help, Daniel --- Maik Röder <roeder(a)berg.net> wrote: > Hi Daniel ! > > daniel dias wrote: > > > > you've a copy of this python method to send me? > > thanks maik! > > Look at what Michael Kobald wrote: > > Regards, > > Maik > > michael Kobald wrote: > > > > Hi, > > I played with ZCatalog and ZClasses a time ago. > > Due to the fact that ZCatalog can Index all > Objects - You Can Index a > > Method, .....!!! > > This Methods can be External-, Phython-, or > DTML-Methods. > > But they have to return something to the catalog > (DTML-RETURN Tag). > > You can give this method a name like > "PrincipiaSearchSource" or what the > > hell you think of. > > > > In my case I index about 10 different ZClass, 100 > Instances of them, with a > > PythonMethod called text_inhalt (text_contents) > > Param: self > > Code > > return string.join((self.id, self.inhalt), '; ') > > > > Or in an subclass > > return string.join((self.id, self.teaser, > self.gericht, self.keys, self.art, > > self.norm, self.parteien), '; ') > > > > Be warned you can use a DTML Method and return > something with the > > dtml-return tag, but this is not working very well > within a ZCLass, !!! > > ?????? > > > > P.S.: > > If you want to call a resultObject (e.g. a ZClass) > directly through > > Zope/DTML/Python use the PyMethod "fetchObj" much > cooler than only via > > catalog.getpath (which is link /hfg/kkjk/) > > > > to do somthing like this: > > > > <dtml-in mein> ****Result from a canned search > > > > <dtml-call > > > "REQUEST.set('meineURL',fetchObj(_,Catalog.getpath(_.int(_['sequence-item']) > > )))">****convert /parent/child to an real object > parent.child > > > > <dtml-var meineURL> *** points to a ZClass > [Base:Renderable] calling the > > Object/Class directly, which renders itself > > > > </dtml-in> > > > > use something like this: > > > > Python Method: fetchObj > > > > Param: _,fetchStr, attr=None > > > > obj = _ > > for p in string.split(fetchStr, '/'): > > obj = obj[p] > > if attr is None: > > return obj > > else: > > return render(_.getattr(obj, attr)) > > > > Greetings from Heidelberg > > > > Michael Kobald > > > > _______________________________________________ > > 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 ) ________________________________________________________________________ Do You Yahoo!? Crie o seu e-mail grátis do Yahoo! Mail com 6 Megabytes livres! http://mail.yahoo.com.br

1 0