February 2002 - Zope

Field type 'Date' in SQL request
by champier2002 05 Feb '02

05 Feb '02

Hi, The application has a link with an Oracle database. In the SQL table the field is defined like this : DATE_NAI_IND DATE with NULL When I try to use this field in a SQL request, for example : select DATE_NAI_IND, COD_ETU from VUE_TRAV_EXT_RVM_RES where TO_CHAR(DATE_NAI_IND,'dd/mm/yy')= "08/08/1997" or DATE_NAI_IND = "08/08/1997" I always receive the same error : Error, dco2.DatabaseError: (904, 'ORA-00904: Nom de colonne non valide') Thanks for your help

3 4

ZEO Issue
by Tim Owen 05 Feb '02

05 Feb '02

I am trying to learn how to administer my Zope/ZEO servers and need to figure out what errors to care about. Is the ZEO error below something I can/should resolve. It occurs frequently in the storage_events.log. Thoughts? ------ 2002-02-03T16:33:10 ERROR(200) ZEO Server error Traceback (innermost last): File /usr/local/zope/2.4.3/lib/python/ZEO/StorageServer.py, line 304, in message_input File /usr/local/zope/2.4.3/lib/python/ZODB/FileStorage.py, line 625, in modifiedInVersion (Object: /usr/local/zope/instance/var/Data.fs) KeyError: ^@^@^@^@^@^@h<9E> ___________________ Tim Owen Cell: 517.285.7071 Home: 989.224.4905 eFax: 425.940.5905

3 2

Python script error when tying to manage_addZSQLMethod
by Dean Grubb 05 Feb '02

05 Feb '02

Hi can someone tell me why I get this error Error Type: AttributeError Error Value: manage_addZSQLMethod from this python script item_id = "test_DTMLDocument" item_title = "Test DTML Document" item_body = """<dtml-var header>...<dtml-var footer>""" sqlName = "SQL_SELECT_ALL" sqlTitle = "View All" dbName = "dbConn" argumentString = "wid given surname" templateString = "SELECT * FROM clients" context.manage_addDTMLDocument(id=item_id,title=item_title,file=item_body) context.manage_addZSQLMethod(id=sqlName,title=sqlTitle, connection_idÛName,arguments=argumentString, template=templateString) what have I missed? I can get the manage_addDTMLDocument to work ok, but not the manage_addZSQLMethod. Dean

3 2

upgrading python
by Daniel Mahler 05 Feb '02

05 Feb '02

Hi, If I am using a source zope distribution and upgrade Python (2.1.1 -> 2.1.2 in this case) do I need to rerun the zope build script? thanks Daniel

2 1

versions question
by Steven Turoff 05 Feb '02

05 Feb '02

Greetings, Is it possible to use emacs when working with versions? If so, how do I open files? Thanks, Steve

2 1

Globals disappearing in extmethod?
by Joseph A Knapka 05 Feb '02

05 Feb '02

Hello, friends. It may be that I am misunderstanding something fundamental. I have code that does essentially the following: (1) Defines an external method for processing form data: # In module MyModule: def myExtMethod(req): global Request Request = req action = getFormData("action") #...process request... # And a utility function to help out - this is not an # external method, but is used by myExtMethod. def getFormData(key): return Request.get(key) (2) Defines a DTML document that just passes its input along to myExtMethod(): ... <dtml-var expr="myExtMethod(REQUEST)"> ... The point of this is that myExtMethod() is a wrapper around some old CGI code; I want the state of MyModule to be preserved between invocations of myExtMethod(), for performance reasons. I've been working with Zope for only a very short time (days), so I don't know if this is the "right" way to do this; I'd appreciate any advice on this matter. Now the problem. This code works most of the time. However, apparently at random, when executing a request, I will get an exception from getFormData(): "global name Request does not exist." This is very strange, because /every/ invocation of getFormData() is called from myExtMethod(), so there's simply no way the Request global can be unset, as far as I can see. Can anyone explain what is happening here? A pointer to relevant documentation would be sufficient; I've got "The Zope Book" and "The Book of Zope", neither of which have been much help about this particular issue (though quite helpful in many other ways). Many thanks, -- Joe "I should like to close this book by sticking out any part of my neck which is not yet exposed, and making a few predictions about how the problem of quantum gravity will in the end be solved." --- Physicist Lee Smolin, "Three Roads to Quantum Gravity"

3 11

DCOracle2 for Oracle 9i
by Drew Fisher 05 Feb '02

05 Feb '02

Hello, I'm having some difficulties building DCOracle2. The system I'm building it on is a Sun box running Solaris 2.8 (64-bit). The version of Oracle is 9i. Here is the output of the errors: gcc -shared build/temp.solaris-2.8-sun4u-2.2/dco2.o -L/export/oracle/lib -lclntsh -o build/lib.solaris-2.8-sun4u-2.2/dco2.so -Wl,-rpath,/export/oracle/lib ld: fatal: file /export/oracle/lib/libclntsh.so: wrong ELF class: ELFCLASS64 ld: fatal: file /export/oracle/lib: unknown file type ld: fatal: File processing errors. No output written to build/lib.solaris-2.8-sun4u-2.2/dco2.so collect2: ld returned 1 exit status error: command 'gcc' failed with exit status 1 I have a very limited amount of knowledge on the inner workings of Oracle so any help at all would be appriciated. Thanks! Drew Fisher

2 1

Re: [Zope] Tunneling URL hell.
by Blaise Laflamme 05 Feb '02

05 Feb '02

I have a setup with rewriting rules and ProxyPass rules to serve static images and serve different part of a site. I use a VirtualHostMonster and with Page Templates my URLs looks like: <a tal:attributes="href here/example.pt/absolute_url" src="example.pt">Example</a> <img tal:attributes="src here/static/images/example.gif/absolute_url" src="static/images/example.gif"> It works fine. Blaise Laflamme > Message: 2 > Date: Tue, 05 Feb 2002 17:01:48 +0000 > From: Chris Withers <chrisw(a)nipltd.com> > Organization: New Information Paradigms > To: Howard Hansen <howardh(a)halfmagic.com> > CC: zope(a)zope.org > Subject: Re: [Zope] Tunneling URL hell. > > Howard Hansen wrote: >> >> My sites are sitting behind apache with URL rewriting turned on, and my >> REQUEST paths include the /ab/wa prefix. I've seen that others have >> had >> this problem, but I haven't seen anyone with a solution. I'd prefer >> not to >> have to turn all of my links into absolute URLs. > > Why? > > <a href="&dtml.url-something;">Go here</a> > > ...works for me :-) > > cheers, > > Chris

1 0

Best Practice for Newsletter/eZine?
by Dan Shafer 05 Feb '02

05 Feb '02

I need to develop for several clients a relatively simple-minded eZine/newsletter kind of thing. What we want is for anyone who has an Editor role to be able to post material through an HTML form where they provide the headline, the teaser, and the main story (something like what SquishDot does for articles) and, when they push a button, the story gets posted to their site and an email is triggered to all subscribers containing the teaser and a link to the full article. It did occur to me that I might be able to modify SquishDot to accomplish this in some way but I wanted to see first if anyone knew of an existing Zope product that's designed to address this specific need. SquishDot doesn't have an easy way for people to subscribe and unsubscribe to the entire board if I recall correctly, and that would be important. -- Dan Shafer, Personal Creativity Trainer and Consultant Trained Hartman Value Profile Analyst http://www.danshafer.com/valueprofile.html

2 1

Tunneling URL hell.
by Howard Hansen 05 Feb '02

05 Feb '02

I'm starting to see lots of hits on my sites from friendly, neighborhood search engines. Lots more than I'd expect. Looking closely, I noticed that I've got tunnelling URL syndrome. The requests look like: /ab/wa/ab/wa/ab/wa/ab/wa/index_html I fear that this may go on forever! My sites are sitting behind apache with URL rewriting turned on, and my REQUEST paths include the /ab/wa prefix. I've seen that others have had this problem, but I haven't seen anyone with a solution. I'd prefer not to have to turn all of my links into absolute URLs. Here's another possiblity that I've considered: I could do a browser sniff and if it's a spider and has a more than one /ab/ in the path, I could insert a meta tag in the HTML head: <META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">, as per http://www.robotstxt.org/wc/exclusion.html#meta. Of course, this would require the spider to respect the meta tag. Has anyone figured out any other solutions to this apparent bug in the Virtual Host Monster? Thanks all! Howard Hansen http://howard.editthispage.com

2 1