- Zope - Zope lists

RE: [Zope] A single value from SQL
by Rob Page 05 Jun '99

05 Jun '99

> So there isn't a way to directly call one ZSQLMethod from > another, then. I just tried this (and it worked!) with a simple Gadfly database: SELECT * FROM employees WHERE age =    where sqlSelectOldestAge: ---------------------------- SELECT MAX(age) AS oldest_age FROM employees --Rob

3 2

RE: [Zope] A single value from SQL
by Rob Page 05 Jun '99

05 Jun '99

> What I'm really trying to do here is: > > select * from some_table where some_column = (select max(some_column) > from another_table) > > but MySQL doesn't support nested selects (yet). > > I'm quite confident there's a way to do this -- I was reading about > direct traversal -- but I can't quite grasp it. <UNTESTED> ZSQLMethod1 ------------- SELECT MAX(some_column) AS fred FROM another_table ZSQLMethod2 ------------- SELECT firstname, lastname, email FROM some_table WHERE some_column =  DTMLMethod1 -------------   ,     </UNTESTED> --- I'd bet there's a way of doing _something_ like (I know I'm missing a sequence-item in here somewhere...) :   which would be more elegant if harder to read... --Rob

2 1

A single value from SQL
by Daniel M. Drucker 05 Jun '99

05 Jun '99

(Yes, I'm asking a lot of questions. Hopefully the answers to the more interesting ones can eventually make their way into documentation...) I want to do something like this pseudo_sql_method: select * from some_table where some_column =  other_sql_method looks like this: select max(some_column) from another_table The point being that other_sql_method is guaranteed to return a single value. I want to take that single value and directly interpolate it into the text of pseudo_sql_method. What I'm really trying to do here is: select * from some_table where some_column = (select max(some_column) from another_table) but MySQL doesn't support nested selects (yet). I'm quite confident there's a way to do this -- I was reading about direct traversal -- but I can't quite grasp it. Daniel Drucker

1 0

ANN: Experimental zope->static html mirror external method
by Dr. Ross Lazarus 05 Jun '99

05 Jun '99

Anyone needing to write a static html rendition of a zope site to a file system is welcome to try a very rough pre-alpha external method. fileme.py and fileme.txt are available via anonymous ftp at rossl.gmp.usyd.edu.au - or ftp://rossl.gmp.usyd.edu.au/ if you need to use a web browser. A more stable product will eventually appear. Please only try this release if you like to live dangerously....wget is safer and can probably do a better job. Bug reports, fixes and constructive comments to rossl(a)med.usyd.edu.au

1 0

Changing default new document contents
by Mitchell Marks 05 Jun '99

05 Jun '99

(I swear, I read the answer to this earlier today, but now cannot track it down.) Is there a document or method which gets copied or instantiated to provide what's put into a new document (or method) by default? I mean the  <h2></h2> <p> This is the  Document. </p>  To put it the other way around, can I modify or replace that, for a folder, by saving the different version under a reserved name id? And expect that then subsequent new documents anywhere under that folder will start out with my modified starter text. Somewhere I got the idea that dtcTemplate was the reserved name, but that doesn't seem to work. Thanks, Mitch Marks -- Mitchell Marks (773) 702-6041 AAC-010A CUIP: Chicago Public Schools / Univ. of Chicago Internet Project http://cuip.uchicago.edu/cuip Restore ``Under City Stone'' mural, 55th at Lake Park underpass!

2 2

What are the differences between DTML Document and DTML Method?
by T. C. Huang 05 Jun '99

05 Jun '99

Hi, Maybe this is a FAQ, but it does appear in the documents about Zope I've ever seen. Any one would like to make me clear? Thanks! T.C. Huang

1 0

Re: [Zope] FYI: Portal Toolkit Slides and Demo available
by Simon Michael 04 Jun '99

04 Jun '99

"Andrew M. Kuchling" <akuchlin(a)mems-exchange.org> writes: > programming. (But without automatic reloading of ExternalMethods, The above is easy to hack in, btw, and was darn useful to me when debugging methods. I think I posted about it on this list way back.

1 0

RE: [Zope] Running ZopeHTTPServer and PCGI together = a bad thing ?
by Michel Pelletier 04 Jun '99

04 Jun '99

> -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: Thursday, June 03, 1999 4:05 AM > To: Michel Pelletier; Zope List > Subject: RE: [Zope] Running ZopeHTTPServer and PCGI together = a bad > thing ? > > > >Yes there is some rather expensive forking overhead that > must be done to > >get from Apache to the Zope long running process. This is startup > >overhead only, once the connection gets to Zope the 'time to > complete' > >will be identical. > > Is this a fork for *every* request, eg every link I select. In that > case, isn't it pretty expensive overall? > A wafer-thin CGI program is forked for every request, this is used to connect up Apache and the Zope long running process. So yes, this expensive fork happens for every request. It's no different, however, then other CGI overhead. One of these days, someone is going to write a mod_pcgi module for Apache, and take that expensive fork out. For light loads, it's really not noticeable, but for heavy loads, one fork per request gets heavy. ZServer is noticably faster in this regard than Apache. > > I've used bbb.py from the Zope 2 distribution to create XML > transactions for 0.. 9211505 and 11844613... 11847812 (but that still > leaves 9211505..11844613 in limbo) > > unnh... so what are my options now? > Well, first realize that corruption is corruption, there may be no way to get some of your info back from the lala lands. If two process writes conflicted with each other, one wins, and one looses (often the winner however does not win completely, but leave a corrupted record behind). > 1) Chop the database at location 11844613 (but then what about the > junk at 9211505) Hmm.. first off, does it crash your Zope when you try and use it correctly? I would try wacking off the last 3K or so bytes starting at the last corrupted record, and then try exporting some stuff out, look for the point in managing the site where it breaks, this is probably where it encouters the broken record. > 2) export as much as possible to .bbe files and reimport into a clean > database? If you can export these objects, try this at least to preserve your information somewhere. > 3) use the bbb.py from the Zope 2 distribution to get transactions in > XML (but then how do I recreate the database - bbb.py doesn't mention > creation of a database)? Uh yeah, the whole XML thing isn't complete yet. The dump to XML is really for database inspection, not manipulation or transportation, for the moment. This will probably change. -Michel > 4) give up? ... nope, that's not an option. Zope is just so > damn useful. > > I hate to say this, but HELP! > Tone

5 4

looking for testers of a slashdot-clone zope product
by Butch Landingin 04 Jun '99

04 Jun '99

Hi ya all, I've written a slashdot-like zope product and it's almost ready to be put into the contrib page, but it needs two things before it's ready to go: 1) it's packaged in a zip format, not the tgz format that all the other zope products are packaged in -- if you can help me do the conversion or do it yourself, I'd like to hear from you; and 2) a last minute sanity check -- I need a couple of people to just install the package on their zope sites and check to see if it at least isn't broken when they install it. It uses Ty Sarna's TinyTable product so you should have that working on your setup if you plan to volunteer. I've tested it on version 1.10.2 and 1.11.0pr of Zope, but I'm hoping it should work fine on Zope2 versions as well. It would also work without the TinyTable product, but with some loss of configurability, so I'd rather have it tested with that functionality intact. If you want to volunteer, just send me some email, and I'll pick the first couple of people who replies, and send them the package. I'd rather not clutter this mailing list with the actual package, because its about 154K in size. I'll probably request to put in the contrib page after the conversion and sanity checking, so it should be available (barring any unforeseen barriers) to Juan and Alice in a few days. Best Regards, Butch Landingin butchland(a)yahoo.com _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

1 0

Re: [Zope] FYI: Portal Toolkit Slides and Demo available
by Chris Blackall 04 Jun '99

04 Jun '99

>Just to reiterate, the Portal Toolkit is not yet available, it should be >out in beta this month. Amos, This is very timely development for me and I can't wait to access it. Congratulations to the Zope team. About, http://www.zope.org/Products/PortalToolkit/Tour/Images/demo5.gif The advanced search in the demo allows for a focused search of Zope catalogue items, great, but could the metadata schema or search categories be extended to include Dublin Core(DC) Metadata standard? see http://purl.oclc.org/dc/ Although there are 13 elements in the DC standard, technically none are required, however using DC tags enables more accurate distributed searches and the possibility of an external (to the Zope DB) metadata repository that would have a namespace that conformed to a *standard* and was indexable by external webbots, agents etc. or addressable by a distributed search protocol such as Z39.50. see http://lcweb.loc.gov/z3950/agency/ I believe the incorporation of search facilities BETWEEN Zope portals (in future versions) would add a great deal of value to the proposed portal system. Just don't ask me to build one!! Regards __________________________________ Chris Blackall Graduate House Australian National University Canberra, ACT 0261 email: s3190067(a)student.anu.edu.au phone: 61 + 2 + 62467428 ANU ext: 7428 __________________________________

2 1