August 2003 - Zope - Zope lists

authentication via form
by BORGULYA Gergely 10 Aug '03

10 Aug '03

Hi, I'm developing a small site in Zope with a simple, own management interface (where the contets of Documents can be easily changed using forms). The last few days' change in the ZopeBook on www.zope.org seems to be very useful, thanks for the authors! Although I could not find out, how to authenticate users not by calling a zope object that needs special permissions to access, but using a form with a login/passwd box and passing the arguments to some kind of functions. Can REQUEST.['AUTHENTICATED_USER'] be modified somehow? I could not find any function that I suppose to do this. Gergely Borgulya

2 1

Re: squishdot
by Lee Harr 10 Aug '03

10 Aug '03

>I need help to install Squishdot. >In my PC I have installed Zope 2.6.2b5 and I didn't >know in what directory put the zip that gets off the >page zope.org. neither how to make to use it (Is it >necessary to configure something?) > It depends on the product zipfile.... The Squishdot folder needs to end up in ${ZOPE_DIR}/lib/python/Products/ Sometimes the zips are from the ${ZOPE_DIR} and sometimes they are from the ${ZOPE_PRODUCTS_DIR} Your best bet may be to unpack it in an empty folder and see what you get. Look for the Squishdot folder and move that in to place. There is also probably a README file in the zip that gives instructions on how to install it. _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

1 0

TextIndexNG
by Juan Manuel Ruiz Garcia 10 Aug '03

10 Aug '03

I'm trying to install TextIndexNG2.0 in my Zope. I have unzipped the distribution pack at the Products directory, as usual. Wiki-Documentation tells that I have to "grab the the prebuild TextIndexNGExtension? binaries for Windows from Sourceforge"... Well I have them, but where I should put them to make it work? Thanks in advance,

2 2

zsql-Methods: how to make a dynamic where-clause?
by Elena Schulz 09 Aug '03

09 Aug '03

Hi, is there any convenient way, to have a dynamic where-clause in zsql-Methods? All my effords had severe limitation up to now: 1. <dtml-sqltest .. needs a fixed column=.... expression 2. WHERE <dtml-var ...> with the whole clause in the var doesn't work because of quoting problems. ... So it seems that there is only very limited scope with <sql-group and explicit column=myExplicitColumnName constructs or am I missing something? A completely dynamic query with python script would be also a good alternative but how to do that? -- thanks for any input, Elena

2 2

can't pack large Data.fs (2.5GB)
by Marcus Schopen 09 Aug '03

09 Aug '03

Hi, can't pack a 2.5GB big Data.fs through the ZMI: ---------- Zope Error Zope has encountered an error while publishing this resource. Error Type: OverflowError Error Value: integer addition ---------- System: Debian woody with ext3 ---------- (Zope 2.6.2 (CVS 20030518 source release, python 2.1, linux2), python 2.1.3, linux2) Python Version 2.1.3 (#1, Sep 7 2002, 15:29:56) [GCC 2.95.4 20011002 (Debian prerelease)] System Platform ---------- If it was a LFS problem the zope wouldn't run. And I think the woody's python (Version: 2.1.3-3.2) is built with LFS support. Any ideas? Cheers, M.

1 1

anyone using plone in japan?
by David Bear 08 Aug '03

08 Aug '03

I'm wondering if there are any plone users developing sites in japanese. I need to understand some of the issues of internationalizing with python/zope/cmd/plone -- and how other tools like webdav work with CJK character sets. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"

3 2

Re: [Zope] loading zope within python interpreter
by Michael Long 08 Aug '03

08 Aug '03

Thanks for the reply. I am working with zope 2.7 so if anyone knows of any *gotcha's* I would appreciate it. With this and the link Frode replied with and google I will now continue my journey into the magical world of Zope. Cheers, Mike > IIRC things have changed somehow for zope 2.7, but for zope <= 2.6 you > can do this: > > pw@kermit Zope-2.6.1-src $ export PYTHONPATH=lib/python/ > pw@kermit Zope-2.6.1-src $ python > Python 2.2.3 (#1, Jul 22 2003, 12:28:47) > [GCC 3.2.3 20030422 (Gentoo Linux 1.4 3.2.3-r1, propolice)] on linux2 > Type "help", "copyright", "credits" or "license" for more information. > >>> import Zope > >>> app = Zope.app() # this takes a few seconds > >>> app.objectIds() > ['acl_users', 'Control_Panel', 'standard_html_header', 'standard_html_footer', 'standard_error_message', 'index_html', 'temp_folder', 'browser_id_manager', 'session_data_manager', 'Examples', 'error_log', 'standard_template.pt'] > > -- > > Paul Winkler > http://www.slinkp.com > Look! Up in the sky! It's THE TENSILE AARDVARK! > (random hero from isometric.spaceninja.com) > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > >

2 1

RE: [Zope] SQL Queries, DTML Methods and XML-RPC
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 08 Aug '03

08 Aug '03

Ah, turns out Python Scripts also behave like methods! Never mind :) J.F. -----Original Message----- From: Jean-Francois.Doyon(a)CCRS.NRCan.gc.ca [mailto:Jean-Francois.Doyon@CCRS.NRCan.gc.ca] Sent: Friday, August 08, 2003 4:32 PM To: zope(a)zope.org Subject: [Zope] SQL Queries, DTML Methods and XML-RPC Hello, After some research, I've still not come up with any great solution to this problem (Though I did see a few things on the web, archives, etc ...) I would like to have methods callable through XML-RPC that return the result of SQL queries (Z SQL Methods). So far, the best luck I've had is by using a DTML Method. The big problem is that DTML Method doesn't take positional parameters ... (In hind sight, this is probably is shortfall of DTML Methods ... if they're really "methods", then they should take parameters through aparameter list, much like Python Scripts ... no? ). Anybody know a way around this? One other option I have thought of so far: Since DTML Methods are methods of their folders, I could do the same through a product: create a fodlerish type and extend it with my own methods, which will then be available through XML-RPC. This is more painful to create and manage, not only for the obvious reasons, but because I may have many methods I wants to create for XML-RPC access, and constantly creating new folderish types for that pupose isn't very elegant or sustainable. Also did I not hear there' sissue with calling SQL Methods from product code ? I'll look into that. Does anybody have any better way to do this? Any suggestions would be much appreciated! Thanks, Jean-François Doyon Internet Service Development and Systems Support GeoAccess Division Canadian Center for Remote Sensing Natural Resources Canada http://atlas.gc.ca Phone: (613) 992-4902 Fax: (613) 947-2410 _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

1 0

Truncation Reading from ODBC
by Jerry Westrick 08 Aug '03

08 Aug '03

Hello Zopistas: I'm trying to read (and later probably write) large strings to a postgress database. I'm using the egenix ODBC adapter, and the unix ODBC postgress driver. When I read a column with 20,000+ characters I only get the first 8194 characters. Is this: 1) a Zope restriction? 2) a UnixOdbc restriction? 3) a egenix ODBC restriction? 4) an ODBC protocol restiction? Thanks for any of the above answers.... Jerry Westrick

4 5

parameter transfer to a zsql-method (lists, dictionaries etc.)
by Elena Schulz 08 Aug '03

08 Aug '03

Hi, I have problems with the parameter transfer to a zsql-method: With the Test - Tab of the ZMI the following ZSQL-method works fine without passing any parameters (i.e. with the default values) But if I call it with "return db.sql.device_list()", with "db.sql.device_list(['col1','col2'])" or with "db.sql.device_list(columns=['col1','col2'])" from a script I get the given errors. Can anybody enlight my understandig of how to pass parameters (e.g. lists, dictionaries) to zsql-methods especially so that they will work in an dtml-in construct? That would be very helpfull. --Thanks, Elena my ZSQL-Method: <params>columns:list:string=* where:string="" sort_col:string="" sort_reverse:int=0</params> SELECT <dtml-in columns prefix=column> <dtml-var column_item fmt=sql-quote><dtml-unless column_end>, </dtml-unless> </dtml-in> FROM device_list the error details: Error Type: InError Error Value: Strings are not allowed as input to the in tag. Error error_tb: Traceback (innermost last): * Module ZPublisher.Publish, line 98, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Shared.DC.Scripts.Bindings, line 252, in __call__ * Module Shared.DC.Scripts.Bindings, line 283, in _bindAndExec * Module Products.PythonScripts.PythonScript, line 315, in _exec * Module Script (Python), line 9, in test <PythonScript at /tomaxx/db/s/test> Line 9 * Module Shared.DC.ZRDB.DA, line 415, in __call__ * Module DocumentTemplate.DT_String, line 474, in __call__ * Module DocumentTemplate.DT_In, line 636, in renderwob InError: Strings are not allowed as input to the in tag.

2 1