- Zope - Zope lists

ZOracleDA Adapter
by Brian Brown 19 Apr '99

19 Apr '99

Greetings, All - I'm attempting to port the ZOracleDA adapter to HP-UX 10.20, and lo and behold, it works from the command line. (...using the test script provided in the DCOracle src directory.) When I try to use it with Zope, I get the following: ! Temporarily Unavailable The resource you requested is temporarily unavailable - please try again later. t[0] = 37 ......... Yes, it's PCGI and apache. I saw another post about a documented error within python that seems to be returning the t[0] = 37, and here is what is in the log file: pcgi-wrapper: unexpected out-of-bound data in stdin t[0] = 37 So, it would point to something priniting to STDOUT, and PCGI chokes on it. Does anyone know of a workaround? This is my first attempt to Deliver Zope based solutions to a client. I have flexibility to change if I have to, but I *really* want to use Zope. This site will be doing reporting from Oracle for HP Openview.... thanks! Brian

1 0

Re: [Zope] Creating Document with random num as ID?
by Kent Sin 19 Apr '99

19 Apr '99

Generating a serial unique ID is sometimes more suitable for human. I would like to suggest doing like this: make a zope product which can be called with a url and return the unique id. It will serialize all the request and make sure the serial number it issued is unique. This method will allow issuing serial id across the network. By modify it to check for duplicate after the generation of a random id, it can issue random serial id also. If we can make it listern on a different port than the web server, and provide a simple protocol to ensure the client receive the id, then it can work as a id server on the network. Rgs, Kent Sin

1 0

Bug? cancel button in Z Search Interface
by Martijn Faassen 19 Apr '99

19 Apr '99

Hi everybody, I've used the Z Search Interface product to generate (search) input and report pages for a Z SQL Method. The input form that is created works fine for entry, but when I use the 'cancel' button it appears as if the input is being validated to be the right type (string, float, int, etc) just like when I use 'submit'. This is odd, as 'cancel' shouldn't care about bogus values being entered at all. This makes things difficult in various cases, for example with SQL searches, but also with SQL insert statemens for which I've been using these interfaces. If you have want to enter a record, and decide against it and press 'cancel', it gives you errors because you aren't entering the required values. Is this a bug, or am I missing something? If it's a bug I'll go add it to the collector. Regards, Martijn

1 0

Objet : [Zope] RE: Dynamic SQL problem
by François-Régis CHALAOUX 19 Apr '99

19 Apr '99

Thanks Aaron, It is working perfectly now. Cool :) FR >>> Aaron Watters <arw(a)ifu.net> 19/04/99 15:21:32 >>> Dear François-Régis Chalaoux, You have a gadfly problem. There are too many layers of syntax here for my myopic eyes, however looking real hard at the following: insert into softdomain (idsoftware,iddomain) values( (select idsoftware from software where name = ), ) Gadfly only supports *literals* in "INSERT ... VALUES (...)" You cannot put a query inside the parens. Instead of insert into table (a,b) values ((select max(a) from table), 5) you can do this insert into table (a,b) select max(a) as a, 5 as b from table or even (Gadfly 1.0, not beta whatever) insert into table (a,b) select (select max(a) from table) as a, 5 as b from dual And you can always do a rewrite similar to the second one I think. And if "select * from dual" doesn't work upgrade. The "INSERT INTO...VALUES" is highly optimized using the assumption that no queries ever occur in the values... Regards, -- Aaron Watters http://www.chordate.com === stop procrastinating tomorrow. _______________________________________________ Zope maillist - Zope(a)zope.org http://www.zope.org/mailman/listinfo/zope (For developer-specific issues, use the companion list, zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

Q: Howto create a different tree element ?
by Gregor Hoffleit 19 Apr '99

19 Apr '99

I need a navigation element for tree-like structures, but with a different rendering (no collapsing/expanding, different font sizes for the various depths etc.). I could try and write that thing from scratch, but given that most of its interface is similar to the TreeDisplay code, I wonder what would be the zopisticated way to reuse the interface and as much code as possible. Perhaps a similar question is: given that TreeDisplay is a builtin DTML tag, should I try to augment the TreeDisplay code, or is there a reasonable way to build user-defined DTML tags, or is it more reasonable to employ traditional methods (e.g. var-exprs) for this ? Gregor

1 0

RE: Dynamic SQL problem
by Aaron Watters 19 Apr '99

19 Apr '99

Dear François-Régis Chalaoux, You have a gadfly problem. There are too many layers of syntax here for my myopic eyes, however looking real hard at the following: insert into softdomain (idsoftware,iddomain) values( (select idsoftware from software where name = ), ) Gadfly only supports *literals* in "INSERT ... VALUES (...)" You cannot put a query inside the parens. Instead of insert into table (a,b) values ((select max(a) from table), 5) you can do this insert into table (a,b) select max(a) as a, 5 as b from table or even (Gadfly 1.0, not beta whatever) insert into table (a,b) select (select max(a) from table) as a, 5 as b from dual And you can always do a rewrite similar to the second one I think. And if "select * from dual" doesn't work upgrade. The "INSERT INTO...VALUES" is highly optimized using the assumption that no queries ever occur in the values... Regards, -- Aaron Watters http://www.chordate.com === stop procrastinating tomorrow.

1 0

RE: [Zope] File size
by Michel Pelletier 19 Apr '99

19 Apr '99

> -----Original Message----- > From: Shaw, Howard [mailto:ShawH@STHS.org] > Sent: Monday, April 19, 1999 9:37 AM > To: 'Zope(a)zope.org' > Subject: [Zope] File size > > > Is it possible to split a Zope database into multiple files, while > retaining conceptual unity? I don't like the thought that I > am bound by > a 2 gig restriction on my web site. Hmm.. there is no built in restriction to 2gig on the object database, there is however a 2 billion *object* restriction. Is this some sort of OS restriction on file size your pointing out? In either case, both restrictions will be removed with the introduction of ZODB3 (formerly know as BoboPOS). In addition to introducing multiple stores and threadability, the 2 billion object restriction will be lifted because we're moving from 23 to 64 bit OIDs. -Michel > Howard C. Shaw III > Programmer/SysAdmin > St. Thomas High School > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

problem porting to Sun
by Scherer, Bill 19 Apr '99

19 Apr '99

I'm trying to move a pcgi app from Linux to Sun. I've downloaded and installed then latest ZPublisher package from zope.org. Using the Test.py that come with ZPublisher, it works fine. When I try to publish it for real, I get the following error: pcgi-wrapper: Interrupted system call (102) failure during connect Any ideas? Thanks Bill

2 1

File size
by Shaw, Howard 19 Apr '99

19 Apr '99

Is it possible to split a Zope database into multiple files, while retaining conceptual unity? I don't like the thought that I am bound by a 2 gig restriction on my web site. Howard C. Shaw III Programmer/SysAdmin St. Thomas High School

1 0

RE: [Zope] Restricting access via IP address?
by Rob Page 19 Apr '99

19 Apr '99

> .... how do I limit visibility of Zope-served pages > by IP address? I guess using an if tag and REMOTE_ADDR > is one of of doing it but it seems sort of kludgey > when Zope seems to have most of the intranet-type > bases covered. You can either use the REMOTE_ADDR variable in Zope or config the web server to precude some set of IP addresses from accessing, for example, http://server.com/Zope/* --Rob

1 0