- Zope - Zope lists

command line Zope?
by Kyler B. Laird 15 Feb '01

15 Feb '01

I'm trying to roll out Zope for wide usage and one of the things users want already is a command line interface to Zope. At first, I thought that it was a silly request, but the more I think about it, the more I like it. In order to provide this, I need a way to run Python such that it connects to the ZODB (perhaps requiring ZEO?) and gives the user access to the database only as a specified user (with the option of manually authenticating to receive additional roles). Is this easy to do? Has it already been done? I read about importing Persistence and ZODB, but I'm clueless about setting up a user's environment in Python. Any pointers to appropriate documentation will be greatly appreciated. Thank you. --kyler

8 13

Searching ZCatalog on multiple properties
by Chris Muldrow 15 Feb '01

15 Feb '01

I've got some DTML Documents with properties Category and Author, and I'm trying to build a search interface for ZCatalog. What I want to do is build a multiple select list of the Author's names, but I want to use the Category to only display the names of People who have written columns. As an added wrinkle, the Author field present on the files corresponds to an "expanded name" sitting in a mysql DB. In other words, a column I've written might have cmuldrow in the Author property--I query the DB to return Chris Muldrow to display to searchers. Here's my code so far--it queries the DB correctly and returns a good list of names, but not filtered by Category. I tried a dtml-in tag calling NewsCatalog({'Category':'Column'}), but wherever I put it doesn't seem to work. Any ideas? Thanks! Chris Muldrow muldrow(a)mac.com <dtml-var standard_html_header> <h2><dtml-var title_or_id> </h2> <form action="ColumnistFind" method="get"> <select name="User" size=10 MULTIPLE> <dtml-in expr="uniqueValuesFor('User')"> <dtml-let authName=sequence-item> <option value="<dtml-var sequence-item>"><dtml-in expr="SearchAuthors(user=authName)"><dtml-var authorName></dtml-in></options> </dtml-let> </dtml-in> <input type="submit" name="Search" value="Submit query"> </select> </form> <dtml-var standard_html_footer>

2 3

the misc_ dictionary
by aZaZel 15 Feb '01

15 Feb '01

Hi all, I'm a little bit confused on how to use the misc_ dictionary to define product resources. I've looked into other products such as ZCatalog ZGadflyDA and SiteAccess but it's use is not so clear for me especially because most products only need to associate an icon with a python class. Someone can explain a bit more how to use it? There is an usege policy? thanks in advance Alberto

3 6

RE: [Zope] MySQL, PostgreSQL, etc
by Ned Lilly 15 Feb '01

15 Feb '01

Donald Braman <mailto:donald.braman@yale.edu>wrote: > 1. Documentation will be important to me...are there good references out > there beyond the Postgres (on-line/hard copy) manual that I could look at? My company, Great Bridge, provides commercial support for PostgreSQL. We've put PDFs and HTML of our manuals online at www.greatbridge.com/docs > 2. Is there any GUI project for Postgres out there? There are several, including PgAdmin (Windows-based) and phpPgAdmin (browser-based). Both are active open source projects hosted at our developer site, www.greatbridge.org. Regards, Ned Lilly -- ---------------------------------------------------- Ned Lilly e: ned(a)greatbridge.com Vice President w: www.greatbridge.com Evangelism / Hacker Relations v: 757.233.5523 Great Bridge, LLC f: 757.233.5555

1 0

Newcomer
by Bob Gailer 15 Feb '01

15 Feb '01

I am new to Zope and these lists. So I hope to learn where to post things, and how to avoid posting questions already asked. What I am most interested in knowing: Is there support for pages with (the equivalent of) applets or java swing controls? In other words, a page with controls that can be dynamically updated without resending the entire page? Is there support for including python code in a page that will be run on the browser (akin to javascript)? I understand that session support is coming. How soon? I created an ODBC connection to Visual FoxPro tables. Once I run zsql the tables are locked until I shut the Zope server down. Is there a way to share the tables and/or release them? Where does one post enhancement requests? Is there a way to search the archives for a topic. The only archive display I found was by date, and it seems that would require a lot of digging to find something. Bob Gailer mailto:ramrom@earthling.net 303-442-2625

2 1

FSSession and Zope 2.3.x
by Peter Bengtsson 15 Feb '01

15 Feb '01

Hello, Does FSSession (http://www.zope.org/Members/gaaros/FSSession) work with Zope 2.3.x on *nix? If not, how can this be solved? Best regards, Peter

3 3

[Fwd: [zope] Digest Number 1120]
by Lee 15 Feb '01

15 Feb '01

-- Lee Reilly mailto:lee.reilly@ntlworld.com ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,, HAVE SKILLS; WILL TRAVEL. I'm currently looking for an internship in the USA in the field of web development. Ideally, I'm looking for a placement for 3 to 18 months. Can you help? More details, my resume, etc. @ http://homepages.strath.ac.uk/~aeu97172/ </shameless plug>

1 0

MySQL, PostgreSQL, etc.
by Donald Braman 15 Feb '01

15 Feb '01

Hello! I'm in a situation that I'm sure many are familiar with...choosing between MySQL or PostgreSQL. My main goals are stability under high load and ease of use. I don't need transactions. I know the standard comparison: MySQL is faster, simpler, and more popular, while PostgreSQL is slower but is more fully SQL standards based, handles transactions, etc. Are these generally accurate descriptions? I'm wondering what people who have used either (or both!) think about using these (or other databases) in conjunction with Zope. Are there any special cases where one or the other works better or worse with Zope? Donald Braman donald.braman(a)yale.edu

5 4

Re: [Zope] export to excel
by Ronald L. Roeber 15 Feb '01

15 Feb '01

> From: "K H Subrahmanyan" <subrahmanyan.kalathur(a)wipro.com> > Subject: [Zope] [zope]: Add music to the page > > hi, > I am using zope for my project. > I would like to know whether we can add music to my page. > > Thanks for any suggestion. > subrahmanya. > Here is a crude example of how I export a pipe delimited text file that seems to work fine for those who use it. DTML method is export.txt and it contains the following: --------------------- Content-type: text/plain <dtml-call "REQUEST.set('delimiter', '|')"> REG_ID<dtml-var delimiter>NAME<dtml-var delimiter>. . . <dtml-in sqlAllRecords sort="NAME"> <dtml-var REG_ID><dtml-var delimiter><dtml-var NAME><dtml-var delimiter>. . . </dtml-in> ---------------------- I could clean it up a bit more and make it more versitile, but haven't gotten to it. Hope this helps... Ron Roeber University of Nebraska

1 0

MailHost product?
by Edwin Martin 15 Feb '01

15 Feb '01

Hello, After upgrading to Zope 2.2.4, I can't mail anymore. I have a page which sends an e-mail. I'm sure the proxy-settings are ok. It still won't work. I clicked 'MailHost' I once added to the root and it gives an error. Deleting the MailHost and trying to add a new one also gives an error: "Resource not found". No big deal. Lets find an updated MailHost product. The easiest way: I type 'MailHost' in the search-box. 17 Items found, but no MailHost product. Let's try the 'Advanced search'. Here, I can select a category, so I select 'Product release'. No results... I go to the download-page on the Zope website. I try all 'obvious' categories, but MailHost is in none of them. But fortunately, there is always the 'catch-all' 'All Zope Products'. The page says: "They are listed in alphabetical order". The page begins with 'Refresh'. Right. So I click 'Title'. There are 284 products. I can't click the 'M' for MailHost, so I have to browse... Click-wait-click-wait-click-wait.... 'Macromedia Generator 2 Adapter', 'Managed Mode additions to ZWiki'... What? No MailHost?? Grrr. And this is certainly not the first time I couldn't find the stuff I need. Please help me! Why is there no good documentation? Why is Zope so baaad? Why didn't I had these problems with Perl, PHP, C or Java? Why does this Zope-project takes twice as long as any other project? Edwin Martin.

2 1