- Zope - Zope lists

RE: [Zope] How to keep table aliases apart in an ZSQL method
by Ernst Eeldert 21 Jul '01

21 Jul '01

> I can't use 'deptno' as the name, because the then the db > doesn't know which > deptno column I want to filter on. So then I need to use > 'e.deptno' as the > parameter name. So, I finally found a solution for this problem. There's an attribute of the <sqltest> tag which allows you to specify the column name (<dtml-sqltest param column="e.deptno">). Using that attribute, the name of the method input parameter doesn't has to be the same as the query column name. Ernst

1 0

tacker error
by Mick 21 Jul '01

21 Jul '01

I have the following error when trying to view a trackerWiki on Zope 2.3.3, i.e. the product adds ok, but when clicking on it to try and view it I get the error. The product is the latest CVS snapshot of tracker from http://www.zope.org//Members/klm/TrackerWiki/ Error Type: TypeError Error Value: __str__ returned non-string (type tuple) I have submited a bug report, but was wondering if someone had seen the same problem. thanks Mick

1 0

Finding Newest Document
by Chris Withers 20 Jul '01

20 Jul '01

Hi, I have a shedload of File objects all with a dateofpublication property. They are all catalogued an dateofpublication is a FieldIndex. I wonder what the most efficient way to get the article with the newest date of publication is? I had assumed a catalog search as follows would be best: article = Catalog(sort_on='dateofpublication')[0] Can anyone think of a better way? cheers, Chris

1 0

STX file issues
by Seamus O'Keefe 20 Jul '01

20 Jul '01

My installation of Zope is having trouble displaying certain words of the .stx files associated with the Tuorial (and presumably all stx files). It seem only the last letter of a such a word (in this case the terms defined in the glossary) gets output. All the StructuredText files and regex modules seem to be in order. I've had some help from list members already, but after running the installation file with both python 1.5 and 2.0, the problem persists. Further help would be greatly appreciated. Thanks! _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

1 0

Occasional stop service problems
by dek＠outformations.com 20 Jul '01

20 Jul '01

I have an old client getting a strange error message when they try to stop the Zope service on NT. The message is: Services Could not stop the Zope (Production) service. Error 0109: The pipe has been ended. I believe they are NT 4 SP 6 and the Zope version they have is at least 8 months old. They are also using SQL server 7. Even though the error message indicates that the service cannot be stopped, after I click OK on the error window, the Status column in the Services window goes blank next to Zope (Production) as opposed to "Started." And, the Start button is highlighted rather than the Stop button. One other time this happened I successfully logged onto the website so I suspect the Service is in fact not stopped despite what the Services window indicates. Also, when I have trying to restore a database at this point I have received the error message regarding to the database exclusive access. "Database in Use. the system administrator must have exclusive use of the database to run the restore operation. Backup or restore operation terminating abnormally." The client realized (from Task Manager Process tab) that the process python.exe was still running even the Zope (Production) service had been stopped. They highlighted python.exe and tried to end the process by clicking the End Process button without success. What has worked once before and worked again today is the following: After clicking OK on the Services error message above, I click on the Start button to start Zope again, then click on the Stop button to stop the service. The second time I try to stop the service I do not get an error message and I have no problem restoring gp or starting Zope again. Any help or clues to resolving the issue is much appreciated. Dale Kiefling --------------------------------------------------------------------------------- dek(a)outformations.com Outformations, Inc. http://www.outformations.com 939 61st Street, #13 415 831-8776 Voice Oakland, CA 94608 510 655-7133 Fax -- Collaborative Design and Software Development --

1 0

Re: [Zope] Is it just me... Other stuff
by rlanham＠speakeasy.net 20 Jul '01

20 Jul '01

> > 4. ???? maybe other stuff? Said it before, but this is the place to insert again: A Rosetta page, for ASP, PHP, Perl, etc, to Python. This is how you do this in ASP and/or PHP and/or Perl... and this is how it you do that in Python. Not a snip library for the lazy, but an essential Rosetta Stone, to help the new user to get to the "I Get IT" level more stage more quickly. I was able to "get" enough of what Zope does and how to make it work soon enough to continue using it love it. But I still cannot bangout working dtml code the way I can asp pages. I would really love this Rosetta page. I would contribute to it too. > ------------ Original Message ----------- > From: complaw(a)hal-pc.org <complaw(a)hal-pc.org> > Date: Fri, 20 Jul 2001 20:26:04 GMT > > [Snip] > > May I suggest the following: > [Snip] > > I think it will give new users a good starting point though! > > > > > > 1. A core introductry reading list > > > > 2. A series of problem-sets to be solved using Zope (okay I'm taking this > from > > ACS a bit, but I think its not such a bad idea!) > > > > 3. A FAQ distilled from the ZDP, the lists, etc. etc. > > > > 4. ???? maybe other stuff? > > The other stuff might be something like a weekly newsletter with a > step-by-step > guide on how to solve some common fundamental problem (like getting Zope > to > print dates in various formats, etc.). > > This would give the newbie something to chew on for a week. They could > store it > up on a web site for a reference list, and it wouldn't be considered spam. > > The nice thing about it is that once you have a cadre of articles, you > just > (re)circulate the same ones ala Parents magazine. > > Ron > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

3 3

SSL Error, SSL handshake failure
by P B 20 Jul '01

20 Jul '01

Hi, Any help on this would be greatly appreciated. I am trying to xmlrpc with M2 crypto in ZOPE. My modules work fine outside of ZOPE, but as soon as I run under ZOPE, I get the following error: ====================================================== Error Type: SSLError Error Value: ssl handshake failure File C:\Program Files\ZopeWebSite\lib\python\xmlrpclib.py, line 547, in __call__ File C:\Program Files\ZopeWebSite\lib\python\xmlrpclib.py, line 630, in __request File C:\Program Files\ZopeWebSite\lib\python\M2Crypto\m2xmlrpclib.py, line 42, in request File C:\Program Files\ZopeWebSite/bin/lib\httplib.py, line 689, in putheader File C:\Program Files\ZopeWebSite/bin/lib\httplib.py, line 483, in putheader SSLError: (see above) Any thoughts???? __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

1 0

SF Based Zope/CMF Mentor Needed for Small Dev Team
by Corin Royal Drummond 20 Jul '01

20 Jul '01

Hey All, If this is off topic, please let me know. I'm looking for a zope/CMF guru located in the Bay Area who can mentor a team of three developers (PHP, Perl, ASP are their backgrounds). We're building a CMS for a public radio station using the CMF, and want some help getting up to speed. We have a limited budget, and the job would not be a lot of hours, maybe 20 or so. Candidates should have strong Zope and CMF experience, good teaching skills and be SF Bay locals. SDO.NET is a six person web developement startup that's just moving into a new office in San Francisco. We are a worker owned collective, and provide technology strategy consulting, web design, and application development for small-to-medium businesses and non-profit groups. We're a pretty laid back and fun group to work with, so I think we could have a good time together. If you're interested, contact me at corinroyal(a)yahoo.com. Cheers, Corin |-Corin Royal Drummond |-Operations Director/Linux Sysadmin |-SDO.NET Web Development Studio

1 0

RE: [Zope] How to keep table aliases apart in an ZSQL method
by Ernst Eeldert 20 Jul '01

20 Jul '01

> Not that what matters is that you have 'deptno' defined as a > parameter of > the ZSQL method. The fact that, in your table, the field is > "deptno" is > just a coincedence. The field in the table is referenced as > "e.deptno" is > fine--but that's the name of the parameter for the ZSQL > method. To make is > clearer: The problem is that I need to use the following dtml statement to make the parameter optional: <dtml-sqltest e.deptno op=eq type=int optional> I can't use 'deptno' as the name, because the then the db doesn't know which deptno column I want to filter on. So then I need to use 'e.deptno' as the parameter name. The 'dictionary' syntax you suggested for the <dtml-in> statement made it accept the e.deptno as a parameter. So now I use this: <dtml-in expr="emp_list({'e.deptno':10})"> which works like a charm. Thanks alot. Ernst Eeldert PS. this little conversation between Joel and can be seen as 1 vote against a seperate 'newbie-list'. One thing I have to say to other newbies: if you solve your problem slightly different then was suggested by a guru, don't hesitate to reply with the full solution. This way, we make the mailing list an even more valuable resource for other newbies.

1 0

How to keep table aliases apart in an ZSQL method
by Ernst Eeldert 20 Jul '01

20 Jul '01

Hi, I'm having trouble passing a parameter to a ZSQL which uses table aliases. The SQL statement is as follows: select e.empno ,e.ename ,d.dname from emp e ,dept d where e.deptno = d.deptno <sql-group and> <dtml-sqltest e.deptno op=eq type=int optional </sql-group> Now, this isn't working on two points: 1. the <sql-group and> is my own idea, and doesn't work (apparently :) 2. when I put a snippet like <dtml-in expr="emp_list(e.deptno=deptno)"> <li><dtml-var ename> </dtml-in> into an DTML-method, I get the following error: Error Value: keyword can't be an expression Maybe I'm trying to solve 2 seperate problems at the same time, but then again, I still am a very newbie. Thanks for your suggestions. Ernst Eeldert

2 1