- Zope - Zope lists

Re: [Zope] best postgreSQL adapter?
by Federico Di Gregorio 09 Mar '01

09 Mar '01

> On Thu, Mar 08, 2001 at 11:53:43AM -0700, Joshua wrote: > > I'm curious as to which PostgreSQL zope adapter is most solid. I'm looking > > to build what will eventually have fairly heavy traffic database usage. > > Let's see...I found: > > > > psycopg/ZpsycopgDA > > ZPyGreSQLDA > > PoPy > > > > any others? psycopg mentions that it is designed for heavy multi threaded > > operations but popy seems more developed. > > In a nutshell, you hit it on the head. Psycopg is _very_ young. > It may surpass PoPy in the future. true, psycopg is very young but already *very* stable. it is fully DBAPI-2.0 compliant, just like popy, so you won't have any problem switching back and forth between them. (btw, our website runs on psycopg from 0.3 onward and we never had any problems.) > For now, I would recommend that you develop using PoPy and build a secondary > test machine using psyco. Your applications should be 100% compatible, so, > there should be no real cost to switching later if psycopg proves better > in your application. completely true ;) > > I would appreciate any good input. Thanks what can i say? give psyco a try... ciao, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog(a)mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog(a)debian.org Abandon the search for Truth; settle for a good fantasy. -- Anonymous

1 0

Re: Zope training in NW-Europe?
by Mark Pratt 09 Mar '01

09 Mar '01

Hello all, Since there seems to be some confusion about the Zope education and training services offered by beehive --- I'd like give some answers and resolve any confusion. We have a division within our company called "Education & Publishing". this division publishes: - Zope electronic books (ebooks) - regular (print) books in cooperation with several publishing houses in the U.S.A. and Europe (coming soon!) - teaches Zope Courses While our ebooks are "training materials" these have nothing to do with the materials which are part of our Zope courses. (DISCLAIMER: We do usually give course participants a printed copy of a related beehive ebook for free --- but not because it is part of a course) We *do not* sell our course material. This is really a quality issue --- each course is a major investment on our part and we want to make sure that this hard work isn't comprimised by an instructor who has not been trained to properly teach our courses. During the month of April we will release additional information about beehive Zope Courses. Hope this helps. Regards, Mark -------------------------------------------------------------- mark pratt (managing director) mark(a)beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

1 0

Update URL in SQL
by helmjan＠hotmail.com 09 Mar '01

09 Mar '01

I have a database which has information about books, and there should be link to the publishers website. When I use SQL -insert all goes fine, but when I want to update records which have URL inserted I get an error. It works if I use html-quote, but then (of course) the link is useless. Can anyone help? SQL code: UPDATE info SET name="<dtml-var name>", description="<dtml-var description>", url="<dtml-var url>", publisher="<dtml-var publisher>", update="<dtml-var update>" WHERE id = <dtml-var id> input url: <a href="http://www.bookpress.com">Book Press</a> Error Type: sql.error Error Value: ('42000', 1064, '[TCX][MyODBC]You have an error in your SQL syntax near\'http://www.bookpress.com">BookPress",\012publisher="BookPress",\ 012update="no",\' at line 3') Traceback (innermost last): File C:\Ohjelmatiedostot\WebSite\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\Ohjelmatiedostot\WebSite\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Ohjelmatiedostot\WebSite\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File C:\Ohjelmatiedostot\WebSite\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Ohjelmatiedostot\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: updateReport) File C:\Ohjelmatiedostot\WebSite\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: updateReport) File C:\Ohjelmatiedostot\WebSite\lib\python\OFS\DTMLMethod.py, line 189, in __call__ (Object: updateReport) File C:\Ohjelmatiedostot\WebSite\lib\python\DocumentTemplate\DT_String.py, line 538, in __call__ (Object: updateReport) File C:\Ohjelmatiedostot\WebSite\lib\python\DocumentTemplate\DT_In.py, line 480, in renderwb (Object: updateSQL) File C:\Ohjelmatiedostot\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 489, in __call__ (Object: updateSQL) File C:\Ohjelmatiedostot\WebSite\lib\python\Products\ZODBCDA\db.py, line 198, in query sql.error: (see above)

2 1

IPC 9 News?
by Chris Withers 09 Mar '01

09 Mar '01

Hi, I was wondering if anyone had any cool news from the Zope track at IPC 9 for those of us who can't make it? cheers, Chris

7 7

container has no security assertions ?!?!
by Loren Stafford 09 Mar '01

09 Mar '01

When I try to access the mime type of an uploaded file .... <dtml-boundary type_expr="CVfile.headers.headers[1]" name_expr="CVfile.filename()" disposition=attachment encode=base64> I get this exception... An exception occurred in a DTML method or document. Error type: Unauthorized Error value: Access denied for ['Content-Disposition: form-data; name="CVfile:file"; filename="D:\\Arrivals\\Glossary.doc"\015\012', 'Content-Type: application/msword\015\012'] because its container, <rfc822.Message instance at 20112e0>, has no security assertions. What does this mean? What am I doing wrong? -- Thanks -- Loren

1 0

Re: [Zope] Make a Zope object single threaded
by ender 09 Mar '01

09 Mar '01

Date: Tue, 6 Mar 2001 16:04:57 -0800 From: "Tim Lakey" <tim(a)carbonwave.com> To: <zope(a)zope.org> >>Does anyone know how to force a Zope product to be single threaded within >>Zope? its hackish, but you can take advantage of the python interpreter's module loading rules. basically you create a module in your product that defines a lock object on the modue level. on calls to the object you want to synchronize try to use the lock/semaphore/etc for locking. kapil

1 0

Running up and down the hierarchy
by Danny William Adair 09 Mar '01

09 Mar '01

Hello to everybody! Supposed I have an object hierarchy looking like this: the_root------A-----Aa ---Ab(image) ------B-----Ba ---Bb------Bba ---Bbb(DTML document) A DTML document "Bbb" lying in folder Bb wants to access the image in Folder Ab. The only way I know how to do this is <dtml-with Bb> <dtml-with B> <dtml-with the_root> <dtml-with A> <dtml-var Ab> (or do whatever with it) </dtml-with> </dtml-with> </dtml-with> </dtml-with> Of course this sucks. The first thing I thought when I encountered this situation was "I might have to think over my folder structure". I did, but still have this situation in some situations, and for several reasons I want to leave some of my objects as indicated in the figure above(won't change it). Nesting a couple of with's does work, but I would rather like to do something like this: <dtml-with "Bb/B/the_root/A"> (or dtml-path_with...) <dtml-var Ab> </dtml-with> or maybe even <dtml-var "Bb/B/the_root/A/Ab"> (dtml-path_var... resp.) Is there something like this around? I took a look at the PathHandler product, but I don't have enough Zen (yet) for doing some __bobo_traverse__ magic myself (that's the entry point, right?). I guess a self-defined dtml tag that does the with-nesting (running the ladders) would do fine. How am I going to do this? Or are there other ways? I just want to make the dtml more readable (and shorter). Thanks so much in advance, Danny btw: Am I the only one in need for something like this?

2 2

Reloading a page.
by Daniel Corrêa de Azevedo 09 Mar '01

09 Mar '01

Whatz up, guys? Well, I´m having problems in reloading a page that shows information contained in a table of a database. The problem is that whenever I include some data in the database at another page it send´s me back to that page that shows information, it doens´t show the update, but a cached page. I´m using the IE 5.0 and I haven´t figured out how to reload it every time without changing the configuration of the browser. I´ve tryed the same code that I´m using in IE 5.0 in IE 5.5 and this problem doens´t happen. Hope that you all could give me some help. Thank´s, Daniel C. Azevedo

5 5

New User: MS IIS and Exchange
by HIND, Philip 09 Mar '01

09 Mar '01

Hello, My apologies if this has been answered before, I have searched the archives. I am evaluating Zope as a content management system for websites I run at a college. We currently run IIS and MS Exchange on an NT server. What I would like to know is this... Eventually I will want to start using Zope to serve the site/s but I imaging I will need to change the port number so it runs from http://www.ourhost.com/ rather than http://www.ourhost.com:8080/ But I am worried that if I change this it will cause the exchange system to fail many of our users access their e-mail using the Exchange webmail system at http://www.ourpost.com/exchange Does anyone else using IIS and exchange have some guidance they can offer. Very impressed with Zope so far! Phil

3 2

best postgreSQL adapter?
by Joshua 09 Mar '01

09 Mar '01

I'm curious as to which PostgreSQL zope adapter is most solid. I'm looking to build what will eventually have fairly heavy traffic database usage. Let's see...I found: psycopg/ZpsycopgDA ZPyGreSQLDA PoPy any others? psycopg mentions that it is designed for heavy multi threaded operations but popy seems more developed. I would appreciate any good input. Thanks

4 3