- Zope - Zope lists

Passing multi-line field into SQL
by Tony Mann 23 May '00

23 May '00

We have a form with a textarea on it, that can contain line breaks. When we try to pass it into an SQL statement <dtml-sqlvar textarea_value type=string> we get a parsing error, due to the embedded newlines. We would like to convert the newlines to "<BR>" strings. Does anyone have an easy solution for doing this? We have tried using split/dtml-in and split/join in the SQL, but getting these statements past the SQL parser, with all the quotes, has proven to be tricky. ..tony..

2 1

Re: [Zope] Win98 and WEBDAV - you ought to see it if you can
by Rik Hoekstra 23 May '00

23 May '00

>When I try to "Add a Web Folder" on Win98 I get a 404 error on the resource >_vti_bin both on my own web sites and on www.zope.org. Any idea why or what >is _vti_bin? > Yes, it is (one of the) the dreaded Frontpage extension(s). Why you would get it and someone else wouldn't ... I don't know. Perhaps you have MS products that use FP extensions (Frontpage, Interdev, whatever) installed? Rik

2 1

<dtml-in REQUEST>
by kwan 23 May '00

23 May '00

I remember I saw somewhere about it. but I couldn't search it out again. Can anyone tell me the correct way to do things like following? <dtml-in REQUEST> <dtlm-var "key">:<dtml-var "value"> </dtml> I want to check the indivial item inside the REQUEST one time at a time. but if I do <dtml-in REQUEST> I think it is not actually a list so that it is usable by dtml-in tag Kwan

2 1

Switch, Attribution and NT
by peter 23 May '00

23 May '00

Q1. Q1 {A} -------------------------------------------------------- Is it possible to rewrite the following piece of DTML into something easier and managable? <dtml-if "_.string.split(URL,'/')[-1]=='foobar_html'"> Cool! You are viewing foobar_html <dtml-elif "_.string.split(URL,'/')[-1]=='barfoo_html'"> More cool! You are viewing barfoo_html <dtml-elif ... <dtml-elif ... </dtml-if> This is supposed to be in the standard_html_header, and I now wonder if it is possible to write an switch or case statement for this. Q1 {B} -------------------------------------------------------- How do you write an AND and OR in an IF-statement? I have tried this: <dtml-if "_.string.split(URL,'/')[-2]=='pornfolder' OR/AND _.string.split(URL,'/')[-2]=='murder_todolist_folder'"> You are viewing the pornfolder AND/OR the murder_todolist_folder!! </dtml-if> ...but that does not work. I would also like to use something like this: "...=='pornfolder' OR/AND 'murder_todolist_folder'" Ideas? Tips? Q2 -------------------------------------------------------- How do you change the source to the Attribution button in the standard_html_footer? Q3 -------------------------------------------------------- When I installed Zope on my NT I installed it as a service (i.e. that it autostarts). Now, for some reason it does not autostart; which is what I want. How do I fix that? If I reinstall Zope, will my installed products and objects (can be export-/imported) be deleted? Thank you for you advice ladies and gentlemen!

2 1

FYI: Zope Weekly News
by Mike Pelletier 23 May '00

23 May '00

G'day, Zope Weekly News is a digest of some of the useful and interesting events which have occurred on the various Zope mailing lists and the Zope.org site. It is published each Wednesday evening. New Products and Announcements * Paul Everitt announces Sybase support in a joint press release. http://lists.zope.org/pipermail/zope/1999-November/013946.html http://www.digicool.com/News/Sybase * "Zen" released ZRadius, a product which allows you to authenticate web users via the Radius authentication protocol. http://www.zope.org/Members/Zen/ZRadius * Anthony Pfrunder announces VisualZope 0.1a. From his web page: Basically, the "goal" of VZ is to provide a SIMPLE visual editing system for graphic designers which works cross-browser and takes advantage of the acquisition and role systems within Zope. What follows is a brief description of the components which make up the final VZ system (probably more accurate than previous posts). http://163.182.196.200/zwiki/VisualZope * Jeff Sheldon has started a weblog of his experiences with Zope. Jeff Sheldon is new to Zope, and is not a professional programmer. His weblog is a valuable resource to those also starting out with Zope. http://weblogs.userland.com/zopeNewbies/stories/storyReader$0 Updates * Zope 2.1.0 beta 2 has been released. This release includes fixes for issues found in beta 1, an updated load_site.py script and Martijn Pieters' patches to implement try/except/else and try/finally in DTML. Unless something major comes up, this will be the final beta before 2.1.0 final. http://www.zope.org/Products/Zope/2.1.0b2/ * "4am" has submitted an update to his PythonMethod product. It allows methods, written in Python, to be created via the Zope web management interface. http://www.zope.org/Members/4am/PythonMethod * "Drew" contributed an update to his Photo product. It generates thumbnail views of images at the user's preferred size. Requires PIL. http://www.zope.org/Members/Drew/Photo * Itamar Shtull-Trauring announced ZCache v0.2. ZCache is a Python Product which allows you to cache expensive methods, taking strain off your server. It also generates 'Last-Modified' headers, aiding browser and proxy caches. http://lists.zope.org/pipermail/zope/1999-November/014115.html http://www.zope.org/Members/itamar/ZCache Zope.org items * "Zen" submitted a tip he picked up from Michel Pelletier. He explains how volatile attributes work, and how to populate them when your object is loaded from the database. Volatile attributes are attributes which do not get written to the database, and are good for data which changes frequently. http://www.zope.org/Members/Zen/tips/VolatileAttributes * "AlexR" submitted a How-To detailing the use of the DTML entity syntax. "DTML entities" are chunks of DTML which look like this: "&dtml-title_or_id;" http://www.zope.org/Members/AlexR/EntitySyntax Notable Discussions * DTML is a HUGE topic this week. Discussions spill across several lists. A very good job is done of identifying DTML's weak points. Many hold that the difficulty in using DTML comes from it's roots as a reporting language-- it isn't supposed to be used for logic. The problem is, there isn't yet an easy replacement for DTML as a programming language. Python Methods are cited as an excellent start on providing a means of moving logic out of DTML. Christopher Petrilli mentions that DC is looking at grooming Python Methods for inclusion in Zope. Others feel that reporting vs. programming is a forced distinction, and that it is awkward to have to use two different solutions. The claim that generating HTML is actually a rather complex task, and the powerful but ugly features of DTML are a necessary evil. DTML is compared to Perl! <gasp!> Otherwise, lots of very useful tips for using DTML are revealed. An excellent read for DTML beginners and wizards alike. http://lists.zope.org/pipermail/zope/1999-November/013710.html http://lists.zope.org/pipermail/zope-dev/1999-November/002088.html http://lists.zope.org/pipermail/zope-dev/1999-November/002102.html * Darcy Clark alerts the list of Jon Udell's latest article mentioning Zope. Jon's article discusses the ease of using Zope with Windows databases, the pain of using it with Unix databases, cheers ODBC, and jeers lack of a similar magic bullet for Unix. The thread then continues to discuss the relative merits of various free databases and using them with Zope. http://www.byte.com/column/BYT19991104S0001 http://lists.zope.org/pipermail/zope/1999-November/013711.html Also, Karl Fast does an excellent job of summarising the thread, generating more sage comments. http://lists.zope.org/pipermail/zope/1999-November/013762.html http://lists.zope.org/pipermail/zope/1999-November/013812.html http://lists.zope.org/pipermail/zope/1999-November/013813.html http://lists.zope.org/pipermail/zope/1999-November/013840.html * Francois-Regis CHALAOUX posed a question about using Zope with virtual hosting. Several useful responses were generated. http://lists.zope.org/pipermail/zope/1999-November/013678.html http://lists.zope.org/pipermail/zope/1999-November/013688.html * Ben Galbraith submitted a comparison of Zope and Cold Fusion and solicited comments. Some of the usual suspects offer theirs. http://lists.zope.org/pipermail/zope/1999-November/013730.html * Otto Hammersmith started a thread about Zope and security. In it, he speaks of some of the security pitfalls that unsuspecting Zope users could experience. Brian Lloyd submits some solutions. http://lists.zope.org/pipermail/zope/1999-November/013779.html * Paul Everitt wrote in to remind us that there is a zope-dev(a)zope.org list for technical discussions. A brisk discussion developed to debate what constituted a technical discussion. http://lists.zope.org/pipermail/zope/1999-November/013796.html * Theodore Patrick launched a lengthy thread with questions about the effect of threading in Zope. A number of folks from Digital Creations provide answers. The discussion moves on with high volume and content to the topics of benchmarking and performance tuning Zope. http://lists.zope.org/pipermail/zope/1999-November/013808.html * Farzad Farid revives the uncacheable image thread. Because Acquisition can lead to different URLs being generated for images when viewed from different locations, it makes caching difficult and can generate excessive traffic. Others offer advice to solve this problem. http://lists.zope.org/pipermail/zope/1999-November/014021.html * David Harrison asks zope-dev how to return an image generated on-the-fly by an External Method. Answers found. http://lists.zope.org/pipermail/zope-dev/1999-November/002107.html Mike Pelletier

2 2

Variable which delivers the author of an document
by Stefan Pöhnlein 23 May '00

23 May '00

I would like to know,if there is a Variable, which delivers as value the author of a document, similiar to "AUTHENTICATED_USER", which delivers the user name. I couldn't find anything about it in the Zope DTML Reference. Thanks a lot in advance, Stefan

1 0

ZMySQLDA fails to compile
by David Parker 23 May '00

23 May '00

Configuration: Mandrake 7.02 with the following; Zope 2.1.6-1 python 1.5.2 MySQL-python 0.2.1-1 Mysql 3.22.32 All the above were installed using binary RPMs except for Mysql database. The path to mysql is /usr/web/databases/mysql I have a symbolic link to mysql at /usr/local/mysql I've downloaded and extracted ZMySQLDA 1.1.4 to /usr/share/zope >From the following location /usr/share/zope/lib/python/Products/ZMySQLDA/src I've executed make -f Makefile.pre.in boot make (I've tried editing Setup using the default and following two paths) # MySQLmodule MySQLmodule.c -I/usr/local/mysql/include -I/usr/include/mysql -L/u sr/local/mysql/lib -L/usr/lib/mysql -lmysqlclient -lm # MySQLmodule MySQLmodule.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -l mysqlclient -lm MySQLmodule MySQLmodule.c -I/usr/web/databases/mysql/include -L/usr/web/database s/mysql/lib -lmysqlclient -lm I get the following error every time... (mysql.h exists at /usr/web/databases/mysql/include/mysql/mysql.h) [root@davweb src]# make gcc -fPIC -I/usr/local/mysql/include -O3 -fomit-frame-pointer -fno-exceptions - fno-rtti -pipe -s -mpentium -mcpu=pentium -march=pentium -ffast-math -fexpensive -optimizations -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./MySQLmodule.c ./MySQLmodule.c:160: mysql.h: No such file or directory ./MySQLmodule.c:166: parse error before `MYSQL' ./MySQLmodule.c:166: warning: no semicolon at end of struct or union ./MySQLmodule.c:167: warning: data definition has no type or storage class ./MySQLmodule.c:170: parse error before `}' ./MySQLmodule.c:170: warning: data definition has no type or storage class ./MySQLmodule.c:174: parse error before `MYSQL_RES' continues............

1 1

Multiple ZEO Storage Servers, as Mountable Databases? (was FYI: Thank you) FYI: Thank you)
by Jerry Spicklemire 23 May '00

23 May '00

Alan Runyan asked: >just out of curiosity - can a ZEO StorageServer now have multiple ZODB's? Another way to look at this, with Mountable Databases, is that you can run two ZEO StorageServers. Then the question is, can the ZEO Clients refer to both at once, in the form of Mountable Databases? If the the ZEO access is truly transparent to the client Zope, the result should be ZEO Client access to multiple ZODBs, and would have the pleasant side effect of distributing load on the ZEO StorageServers. This is getting exciting! Later, Jerry S.

1 0

(fwd) Re: [Zope] DTML Document size limit?
by Andrew Diller 23 May '00

23 May '00

Hi Andrew, as discussed earlyer, there is no hard coded limit in the size of the files (ok, you might not go over 2GB per file) Althought its usually not nessecary to edit such big files. Use inheritance, reuseable code and part your document into smaller pieces. This is what Zope is for. I can't split it up, but it _is_ the browser screwing around. I uploaded the file directly into zope and if I view it its ok, but attempting to edit it, the text area window is limited to 100k in IE 5 for macintosh. -andy

1 0

Zope concepts
by Tom Smith 23 May '00

23 May '00

Hi all, This is a conceptual rather than technical question.... I intend to build an intranet with zope...though it's not as simple as that...I'd like 90% of the site to be password protected (giving access to members of my company)...do I use acl_users for this? I'd also like parts of the site to be accessible (and maybe manageable albeit minimally) by clients....Do I have to create a second user/access model for this or can I use the acl_users to do this for me too. I'm having problems a. Making the acl_user stuff work...I can either login as admin or not all. and b. Getting to grips with the concept of the user/privs/access model in acl_users So the question is this...do I/can I use acl_users to manage all my authentication requirements, only allowing certain clients to view certain areas of the site...allowing company members to edit and view all of the site etc..if so then I'll slog on experimenting with the acl_users stuff... thanks tom

4 3