October 2000 - Zope - Zope lists

Variable name use in with statement
by Burchill, Scott B. 13 Oct '00

13 Oct '00

I'm working on a simple auction site as a newbe challenge. I am taking bids on three static items, none will be added or removed. I have a folder named bid_records in which there is a folder for each item. These item folders have current bid information in properties and bid history in ZClass items stored in them. When I'm working with a specific auction item I have the name of the folder in a REQUEST variable. I am finding myself doing the following and am sure there is a simpler way to do this. Any help would be greatly appreciated! Thanks. <dtml-with bid_records> <dtml-if "_.str(REQUEST.form['selection']) == 'walkon'"> <dtml-with walkon> <dtml-call "REQUEST.set('cur_bidder', bidder)"> </dtml-with> <dtml-elif "_.str(REQUEST.form['selection']) == 'fullhouse'"> <dtml-with fullhouse> <dtml-call "REQUEST.set('cur_bidder', bidder)"> </dtml-with> <dtml-else> <dtml-with snoopy> <dtml-call "REQUEST.set('cur_bidder', bidder)"> </dtml-with> </dtml-if> </dtml-with> -- Scott B. Burchill, MIS Manager Ordway Center for the Performing Arts 345 Washington Street St. Paul, MN 55102-1495 voice +1 (651) 282-3082 cell +1 (651) 248-2713 pager +1 (612) 818-7600 fax +1 (651) 224-1820 efax +1 (508) 519-6133 http://www.ordway.org \:)> /:(>

1 0

Re: [Zope] dtml-sqltest and capital column names
by Oliver Bleutgen 13 Oct '00

13 Oct '00

Talking to myself .... A slight correction to my patch so that tablename.columname will be rendered as to "tablename"."columnname". 146c146 < from string import find, split, join, atoi, atof --- > from string import find, split, join, atoi, atof, replace 165,166c165,166 < if has_key('column'): self.column=args['column'] < else: self.column=self.__name__ --- > if has_key('column'): self.column='"'+replace(args['column'], '.', '"."')+'"' > else: self.column='"'+replace(self.__name__, '.', '"."')+'"' It would be nice if someone could comment whether this makes sense for other dbs too. cheers, oliver

1 0

Re: [Zope] How to see if two objects are the same (minor fix)
by Tres Seaver 13 Oct '00

13 Oct '00

Ron Bickers <rbickers(a)logicetc.com> wrote: > > **** From my previous post, it looked like the parent was changing. I had > the first two lines swapped. Fixed below. > > ---- > > I want to see if an object is the one aqcuired from the root, but I'm > hitting walls. > > <dtml-var "PARENTS[-1].myObject"> > <dtml-var "myObject"> > <dtml-var "PARENTS[-1].myObject is myObject"> > > This returns the following when in the root folder context: > > <TinyTable instance at 8684ad8> > <TinyTable instance at 8684ad8> > 0 > > It returns the following in a folder where there is another myObject: > > <TinyTable instance at 8684ad8> > <TinyTable instance at 86709f8> > 0 > > What am I missing in the comparison? You are seeing the result of a (mis)feature of acquisition: the objects you are comparing are actually AcquisitionImplicitWrappers around the real 'myObject'; because the two wrappers are different, and because the underlying object doesn't define a custom '__cmp__()' method, the two wrappers are compared for identity (which is bogus). I recently fixed this in response to a Collector issue: http://classic.zope.org:8080/Collector/1650/view You can get the patch from that page, or just wait for Zope 2.3 (RSN, I'm sure). Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

1 0

Re: [Zope] Fw: mysqldb
by jensebaer 13 Oct '00

13 Oct '00

----- Original Message ----- From: "jensebaer" <jensebaer(a)hotmail.com> To: "Dale Lance" <DLANCE(a)kc.rr.com> Sent: Friday, October 13, 2000 2:43 PM Subject: Re: [Zope] Fw: mysqldb > Hi Dale, > > put this in your setup or/and setup.in file under > ....../lib/python/Products/ZMySQLDA/MySQLdb-0.1.2/ > > *shared* > # Only one line should be uncommented. > # Adjust -L and -I as necessary for your local configuration. > # If you have dynamic MySQL libraries, they will need to be on your > # LD_LIBRARY_PATH at runtime. > _mysql _mysqlmodule.c -L/usr/lib/mysql -I/usr/include/mysql -lmysqlclient > # Uncomment for Windows > #_mysql > _mysqlmodule.c -L/mysql/lib/opt -I/mysql/include -lmysqlclient -lwsock32 > > > or may _mysql > _mysqlmodule.c -L/usr/local/lib/mysql -I/usr/local/include/mysql -lmysqlclie > nt > > Jens > > ----- Original Message ----- > From: "Dale Lance" <DLANCE(a)kc.rr.com> > To: <zope(a)zope.org> > Sent: Friday, October 13, 2000 1:59 PM > Subject: [Zope] Fw: mysqldb > > > > Hi, > > I am trying to build ZMySQLDA 1.20 > > mysql has been built successfully on RedHat 7.0 and resides in > > /usr/local/mysql > > I have followed the instructions for editing /etc/ld/so/conf adding > > /usr/local/mysql/lib/mysql > > /usr/local/mysql/lib > > /usr/local/mysql > > to it. (just tomake sure) > > yet I still get the following error > > anyone know where mysqlclient is supposed to be? > > > > Dale > > > > > > > gcc -shared _mysqlmodule.o -L/usr/local/mysql/lib -lmysqlclient -o > > > _mysqlmodule.so > > > /usr/bin/ld: cannot find -lmysqlclient > > > collect2: ld returned 1 exit status > > > make: *** [_mysqlmodule.so] Error 1 > > > Traceback (innermost last): > > > File "build.py", line 14, in ? > > > import MySQLdb > > > File "MySQLdb.py", line 19, in ? > > > from _mysql import * > > > ImportError: No module named _mysql > > > > > > > > > > > > > > _______________________________________________ > > 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 ) > > > > >

1 0

DTML Acquisition & NameSpace Help Needed.....
by J Kinsley 13 Oct '00

13 Oct '00

I am building a framed site using Zope and I am trying to get functionality that after hours of reading documentation I am beginning to think is not possible, but since what I have read is so obscure I have decided to post a message before giving up. The code examples below *DO NOT* work, but are being used in an attempt to illustrate what I am attempting to do as I thought it would work. After reading documentation for the last several hours I am now more confused then when I started. Given the following URL's: http://...../Files/?dir=/foo/bar/&file=baz.html http://...../?section=/Files&dir=/foo/bar/&file=baz.html And the Following /index_html - DTML Method .... <dtml-var FrameSet> .... /FrameSet - DTML Method .... XXX - How can I negate this? IE. <dtml-if "not section"> <dtml-if section> <dtml-else> <dtml-call "REQUEST.set('section', '/ViewFrame')"> </dtml-if section> XXX - I do not think calling REQUEST.set() is the best way to accomplish this. What is a better way? <dtml-call "REQUEST.set('topframe', '1')"> <frameset rows="60,75,*"> <frame name="title_frame" src="&dtml-absolute_url;/TitleFrame"> <frame name="banner_frame" src="&dtml-absolute_url;/BannerFrame"> <frame name="view_frame" src="&dtml-absolute_url;&dtml-section;"> </frameset> .... /ViewFrame - DTML Method .... <frameset rows="60,75,*"> <frame name="menu_frame" src="&dtml-absolute_url;/MenuFrame"> <frame name="main_frame" src="&dtml-absolute_url;/MainFrame"> </frameset> .... XXX - I can not get this to work at all. Topframe should be set or true if the visitor arrived in the /Files Folder from the top level frameset and /Files/ViewFrame will be loaded into the view_frame target. If the visitor came directly to /Files and topframe is unset or false, then I want to redirect them back to the toplevel /FrameSet to load the top frames then display the /Files/ViewFrame in the view_frame target and pass along dir and file from the URL query string. /Files/Index - DTML Method .... <dtml-if topframe> <dtml-var ViewFrame> <dtml-else> <dtml-var "FrameSet(section=/Files)"> </dtml-if topframe> .... XXX - If this method is called from the top level FrameSet method, how to I access dir and file from the original request? /Files/ViewFrame - DTML Method .... <frameset rows="60,75,*"> <frame name="menu_frame" src="&dtml-absolute_url;/MenuFrame?dir=&dtml-dir;"> <frame name="main_frame" src="&dtml-absolute_url;/MainFrame?dir=&dtml-dir;&file=&dtml-file;"> <frame name="navbar_frame" src="&dtml-absolute_url;/NavBarFrame?dir=&dtml-dir;"> </frameset> .... Over the last few days I have tried all sorts of things to make this work, but all attempts have failed. I am sure there is a very simple solution that one of you Zope Gurus could quickly explain. If you are going to respond with RTFM, the please cite specific references in the manual. ;-) Thanks in advance. Regards, Jarrod Kinsley

1 0

<dtml-if> and <dtml-var> question
by complaw＠hal-pc.org 13 Oct '00

13 Oct '00

First, thanks for the help these last several days. I'm glad to report that I have a useful Zope site up and running that is the envy of the law firm. Now its time to get a little fancy. Unfortunately, after having read the DTML Reference, and the Zope Quick Reference, I still haven't been able to figure out how to get today's date into a dtml-var. Case in point: I want to put a table of dates and hyperlinks. If the day has already passed, I want to shade the table cell (<td bgcolor="gray">). In this case, the object has a date property called event_date. <table> <tr> <dtml-if expr="event_date < DateTime()"> <td bgcolor="gray"> <dtml-else> <td bgcolor="white"> </dtml-if> </td> </table> The above code gives me a NameError. Another example would be to simply get the integer value of the year so that it can be included in a copyright statement. E.g., Copyright © <dtml-var Year()>, All rights reserved. Unfortunately, this doesn't work either. Can someone point me in the right direction?

2 1

Zope nominated for Webtechniques Web Tools Awards
by Martijn Pieters 13 Oct '00

13 Oct '00

Zope has been nominated for the Webtechniques Webtool Awards, and the pollboxes are open! Go vote by putting you email address (or any email address you like ;)) at the end of the following URL: http://www.webreview2.com/cgi-bin/poll/ballot_gen.pl?<your(a)email.com> So, I voted at the URL ending in ballot_gen.pl?mj(a)digicool.com. Every email address can vote once. Go give Zope a great showing! -- Martijn Pieters | Software Engineer mailto:mj@digicool.com | Digital Creations http://www.digicool.com/ | Creators of Zope http://www.zope.org/ ---------------------------------------------

1 0

OT: maybe - max file, proc limits on linux and zope
by Bak ＠ kedai 13 Oct '00

13 Oct '00

hi all, this may be off topic, feel free to ignore. while trying to stop zope i encountered error stating max file limit met. what i did to stop this is running echo "8192" >/proc/sys/fs/file-max can i do this? good bad? any tips on tuning max file open, process open, etc? linux and zope newbie <--that's me. tia -- http://www.kedai.com.my/kk http://www.kedai.com.my/eZine Get the tables!

1 0

Re: [Zope] Connection Problem with Oracle
by Ayhan Ergul 13 Oct '00

13 Oct '00

> I created a connection to an Oracle database. Frequently, > the connection breaks and I got a database error in the page that > displays the query result. When I logon as a manager I find that the > connection is closed (by itself, nothing changed in Oracle or Zope), > when I try to open it I get an error "Invalid connection string". Even > if I create another connection it can't work.. After a while it > works. Even after restarting the Zope server the problem persists. I'm not sure why the same connection string would work only some of the time. Maybe some other error from sqlnet is misreported. In any case, look for sqlnet.log at the directory where zope was started. You can get more info on the errors you're experiencing. Furthermore try running zope with nohup and monitor the nohup.out file that gets generated. You can see how frequently your zope goes down (if running as deamon under linux). Frequent problems with Oracle setup stem from read permissions on files used by sqlnet (e.g. message files). Make sure such files are readable by whatever user your zope is running as. Ayhan Ergul <ergul(a)acm.org>

1 0

non-Zope object attribute admin interface
by "Geoffrey L. Wright" <Geoffrey L. Wright 13 Oct '00

13 Oct '00

Kindly Zopistas: Am curious how to go about building an "alternate Property Sheet View" for custom ZClasses. The default view is great for me and other developers, but I need to build the something that looks a bit more customer-friendly. I spend about 20 minutes looking around the Zope site, but haven't yet turned about any useful information. Perhaps somebody could point me to a relevant HOWTO or some example code? Many thanks! //glw

2 1