December 2005 - Zope

MySql problems
by Dennis Allison 02 Dec '05

02 Dec '05

I have not yet completed differential diagnosis, but I was hoping someone had encountered a similar problem and could pass along a fix/workaround. The following program fails to do the writes -- import MySQLdb initdb='test' dbuser = 'root' dbpass = 'XXXXXX' host = 'localhost' connection = MySQLdb.connect( db=initdb, user=dbuser, passwd=dbpass, host=host ) cursor = connection.cursor() qd = "delete from test.data" cursor.execute(qd) qi = "insert into test.data values('ardvark', 'homework') " print qi cursor.execute( qi) q2 = "select * from test.data" cursor.execute( q2) res = cursor.fetchall() print res when run with Mysql-Python-1.2.1c under Python 2.4.2, but works just find with Mysql-Python-1.1.1 under Python 2.3.5. The tables are Innodb tables (that is, transactional). Running Zope with Python 2.4.2 and Mysql-Pyton 1.2.1c works just fine. Is there something special I need to do that I have forgotten? --

3 2

Short tutorial on I18n with Five
by Philipp von Weitershausen 01 Dec '05

01 Dec '05

I'm happy to announce that I've finally managed to document the internationalization (i18n) features that Five has brought to the Zope 2 world since version 1.1: http://worldcookery.com/files/fivei18n This short tutorial compares current Zope-2-based solutions to the i18n problem with the Zope 3 i18n framework. It also gives a few pointers on how to use the latter in Zope 2 applications through the means of Five. It is not a full-blown tutorial and it expects the reader to be quite familiar with i18n-aware software development in Zope already. Target audience is mostly people switching over their Zope 2 products to Zope 3 technology which i18n is a part of. The tutorial also serves as a documentation of a new Zope 2 core feature because Five 1.3 is included in Zope 2.9 which is thus the first Zope 2 version to come with built-in i18n support!

1 0

Displaying pdf
by Rick Smith 01 Dec '05

01 Dec '05

Perhaps someone can point me in the right direction. I am trying to display a pdf file (actually stored in LocalFS) from a python script. To do this my approach (probably there's a better way) is :- RESPONSE.setHeader('Content-Type','application/pdf') RESPONSE.redirect(path) My main problem is that on some occasions the file is properly opened in acrobat (I'm using firefox on linux, but similar effects are obtained using ie6/windows), while on other occasions raw pdf is displayed in the browser field with a content-type of text/html. I'm unable to see any difference to explain this difference - the documents are all scanned in the same way and imported into acrobat in the same way, yet Zope (I presume) interprets them as have differing content-type. I presume that this problem would go away if I didn't use the redirect. I'm sure it's blindingly obvious but I can't see how to do it another way. I'd also be happy to display the pdf within an html document/frame but my knowledge of html is missing something at this point....... Please help me in my weakness....... Rick . ___________________________________________________________ WIN ONE OF THREE YAHOO! VESPAS - Enter now! - http://uk.cars.yahoo.com/features/competitions/vespa.html

5 6

Re: PHPGateway Issues
by Asad Habib 01 Dec '05

01 Dec '05

I think I may have to compile PHP with the 'cgi-recirect' option enabled. I created a PHParser object, placed a 'Hello World' PHP script in it, and then tried to view it. I got the same error as before: '/usr/bin/php' may not be a PHP-CGI program. The result from the program is empty(0 byte). Do you know if this will interfere with the Apache PHP module in any way? Also, it is okay to have two PHP's installed on a single machine? And what are the security implications of running PHP this way? Thanks. On Thu, 1 Dec 2005, Wei He wrote: > Hi, > > 'phparser(a)ied.cn' is a mailing list of some PHParser/PHPGateway users. > > Does anyone on the list have some experiences on running PHParser on Mac OS X? > > > Quoting Asad Habib <ahabib(a)engin.umich.edu>: > >> Hello Wei. Okay, please keep me posted when you determine what the problem >> is. If anyone else on the Zope group has experienced a similar >> problem, please let me know. Thanks. >> >> On Thu, 1 Dec 2005, Wei He wrote: >> >>> Quoting Asad Habib <ahabib(a)engin.umich.edu>: >>> >>>> Hello. The message came from Mac OS X. Also, how do I resolve this issue? >>>> I am currently also running phpMyAdmin so I know for a fact the PHP-CGI >> is >>>> present. Also, PHP is currently running on its own (i.e. not behind >>>> Apache). >>> >>> It looks like I'll have to get a Mac OS X box to find out how PHP is >> running on >>> it. >>> Will take some time. >>> >>> Best, >>> >>> -- >>> Wei He >>> IT Manager >>> IED (Institute for Environment & Development) >>> Tel: +86-10-51319216 >>> Web: http://www.ied.org.cn >>> >>> >>> >> >> > > -- > Wei He > IT Manager > IED (Institute for Environment & Development) > Tel: +86-10-51319216 > Web: http://www.ied.org.cn > > >

1 0

Creating a DTM Document in a variable folder.
by Martin Koekenberg 01 Dec '05

01 Dec '05

Hello, I don't have any Python experience yet, so who has a solution for this 'problem'. Example: I 've 3 folders a, b & c. I want to create a dtml document in a folder by a form. The folder is a variable in my form. The formis no problem, the form action is no problem. The python script to craete that document is my problem. How can I create a DTM Document in a variable container ? Regards, Martin Koekenberg

6 6

Re: PHPGateway Issues
by Asad Habib 01 Dec '05

01 Dec '05

Hello Wei. Okay, please keep me posted when you determine what the problem is. If anyone else on the Zope group has experienced a similar problem, please let me know. Thanks. On Thu, 1 Dec 2005, Wei He wrote: > Quoting Asad Habib <ahabib(a)engin.umich.edu>: > >> Hello. The message came from Mac OS X. Also, how do I resolve this issue? >> I am currently also running phpMyAdmin so I know for a fact the PHP-CGI is >> present. Also, PHP is currently running on its own (i.e. not behind >> Apache). > > It looks like I'll have to get a Mac OS X box to find out how PHP is running on > it. > Will take some time. > > Best, > > -- > Wei He > IT Manager > IED (Institute for Environment & Development) > Tel: +86-10-51319216 > Web: http://www.ied.org.cn > > >

1 1

dtml2zpt
by Infor Gates 01 Dec '05

01 Dec '05

Dear zopist I am trying to pick up zpt. Is there an equivalent command in zpt for <dtml-call RESPONSE.redirect('home_page'). Thank you. __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/

3 3