- Zope - Zope lists

RE: [Zope] Zope and MySQL, what about win2000
by Capesius, Alan 30 Oct '01

30 Oct '01

I haven't tried with w2k yet, but under NT4, use the mySQL ODBC drivers and the ZmxODBCDA. Works fine. I'd imagine the same thing would work under w2k >>>-----Original Message----- >>>From: Peter Bengtsson [mailto:mail@peterbe.com] >>>Sent: Tuesday, October 30, 2001 12:26 PM >>>To: Andreas Jung; Horst Wald; zope(a)zope.org; >>>website-talk-admin(a)list.ora.com >>>Subject: Re: [Zope] Zope and MySQL, what about win2000 >>> >>> >>>Anybody got similar advice/report on Windows 2000? >>> >>> >>>>Zope 2.4.X under RH 7.1, Mysql 3.23, MySQL-python 0.9.1, >>>ZMySQLDA 2.0.8 >>>>work very fine for me. >>>> >>>>Andreas >>>>----- Original Message ----- >>>>From: "Horst Wald" <horstwald(a)hotmail.com> >>>>To: <zope(a)zope.org>; <website-talk-admin(a)list.ora.com> >>>>Sent: Tuesday, October 30, 2001 09:21 >>>>Subject: [Zope] Zope and MySQL >>>> >>>> >>>> > Hello, >>>> > >>>> > I tried to connect Zope and MySQL a few months ago - and >>>failed. I'm going >>>> > to try again now and I can choose freely which Linux, >>>which Zope, which >>>> > MySQL I want to use. I would like to keep things as easy >>>as possible, >>>>which >>>> > should I choose? >>>> > >>>> > Horst >>>> > >>>> > _________________________________________________________________ >>>> > Downloaden Sie MSN Explorer kostenlos unter >>>>http://explorer.msn.de/intl.asp >>>> > >>>> > >>>> > _______________________________________________ >>>> > 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 ) >>>> > >>>> >>>> >>>>_______________________________________________ >>>>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 ) >>> >>> >>>_______________________________________________ >>>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 ) >>>

2 1

Document Library Approval
by Richard Hewison 30 Oct '01

30 Oct '01

We're still having no joy trying to get document submission working properly with the DocumentLibrary product. The only circumstance under which document submission approval happens (prior to the document becoming available in the library) is when we use the 'Add Document' button from within the 'Documents' document store. If we go via the document_submit DTML method then approval is never required. Has anyone else experienced this?

2 1

(no subject)
by biz＠ebookleader.org 30 Oct '01

30 Oct '01

1 0

Keeping a Variable's Value: This SHOULD Be Easy
by Ben Ocean 30 Oct '01

30 Oct '01

...but apparently it's not. If I were writing this in PHP: <html><body> Okay, boys and girls! Let's open the magic box and generate a random number! (applause)<br and drum roll> <? x = int mt_rand(0,9); echo x ?><br, strike up the band> Wow! Wasn't that exciting? Oh no! I forgot the magic number<br, shrieks of horror> <? x = int mt_rand(0,9); echo x ?><br, strike up the band again> Oh, of course! How could I forget!<br, fade to black> </body></html> ...but apparently DTML *does* forget. Call that daggone variable more than once and you have to run the formula that generates a random digit! Bam! Variable's gone. Is there no way around this? Please help... BenO

1 0

Teaching zope
by Gregory Dudek 30 Oct '01

30 Oct '01

I am planning to teach a lecture on Zope (maybe two) in an undergraduate "cool tools" class at my university. I wonder if other people have done this and if there are any resources already available (list a set of notes). Greg Dudek ---- Professor Gregory Dudek Centre for Intelligent Machines School of Computer Science McGill University currently on leave at Stanford University and Xerox PARC <http://www.cim.mcgill.ca/~dudek> FAX: 514-398-7348 Mail address: 500 Melville Ave Palo Alto, CA 94301 USA

3 2

Zope and MySQL
by Horst Wald 30 Oct '01

30 Oct '01

Hello, I tried to connect Zope and MySQL a few months ago - and failed. I'm going to try again now and I can choose freely which Linux, which Zope, which MySQL I want to use. I would like to keep things as easy as possible, which should I choose? Horst _________________________________________________________________ Downloaden Sie MSN Explorer kostenlos unter http://explorer.msn.de/intl.asp

3 2

calling dtmlMethod from python
by Shane O'Sullivan 30 Oct '01

30 Oct '01

Can anyone please help with this, I'm new to zope and trying to write a simple python script to handle some logic which will then call a dtml method. I'm calling the method as such: context.scReport() The error I'm getting back is Error Type: KeyError Error Value: standard_html_header standard_html_header is being called from the scReport method which suggests the scReport method is being invoked but why are we getting an error?? Any suggestions, TIA Shaneo

3 4

ZSQLMethod Cache(unusual behavior)
by Raúl Pérez 30 Oct '01

30 Oct '01

Hi all, I am a newbie and I have a question, I have a countries table with 'country_code' and 'name' fields, the table has 211 records and the database is postgres and connection is made with product Z Psycopg (also I have checked it with PoPy and the result is the same one I explain later). I have declared a ZSQLMethod(getCountriesZSQL) with a simple query: SELECT country_code,name FROM countries. At Advanced Tab's ZSQLMethod I have managed the following parameters to cache the query: Maximum rows to retrieve: 300 Maximum results to breaks: 300 Maximum Time (sec) to breaks: 5000 I have created a DMTL Method to show a combo-select of countries: <SELECT name="comboCountries"> <dtml-in getCountriesZSQL> <OPTION VALUE='<dtml-var country_code null="">'> <dtml-var name null=""> </dtml-in> </SELECT> This is my question: When I delete a record of countries table, the table changes and I think that the combo-select shouldn´t change because is cached; but, in fact, the combo-select changes soon, over he fifth or sixth page refresh. The result changes showing 210 and 211 records randomly... What is the reason of this behavior? Does anyone know what is the solution? Regards, ZRaul. Z8-)

2 1

Problem: Document Library 1.0b1 + Zope 2.4.2
by Heimo Laukkanen 30 Oct '01

30 Oct '01

Hi, I was just upgrading one of our Zope-installations from 2.3.3 to 2.4.2 and noticed that after upgrade DocumentLibrary has some problems. Libraries that are in use produce error: Error Type: KeyError Error Value: validate With traceback: <!-- Traceback (innermost last): File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 223, in publish_module File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 187, in publish File /usr/share/zope/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: kirjasto) File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 171, in publish File /usr/lib/python2.1/site-packages/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 112, in call_object (Object: index_html) File /usr/share/zope/lib/python/OFS/DTMLMethod.py, line 195, in __call__ (Object: index_html) File /usr/lib/python2.1/site-packages/DocumentTemplate/DT_String.py, line 546, in __call__ (Object: index_html) File /usr/share/zope/lib/python/OFS/DTMLMethod.py, line 203, in __call__ (Object: document_browse) KeyError: (see above) Luckily the Index it self will work fine. And DocumentFile-products work ok. If I try to create a new library, I will get an error: <!-- Traceback (innermost last): File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 223, in publish_module File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 187, in publish File /usr/share/zope/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 171, in publish File /usr/lib/python2.1/site-packages/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addDocumentLibrary) File /usr/lib/python2.1/site-packages/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addDocumentLibrary) File /var/zope/Products/DocumentLibrary/DocumentLibrary.py, line 59, in manage_addDocumentLibrary File /var/zope/Products/DocumentLibrary/DocumentLibrary.py, line 136, in __init__ (Object: funky) File /var/zope/Products/DocumentLibrary/TopicIndex.py, line 280, in __init__ (Object: ) TypeError: (see above) Has anyone yet made patches or have these working together? -huima

1 0

RE: [Zope] Platform statistics
by Jeffrey Robinson 30 Oct '01

30 Oct '01

Heh! This perhaps should not be an e-mail I forward to the project supervisor to help leverage Zope then, huh? (Of course, knowing that authors tend to be their own worst critics, too!) I'll certainly keep the URL for ASP-based redirection on hand; though I'm somewhat worried about the caveat at the end of the document about URLs... but that is only based on the fact that I personally can't try things out, I'm required to hand things off to the admin for implementation; with each "hardship" endured causing a mark against Zope. Thanks most-muchly for the reply, though. > -----Original Message----- > From: Andy McKay [SMTP:andym@ActiveState.com] > Sent: Tuesday, October 30, 2001 10:39 AM > To: Jeffrey Robinson; zope(a)zope.org > Subject: Re: [Zope] Platform statistics > > > The administrator's main contention is that it is open source, > unsupported > > and my attempt to lock them into a unix-centric platform; something that > > will work fine under "unix" but Windows is an after-thought. > > Lol :) > > Seriously though the Windows version of Zope sometimes does lack a little. > PCGI is just a horrible hideous solution that I threw out after playing > around with it and just ran Zope on another port. > > I was looking around for a solution to this and what we really need is an > ISAPI filter that does proxying. In a similar manner to the one for > BeaLogic > server, http://www.weblogic.com/docs51/admindocs/isapi.html this just > proxies everything off to Zope. Of course this takes time to develop and > no-one I know of so far has worked on it. > > Heres an off the wall solution, use ASP to call Zope. > http://www.wc.cc.va.us/dtod/zope/ Not a great idea for a high performance > site... In the end I just used Apache on Windows or ZServer straight. > > Cheers. > -- > Andy McKay. >

1 0