February 1999 - Zope

Help needed on ZPyGreSQLDA and empty query result.
by Gilles.Lavaux 23 Feb '99

23 Feb '99

Hello All, I have a problem with the PostgreSQL module and empty query result: When a select query (named TestSearch bellow) return no tuple, the message is 'Error, exceptions.IndexError: tuple index out of range' In case of a Gadfly DB, the same query will return:'There was no data matching this select test query' My problem is that this query SQL method is use in a   etc... This cause a 'system unavailable' page to be rendered, instead of a ' no record something...' Do you know any workarround or DTML error trapping solution? Is it a bug inthe ZPyGreSQLDA module itself ? If yes it it inside the 'query' function? I actualy use an external method to filter the records, shall I also use a external method to do a 'try: except:' test on the TestSearch ? Thanks For any solution/help. Gilles gilles.lavaux(a)mail.esrin.esa.it

3 2

Tabula in Zope 1.10
by Kevin Dangoor 23 Feb '99

23 Feb '99

I read the early Tabula Manager's Guide doc that Paul sent the URL for (thanks, Paul!). It looks like a Really Useful Thing(tm). I know that the machinery is in the 1.10 pr1 release... will the final 1.10 release actually have the management screens and "normal" product interface for Z Tables? Also, something that wasn't clear to me from the Manager's Guide: can you update (as in add/delete records) from a Z Table through the web? The doc makes it appear that Z Tables are updated only by uploading data files. Thanks for working to get Tabula and Confera out to the public! It's amazing stuff! Kevin -- Kevin Dangoor kid(a)ans.net / 734-214-7349

1 0

SQL escaped text
by julian＠zereau.net 23 Feb '99

23 Feb '99

is there any way of doing what the #sqlvar tag does without it putting quotes? I want to be able to do "while value like '%%' " --- Julian Morrison Programmer (Zereau Ltd)

1 0

Bug with External Methods and default params?
by Stefan Franke 23 Feb '99

23 Feb '99

(First a little excuse: I've got an extreme lack of time right now, otherwise I would try to isolate the problem -- but maybe it's a bug already known) There seems to be a problem calling external methods with default parameters from DTML docs. I've got an external method (original signature): def pfadleiste(self, pfadleisten_info, cut_last_entry): "..." calling it via  is no problem at all, but if I change the signature to def pfadleiste(self, pfadleisten_info, cut_last_entry=1): calling the same page in an identical context gives one of these darned screwed-up "TypeError: read-only buffer, class" error that unluckily hide the original exception (a permanent pain when debugging -- if this changes with the new Zope version it would be a reason for me to upgrade even my existing system). Stefan

4 7

ZServer medusa import problems on win32 RESOLVED
by Brad Clements 23 Feb '99

23 Feb '99

Thanks for all the suggestions, here's the scoop. Problem: even with the correct path, start.py would fail on "from medusa import .." Resolution: WinZip won't extract 0 length files, so the __init__.py for ZServer and ZServer/medusa didn't get extracted. Although I had created a ZServer/__init__.py, I didn't for medusa. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com ICQ: 14856937

1 0

Python Extensions are easier than it seems
by Philip Aylesworth 23 Feb '99

23 Feb '99

Hi, Just wanted to let you know my experience with python extensions. I had been avoiding them because I had my hands full with learning Zope and DTML and SQL Methods. When I asked on the list about doing something that seemed very difficult Paul replied that a 10 line Python extension would do it. Well, yesterday I set out to do it. I have been reading about Python but had not used it yet. I looked at an example which gave me lots of clues and went at it. Within half an hour I had it working! 9 lines! What it does is it looks to see if a file exists (the name is stored in a database) in a given (NFS mounted) directory (in this case the path is also based on the first four characters of the filename). It returns an HTML link if the file exists or just the file name if it doesn't. Here is the code: import os def cadlink(file): server = 'http://netapp.regalint.com' url = '/web/so' + file[0:4] + '/' + file path = '/netapp/BBLM' + url if os.path.isfile(path): return '<A HREF=' + server + url + '>' + file + '</A>' else: return file I just call it as a function in DTML with  and it works! Very cool! Phil. ------------------------------------------------------------------- Philip Aylesworth Information Systems Manager phila(a)regalint.com PGP public key: http://www.regalint.com/PGPkeys/phila.html

1 0

Open Source of Confera
by Michel Pelletier 23 Feb '99

23 Feb '99

Greetings Zopeheads, After talking about it we have finally worked up an open source release of Confera. This is *unsupported*. For those of you who don't know, Confera is a Threaded Discussion Product for Zope. It is very cool and is the only open source product so far to show off the search mechanisms. We hope that you in the community will take up Confera and make it your own (and also support it ;). We have done a little brushing up to make it Zope'afied, and I have just confirmed that it *runs* with Zope 1.10.2, but from there your on your own. If there are bugs, please feel free to discuss them and fix them. You can get Confera at: http://www.zope.org/Download/Prereleases/Confera/Confera-1.2.0-nonbin.tgz Regards, -Michel

3 2

[Q]: Absolute URL in tree tag
by Michael Bernstein 23 Feb '99

23 Feb '99

Sorry for the newbie question, but how do you get the links in a tree to use absolute URL's? Here is the simplified code:  <A HREF=""></A>  tree-item-url returns a relative URL. how do you get this to use an absolute one? Thanks in advance, Michael Bernstein.

2 1

the UserDB sample application
by Piers Lauder 23 Feb '99

23 Feb '99

From: Paul Everitt <Paul(a)digicool.com> Date: Mon, 22 Feb 1999 08:55:39 -0500 ... Fortunately it is possible to use cookies to get around that. Take a look at the UserDB sample application for more details. (Note: we don't support the UserDB sample application, it is just an example.) > * Check the username/password pair against the unix > /etc/passwd database, and > on success log the user into Zope as that username. The UserDB sample stores and retrieves user information from a relational database. Thus, it provides an example of how to extend Zope to get user information from an external source. Where does one get hold of "UserDB"? I looked under "Contributed Software", but couldn't see anything obvious. Which brings me to a suggestion - a "Search" tab at the Zope site to search for documents/modules available at www.zope.org - reasonable? (Note: the eGroups search facility has never worked for me, it is either unavailable, or, as now, displays: Sorry, an error occured while searching. ((for "UserDB" of course :-)))

2 1

no module named medusa, ZServer working on Win32 for anyone?
by bkc＠MurkWorks.com 23 Feb '99

23 Feb '99

I know this has been hashed around in the mailing list before and I've looked at EVERY post about it. Unfortunately what has been said "appears" to be for unix, and although I've tried my best to get my start.py setup correctly, it's NO GO for me. I've checked my PYTHONPATH, even Forced it to use various directories, including "<base>\ZServer", etc. I've tried using the supplied python in interactive mode and typed in various commands, I just can't get it to grok the "from medusa import" statement. If anyone has a working start.py and start.bat for WIN32 port of ZServer, I'd like to see it. I had zope .9, then installed 1.10.0pr1, then ZServer 1.0a2 Here's bin directory partial list 12/16/98 03:02p 5,120 python.exe 12/07/98 07:12p 414,720 python15.dll Here's my start.bat "E:\Program Files\ZopeOne\bin\python.exe" "E:\Program Files\ZopeOne\ZServer\start.py" %1 %2 %3 %4 %5 %6 %7 %8 %9 --- Here's the top part of my start.py, parts stolen from my existing serve.py which seems to work ok. #!/usr/local/bin/python1.5.1 """Sample ZServer start script""" import sys, os # Have to fiddle the path for binary dist. to # ensure the bundled python libs are used. swhome=r'E:/Program Files/ZopeOne' sys.path.insert(1, '%s/lib/python' % swhome) sys.path.insert(2, '%s/lib/python1.5' % swhome) sys.path.insert(3, '%s/lib/python1.5/plat-win' % swhome) sys.path.insert(4, '%s' % swhome) print 'path is ' print sys.path # configuration variables # IP_ADDRESS='128.153.43.10' HOST='pit.murkworks.com' DNS_IP='128.153.43.1' HTTP_PORT=9673 FTP_PORT=8021 PCGI_PORT=88189 PID_FILE='Zope.pid' MODULE='Main' LOG_FILE='ZServer.log' from medusa import resolver,logger,http_server,asyncore --- Here's the output E:\PROGRA~1\ZopeOne>"start" E:\PROGRA~1\ZopeOne>"E:\Program Files\ZopeOne\bin\python.exe" "E:\Program Files\ ZopeOne\ZServer\start.py" path is ['E:\\Program Files\\ZopeOne\\ZServer', 'E:/Program Files/ZopeOne/lib/python', ' E:/Program Files/ZopeOne/lib/python1.5', 'E:/Program Files/ZopeOne/lib/python1.5 /plat-win', 'E:/Program Files/ZopeOne', 'E:\\Program Files\\ZopeOne\\lib\\python ', 'E:\\Program Files\\ZopeOne\\lib\\python1.5', 'E:\\Program Files\\ZopeOne\\li b\\python1.5\\plat-win', 'E:\\Program Files\\Python\\LLNLDistribution\\NUMERICAL \\LIB', 'E:\\Program Files\\Python\\LLNLDistribution\\NUMERICAL\\PYDS', 'E:\\Pro gram Files\\Python\\Pythonwin', 'E:\\Program Files\\Python\\win32', 'E:\\Program Files\\Python\\win32\\lib', 'E:\\Program Files\\Python', 'E:\\Program Files\\Py thon\\Lib\\plat-win', 'E:\\Program Files\\Python\\Lib', 'E:\\Program Files\\Pyth on\\DLLs', 'f:\\dislin\\python', '.\\DLLs', '.\\lib', '.\\lib\\plat-win', '.\\li b\\lib-tk', 'E:\\Program Files\\ZopeOne\\bin'] Traceback (innermost last): File "E:\Program Files\ZopeOne\ZServer\start.py", line 29, in ? from medusa import resolver,logger,http_server,asyncore ImportError: No module named medusa Note that ZServer is right there in the front of the list, so medusa should be found in that directory, it's not. Any suggestions? Thanks... Brad Clements MurkWorks, Inc. PO Box 610 Potsdam, NY 13676 315-268-1000 http://www.murkworks.com ils://ils.murkworks.com

1 0