- Zope-Dev - Zope lists

Re: [Zope-dev] SQLSession help needed!
by Jeff Rush 21 Nov '99

21 Nov '99

On Sun, 21 Nov 1999 16:08:58 +1100, Anthony Baxter wrote: >>>> Clayton Miller wrote >> Here is the error I am getting: >> >> Temporarily Unavailable >> The resource you requested is temporarily unavailable - >> >> please try again later. >> >> (116) unable to connect, fd=5 > >This isn't an SQLSession error. I've never seen this at all. It comes from the pcgi-wrapper program. It means he could not establish a connection to ZServer, and contains no further information. The fd=5 part is just the handle of the sock that pcgi-wrapper was using and is of no use to you. >> This is the type of error I have received plenty of times when the SQL >> statement was incorrect somehow. Just how do you debug this error? I >> looked at standard_error_html and I do not see this error text. How do >> you find out which object /line is causing the problem? Interesting... you see this on any SQL statement error? Re how to debug, the only way is to consult any logfiles and/or core files Zope produces. >It sounds like the PostgreSQL DA is a little bad in it's handling of >errors - the Oracle, Sybase and Gadfly DAs all produce a decent error >message. Perhaps, but Zope should not crash/become incommunicative when a DA goes wierd. __________________________________________________ Jeff Rush <jrush(a)taupro.com> Tau Productions Inc. Linux/Python/Zope Consultant http://www.taupro.com

1 0

Re: [Zope-dev] SQLSession help needed!
by Anthony Baxter 21 Nov '99

21 Nov '99

>>> Clayton Miller wrote > I have posted this message on the Zope maillist but I did not get a good > answer. So I decided maybe some real Geeks hang out here instead. I am > having trouble getting the SESSION.set(...) to work. > Here is the code I am using. > > <dtml-comment> > -----code starts here -------- > ZipCode = <dtml-var ZipCode> > Distance = <dtml-var Distance> > <dtml-var "SESSION.set('myZipCode', ZipCode)"> > <dtml-var "SESSION.set('myDistance', Distance)"> > <frameset cols="30%,70%"> > <frame src="<dtml-var Root>/Menu" name="Menu"> > <frame src="<dtml-var Root>/Main" name="Main"> > </frameset> > -----code ends here ------- > </dtml-comment> > > Here is the error I am getting: > ! > > Temporarily Unavailable > > The resource you requested is temporarily unavailable - > > please try again later. > > (116) unable to connect, fd=5 This isn't an SQLSession error. I've never seen this at all. Hm - I wonder if it's breaking the postgres adaptor in some way... Can you do a 'test' of the various SQL methods inside the SQLSession? Do they work? Can anyone who uses Postgres confirm whether or not strings in an insert can contain newlines? e.g.: will the following work? create table foobar ( ch varchar(200) ) insert into foobar ( ch ) values ( 'this is a long string' ) If not, it's possible that this is the problem. Gadfly has a similar issue. I have an idea on how to fix this, I'll whack it in the code and upload a new version shortly. > This is the type of error I have received plenty of times when the SQL > statement was incorrect somehow. Just how do you debug this error? I > looked at standard_error_html and I do not see this error text. How do > you find out which object /line is causing the problem? It sounds like the PostgreSQL DA is a little bad in it's handling of errors - the Oracle, Sybase and Gadfly DAs all produce a decent error message. Anthony -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

Re: [Zope-dev] A few modifications to the tree tag
by Anthony Baxter 21 Nov '99

21 Nov '99

>>> Hannu Krosing wrote > BTW, Is SQLSession usable on Gadfly (and is gadfly thread-safe) ? > Is gadfly a good place for storing sessions ? In _theory_, yes. In practice, gadfly's parser barfs on strings with embedded newlines. Since by default Sessions store the data as base64, this breaks if the objects encode to more than a line. I plan to allow a choice of encoding as base64 or using zopes var:type format - I'd hoped to get this into 0.2, but it's not working yet, so it will be in 0.3. > > The second point, would a patch to allow a 'prefix' for the tree-[ecs] > > options be a useful thing? That way you can have multiple trees on the > > same page. So if prefix=foobar, the cookies/form values would be of the > > type 'foobartree-e' &c. > Thats exactly what I have been thinking. cool - I'll send a patch tomorrow. > > Third point: is it worth allowing the tree icons +/- to be overridden? > > I thought I remembered someone had done this, but I can't remember it > > for sure, and I can't find it in my zope archives... MartijnP's response (he did it, but can't find it now) suggests that I need to implement it myself. Since I need it for a system that's going live in the next week or so, expect a patch in the not too distant future. :) -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

2 1

Keyword Indexes in ZCatalogs
by Alexandre Ratti 21 Nov '99

21 Nov '99

Hello, Could someone explain how to use Keyword Indexes in ZCatalogs? In a ZCatalog, we now have 3 index types: Text Index, Field Indexes and Keyword Indexes. Here is the information I have found so far about the Keyword type: "Keyword Indexes index a sequence of objects that act as 'keywords' for an object. A Keyword Index will return any objects that have one or more keywords specified in a search query." (source: Indexes tab of a Zcatalog) "Keyword Index: Subclasses all of the field index behavior, except that property values are treated as a sequence of keywords." (source: posting on a Zope list) Could someone provide an implementation example? Thanks. Alexandre

2 1

Re: [Zope-dev] SQLSession help needed!
by Clayton Miller 20 Nov '99

20 Nov '99

Bill: Thanks, but yes this page includes both the standard_header_html and standard_footer_html documents. I did forget to include this information in my source code listing, sorry :^(. Clayton. >From: Bill Anderson <bill.anderson(a)libc.org> >To: Clayton Miller <cmille9(a)hotmail.com> >CC: zope-dev(a)zope.org >Subject: Re: [Zope-dev] SQLSession help needed! >Date: Sat, 20 Nov 1999 13:52:07 -0700 > >Clayton Miller wrote: > > > > I have posted this message on the Zope maillist but I did not get a good > > answer. So I decided maybe some real Geeks hang out here instead. I am > > having trouble getting the SESSION.set(...) to work. > > Here is the code I am using. > > > > <dtml-comment> > > -----code starts here -------- > > ZipCode = <dtml-var ZipCode> > > Distance = <dtml-var Distance> > > <dtml-var "SESSION.set('myZipCode', ZipCode)"> > > <dtml-var "SESSION.set('myDistance', Distance)"> > > <frameset cols="30%,70%"> > > <frame src="<dtml-var Root>/Menu" name="Menu"> > > <frame src="<dtml-var Root>/Main" name="Main"> > > </frameset> > > -----code ends here ------- > > </dtml-comment> > ><suggestion type=stab-in-the-dark> >Does this page include <dtlm-var standard_html_header> ? >If not, this may be part of the problem. ></suggestion> > >-- >"They laughed at Columbus, they laughed at Fulton, they laughed at the >Wright brothers. But they also laughed at Bozo the Clown." -- Carl >Sagan ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

SQLSession help needed!
by Clayton Miller 20 Nov '99

20 Nov '99

I have posted this message on the Zope maillist but I did not get a good answer. So I decided maybe some real Geeks hang out here instead. I am having trouble getting the SESSION.set(...) to work. Here is the code I am using. <dtml-comment> -----code starts here -------- ZipCode = <dtml-var ZipCode> Distance = <dtml-var Distance> <dtml-var "SESSION.set('myZipCode', ZipCode)"> <dtml-var "SESSION.set('myDistance', Distance)"> <frameset cols="30%,70%"> <frame src="<dtml-var Root>/Menu" name="Menu"> <frame src="<dtml-var Root>/Main" name="Main"> </frameset> -----code ends here ------- </dtml-comment> Here is the error I am getting: ! Temporarily Unavailable The resource you requested is temporarily unavailable - please try again later. (116) unable to connect, fd=5 If I <dtml-comment> out the SESSSION.sets on down. I do see the values of Zipcode and Distance working correctly. I am connecting to a Postgresql database. Zope/Apache/Postgresql are all running on my Linux box. I have created the Sessions and Session_data tables as prescribed. I have included a <dtml-call Session> in my standard_header_html file. Just to see if the code was working at all, I modified the SQLSession.py:__init__ routine to put the sessionName into the Session_data table. I can see this information just fine using a <dtml-var "REQUEST['SESSION']"> command. This shows one key called session (this is the name I gave it in __init__) and the value of sessionName (the value I assigned). This is the type of error I have received plenty of times when the SQL statement was incorrect somehow. Just how do you debug this error? I looked at standard_error_html and I do not see this error text. How do you find out which object /line is causing the problem? Thank you for the help. Clayton.

2 1

Re: [Zope] Rules Based Applications
by Martijn Faassen 20 Nov '99

20 Nov '99

Jerry.Spicklemire(a)IFLYATA.COM wrote: > Hi Zope Fans, > > I've been searching the Web for references to > Rules Based Programming with Python, and Zope. > Not much so far. > > Anybody else out there interested in this topic? I am. Interesting direction you're looking in. Looking at logic programming might be a good idea; I recall a thread on comp.lang.python a while back on Python/prolog interfacing; that may contain some good references. There might also be something in the (new) Vaults of Parnassus: http://www.vex.net/~x/parnassus/ Hm, nothing obvious in the vaults besides the strout.net reference. I shall do some thinking on this. Keep us posted. I've moved this thread to zope-dev, by the way, or we'll have Paul onto us. :) Regards, Martijn

1 0

creating trees with squishdot
by geoff nordli 19 Nov '99

19 Nov '99

Hopefully someone can give me a hand. I would like to create a tree structure based on subjects in a squishdot site. I have some code that looks like this:     which creates a tree based on articles (only the article id), and the comments--not what I am looking for. <dtml-tree branches_expr="KnowIT.subjects_list()"> <dtml-var id> </dtml-tree> this will create a tree with the same number of subjects that I have, but all named "KnowIT". I guess it is a little bit closer, but not close enough. Can someone help me fill in the blanks. thanks, geoff nordli

1 0

XMLDocument patch
by Gabor Melis 19 Nov '99

19 Nov '99

Hi I made a patch to remedy two of the present bugs: 1) Escape <, & and > characters in toxml() 2) abort the transaction if parsing fails 1) uses the escape method from xml-sigs xml.utils, but this dependency can be removed. (not done now) I was wondering about encodings the other day (subject: XMLDocument shortcomings). If you have comments on how to introduce intelligent encoding/decoding please share it with me. Gabor

2 1

Re: [Zope-dev] Writing custom folderish products
by Martijn Faassen 19 Nov '99

19 Nov '99

s341625(a)student.uq.edu.au wrote: > On 11/19/99, 9:32:08 PM, Martijn Faassen <faassen(a)vet.uu.nl> wrote > regarding Re: [Zope-dev] Writing custom folderish products: > [VisualZope explanation snipped] Hm, I'm not sure I get that yet. I have a difficult time understanding VisualZope, I'm afraid...seeing a working demo would *really* help in my understanding of it; I tried to install it again today but ended up with javascript errors. Once I really understand what it's for and what it can do, I'll be far more able to understand your explanations on how it works. >From what I understand it does sound way cool, though. :) [ZClass based approach:] > * Create a Zclass based on a folder and objectManager (this is > important - an objectManager is always required for some reason) And 'folder' is in fact not necessary; objectManager is enough. > * In the Methods area of this class create another zclass (say, > "MyObject" > * Then, in the SubObjects area pick MyObject as an object that can be > added within this folder > > Thats it! The user will only see MyObject in the "Add Object" > dropdown! I know this -- I've done this myself. But what I'm developing is a Python-only product; no ZClasses involved. I have a set of field classes (all deriving from a common base class; these are Zope products) and I want to make a folderish class to which they can be added. They shouldn't be addable anywhere else (in normal folders, for instance). Going through the source I found some stuff involving all_meta_types, meta_types and lots of magic code (to me) that seems to make products addable to folders. Zope's sources could use some documenting though.. I am assuming there is a clean mechanism to say: 'these products can only be added to this ObjectManagerish product, and nowhere else'. Could a real Zope Guru speak up now? On the bright side, all this Zope source digging does mean I know my way around significant parts of it now; don't understand much of it yet, but all helps on my road to the Zen, I suppose. :) Regards, Martijn

1 0