January 2001 - Zope-Dev

Easy SQL question
by Keith.Larson＠Spatial.Com 08 Jan '01

08 Jan '01

Hello , I am trying to pull text from a Mysql DB into a page inside zope. I have the ZMYSQL connection setup and tested . for example : select renderText From Phrases where phrase_id = 3 and lang =1 I have also gotten the ZSQL method tested and working example : Arguments phrase_id renderText Query template select renderText from Phrases <dtml-sqlgroup where> <dtml-if expr="phrase_id"> <dtml-sqltest name="phrase_id" type="int" > </dtml-if> </dtml-sqlgroup> change and test enter 3 for phrase id and I get the correct info SQL used: select renderText from Phrases where phrase_id = 3 Now for the duh section. All of the above works fine with a submit button and entering info , I would like to pull the info into a Zope HTML page. I believe that this is close <dtml-call "REQUEST.set('phrase_id', foo)"> <dtml-in expr="langtest()"> <dtml-var expr="_['sequence-item'].renderText"> </dtml-in> but is foo supposed to be my var of whatever I want passed ? how do I pass the variable for phrase ID ( via a variable and changed per request ) to the language test and display the results so the user never knows . I think I am close just missing the obvious I think anyhelp ?

2 1

ZCatalog reindex_object
by Chris Withers 08 Jan '01

08 Jan '01

Michael Bernstein wrote: > > reindex_object - should be called when an object is edited Hmmm... didn't see this method listed in the interfaces wiki. Where did you find it? I just inserted a call to catalog_object which did the job but I wonder what the difference between index_object abd reindex_object and catalog_object is? cheers, Chris

7 25

Re: [Zope-dev] Re: Spitter.c Hack
by Tres Seaver 08 Jan '01

08 Jan '01

> From: "Jason Spisak" <444(a)hiretechs.com> wrote: > > Zopists, > > I finally got Splitter.c to let me index numbers and 'C++' in a TextIndex. > I have about 50,000 objects in that index, and search performance is nearly > instantaneous still. I am running on a big machine though. If anyone > wants those changes there's really easy. Just mail me directly, since it's > a long file to post. Can you post a patch, or upload it to your Zope.org member folder and post the link? cvs -q diff -u lib/python/SearchIndex/Splitter.c would do it, if you were working in a CVS sandbox for Zope. Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

2 1

filename extension
by Olaf Zanger 08 Jan '01

08 Jan '01

hi there, some information on zope.org says that in the early future ftp access should be possible not only to dtml-methods, -documents but also to Zsql-methods. to be future proof (and windows software proof) we'd like to have .xxx extensions for all our methods (fac_browse_method.sql that lovely windows understands what programm to start [textpad for sql ...]) unfortuanetly if called like <dtml-in expr="fac_browse_method.sql(id=10)"> zope gernerates an error. if there is a solution: how? or if not: does anything needs to be changed in the file handling of zope thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com

1 0

Zope from CVS for Windows
by Steve Alexander 08 Jan '01

08 Jan '01

Is anyone regularly building Zope from CVS for Windows? I want to try something out on a Zope 2.3 build on windows, but I don't have easy access to windows development tools. If you can help, please get in touch. -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net

3 3

ZCatalog Docs
by Chris Withers 08 Jan '01

08 Jan '01

Where is/are the most accurate and up-to-date documentation source(s) for ZCatalog in terms of search syntax and the different indexing types? cheers, Chris

1 0

Documentation
by Chris Withers 08 Jan '01

08 Jan '01

Dieter Maurer wrote: > > > > You can control for an explicit acquiring object that some > > > attributes are acquired implicitly > > > > Ooo... cool :-) > > > > Where can I find out about it? > Guess! ... in the Acquisition documentation. > > Each Zope installation has one (though on a place where > one would probably not look for it): I have to be honest and say I've never found the online help system docs very user friendly. They're difficult to navigate and the presentation isn't terribly readable. Thanks for the pointer though :-) cheers, Chris

1 0

Re: [Zope-dev] MySQL with LAST_INSERT_ID()
by Arno Gross 08 Jan '01

08 Jan '01

Dieters assumption was right. LAST_INSERTED_ID() returns a numeric value and that seems to be the problem. So if I change the statement as this: SELECT CONV(LAST_INSERT_ID(),10,10) it works (CONV returns a string!) P.S. Soren, maybe you can update your HowTo with a short note. Another possibilty instead of using LAST_INSERT_ID can be using MAX(). That should work too. Thanks Arno On Sat, 06 Jan 2001, Dieter Maurer wrote: > Arno Gross writes: > > SELECT LAST_INSERT_ID() > > > > This method works with Zope 2.2.4 under Linux and MySQL 3.22.32 > > but I got an error with Zope 2.2.2 under NT 4.0 and MySQL 3.22.29 > > Error, exceptions.KeyError: unhandled > Sieht aus, als könnte der MySQL Anschluss den > Rückgabewert von "LAST_INSERT_ID" nicht in einen Python > Datentyp wandeln, würde deshalb gerne eine "unhandled" > Funktion aus einen Dictionary auslesen, die leider > nicht drin ist. > > Sieht für mich nach einem Upgrade auf eine neuere Version > von MySQL bzw. seinen Python Anschluss aus. > > Allerdings müsste man zunächst den Traceback genau anschauen, > ob meine Vermutung auch wirklich zutrifft. > > > Dieter -------------------------------------------------------

1 0

__bobo_traverse__, new ZCatalog and ZClasses
by Steve Alexander 07 Jan '01

07 Jan '01

Zope 2.3, from cvs on 2000-12-24, patched with Chris P's latest ZCatalog stuff. I'm getting a bad interaction between ZClasses, ZCatalog and __bobo_traverse__. I have some ZClasses that are accessed via a container that implements __bobo_traverse__. The problem is that, although I can get to the ZClass instances by typing a URL into by browser, I get a security error when I try to get to them using restrictedTraverse. This causes a problem, as it means these instances cannot be catalogued in a ZCatalog, because ZCatalog now uses restrictedTraverse to get an object for indexing. The zope security validation gets stuck between not knowing for sure what the object's container is (according to comments from Traversable.py), and ZClasses not returning anything for __roles__. ZPatterns jargon paragraph: All this causes a problem if you want to use the ZPatterns idiom of ZClass DataSkins in a Specialist, catalogued using a ZCatalog. You can get around it by providing a __roles__ attribute using SkinScript. Is there some bug in the ZClasses __roles__ machinery? When does __roles__ get set on objects or classes anyway? I've found the description of what __roles__ are used for in the old Trinkets tutorial document. I think things have moved on a bit since then, though. Some relevant code snippets: Traversable.py t=get(object, '__bobo_traverse__', N) if t is not N: o=t(REQUEST, name) # Note we pass no container, because we have no # way of knowing what it is if (restricted and not securityManager.validate( object, None, name, o)): raise 'Unauthorized', name ZopeSecurityPolicy.py, line 123: # Try to get roles roles=getattr(value, '__roles__', _noroles) if roles is _noroles: ############################################################ # We have an object without roles. Presumabely, it's # some simple object, like a string or a list. -- Steve Alexander Software Engineer Cat-Box limited http://www.cat-box.net

1 1

(no subject)
by sfcsdckjkj＠csmdint.cesmad-bohemia.cz 07 Jan '01

07 Jan '01

GET YOUR OWN 100 MEG WEBSITE FOR ONLY $11.95 PER MONTH TODAY! STOP PAYING $19.95 or more TODAY for your web site, WHEN YOU CAN GET ONE FOR ONLY $11.95 PER MONTH! DO YOU ALREADY HAVE A WEBSITE? ALL YOU HAVE TO DO IS TRANSFER THE DOMAIN TO OUR SERVERS AND UPLOAD YOUR DATA AND YOU ARE READY TO GO! YOUR NEW WEB SPACE CAN BE CREATED INSTANTLY WITH JUST A SIMPLE PHONE CALL TO OUR OFFICE. YOU CAN CHANGE THE DESIGN OF YOUR SITE AS MUCH AS YOU WANT with no extra charge! UNLIMITED TRAFFIC -- no extra charge! FRONT PAGE EXTENSIONS are FULLY SUPPORTED. A SET UP FEE OF $40.00 APPLIES for FIRST TIME CUSTOMERS. ALL FEES PREPAID IN ADVANCE FOR THE YEAR PLUS A $40.00 SET UP CHARGE. FOR DETAILS CALL 1 888 248 0765 if you are outside the USA, please fax 240 337 8325 Webhosting International

1 0