- Zope - Zope lists

Object editing in ZODB
by Frank Stephan 04 Sep '01

04 Sep '01

Hi, I would like to know if it is possible to edit object in ZOBD like I can in MySQL or do I have to write my own forms to do that? TIA Frank

2 1

postgres logging Re: [Zope] GUF & SQL login problems
by Lee Harr 04 Sep '01

04 Sep '01

> > can't you just get your SQL-backend to log/print out the SQL-queries it > > gets from your GUF? This is what once helped me to figure out a similar > > problem with loginmanager. > >Is it possible with PostgresQL? > Check out the -d switch to postgres and postmaster. You will probably want to add something like: -o -d 1 to the command you use to start postmaster. That will pass the debug switch through from the postmaster to every backend postgres process started. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

3 3

Addresses for book winners
by Michel Pelletier 04 Sep '01

04 Sep '01

Hi folks, a long time ago, I announced the following book winners: o "jimbo" o M. Adam Kendall o Jason Cunliffe o Lalo Martins o Jochen Knuth o Holger Hoffmann o "Bak@kedai" o Magnus Heino In order to save me the time of individually contacting each of you, I'd like those of you on this list to please send me your postal address so Amos and I can send you a signed book! Those of you who I don't hear from soon I'll have to track down... -Michel

1 0

Re: [Zope] Two questions about passing lists to sql methods
by Oliver Bleutgen 04 Sep '01

04 Sep '01

> I wrote something like this > select * from table > where <dtml-in "('a', 'b', 'c')"> > <dtml-let temp=sequence-item> > colum like <dtml-sqlvar "'%' + _.string.strip(temp) + '%'" > type=string> or > </dtml-let> > <dtml-if sequence-end> > 1=2 > </dtml-if> > </dtml-in> > This worked fine, but when I replaced <dtml-in "('a', 'b', 'c')"> with > <dtml-in keyWords> and call this method from another page as <dtml-var > expr="sqlMethod(keyWords=('a', 'b', 'c'))">, nothing returns. Why? I then > try to pass a list directly using test feature, but no matter what I input > it always tell me 'no string allowed in the dtml-in function'. What did I > do wrong? Hi Jeff, can't tell you what prevents your method from doing what you want, but I can tell you what I did what worked in a similar situation. I use a python script to build the query string and just call that method via dtml-var, i.e. select * from table where <dtml-var my_script> the script looks like for s in context.REQUEST['my_dict']: query = query + "column LIKE '%" + s + "%'\n OR \n" query = query + '1=2' return query Just make sure that all the variables you need are in REQUEST. Maybe someone else has a more elegant or cleaner way of doing things. cheers, oliver PS: nice trick with that 1=2, tho

1 0

Two questions about passing lists to sql methods
by Jeff Huang 04 Sep '01

04 Sep '01

I wrote something like this select * from table where <dtml-in "('a', 'b', 'c')"> <dtml-let temp=sequence-item> colum like <dtml-sqlvar "'%' + _.string.strip(temp) + '%'" type=string> or </dtml-let> <dtml-if sequence-end> 1=2 </dtml-if> </dtml-in> This worked fine, but when I replaced <dtml-in "('a', 'b', 'c')"> with <dtml-in keyWords> and call this method from another page as <dtml-var expr="sqlMethod(keyWords=('a', 'b', 'c'))">, nothing returns. Why? I then try to pass a list directly using test feature, but no matter what I input it always tell me 'no string allowed in the dtml-in function'. What did I do wrong? Jeff _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

1 0

Fw: [Zope] Can not add photofolder programmatically
by Robert Rottermann 04 Sep '01

04 Sep '01

----- Original Message ----- From: "Robert Rottermann" <robert(a)redcor.ch> To: "Andy McKay" <andym(a)ActiveState.com> Sent: Tuesday, September 04, 2001 6:48 PM Subject: Re: [Zope] Can not add photofolder programmatically > Thanks for your answer, > > The extra space was "generated when I wrote the mail > The PohtoFolders mety type is "Photo Folder". I did try that also but it did > not help.. > > I have the same Problem when I try to > context.manage_addProduct['Image'].manage_addImage(.. > but in this case I can use > context..manage_addImage( > > So I really do not understand the mechanics at work > > Robert > > ----- Original Message ----- > From: "Andy McKay" <andym(a)ActiveState.com> > To: "Robert Rottermann" <robert(a)redcor.ch>; <zope(a)zope.org> > Sent: Tuesday, September 04, 2001 6:17 PM > Subject: Re: [Zope] Can not add photofolder programmatically > > > > > context.manage_addProduct['PhotoFolder ']... > > > > Could be the space on the end of "PhotoFolder " in your line. Or you could > > have the wrong meta_type, what is the meta_type of PhotoFolder? (it may > not > > be what you think) > > > > Cheers. > > -- > > Andy McKay. > > > > > > _______________________________________________ > > 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

Zope User Group Switzerland Kick-Off Powhow
by info＠zope.ch 04 Sep '01

04 Sep '01

The Zope User Group Switzerland proudly annouces its first public event: The Kick-Off Powhow in Zürich. On Thursday, 13. September 2001 we welcome any Zopista that feel like dropping by. Please drop us a line at info(a)zope.ch if you plan to show up. For details see: http://www.zope.ch Grégoire Weber and Gidon Friedman

1 0

ZOracleDA-beta5 problem; possible bug running NT
by Stig-Arne Nordin 04 Sep '01

04 Sep '01

Hello, I'm running; Zope 2.3.2 (binary release, python 1.5.2, win32-x86) Yesterday i installed ZoracleDA-beta5 after having run the alfa5 for some time. After installing the update I noticed that things were not what they should or even used to be. Problem one. This was there with the alfa-version. If you encounter a null value in the datbase zope returns the value None under NT. At least if it is an integer field. I tried to work around this by using NVL(field,0) where field is an integer. When the database value is null zope responds 0.0 under NT! Performing the same trick direcly in the Oracle DB and the answer is 0 like it should be. OK, so I try a simple workaround by using ROUND(NVL(field,0),0) which should give the answer 0. The answer is still 0.0, in addition all non-null values gets a decimal ending! Some time ago i fiddled with an zope-on-linux installation where the null value provide by zope was 0. Solutions, explanations or workarounds anyone? Problem two. New with beta5!!! Integer field value changed from 12108 to 12108L. This happens for some of of my integer fields but not for all. Is there anyone out there who knows of a solution or has seen this behavior before. -- Stig-Arne Nordin Fysik och teknisk fysik CHALMERS | Göteborgs Universitet

5 7

.info landrush - pre-register now
by djones＠markmonitor.com 04 Sep '01

04 Sep '01

Subject: .info Landrush Markmonitor, the worldwide leader in Internet intellectual property protection, is now accepting pre-registrations for the .info landrush period (September 12 -19). To date, Markmonitor has successfully registered over 92% of .info names requested by its customers. For more information and to set up an account, visit Markmonitor's Domain Solution Center at www.markmonitor.com today. In addition to registering your .info domain names, Markmonitor's Domain Solution Center can accommodate all of your domain registration needs, including: 1. High volume registration, in all gTLDs and over 150 ccTLDs 2. Global Domain Name Management (DNS, contact information) 3. Reporting 4. Renewal Management 5. Transfers and account consolidation Our Domain Solution Center is designed specifically to provide reliable and efficient domain registration and management tools for companies and law firms that register and manage large volumes of domain names. To arrange a complete demo of our Domain Solution Center, please e-mail us at custserv(a)markmonitor.com or call us at (800) 337-7520. To be removed from future e-mails from Markmonitor, please respond to custremove(a)markmonitor.com.

1 0

is zope a solution?
by tonyl＠vextech.net 04 Sep '01

04 Sep '01

Hi, I've recently discovered zope and have the feeling that it may be the solution to a pending application issue. However, I've worked through the tutorial and I guess I'm no wiser than before, and it didn't really convince me either way; possibly leading me to believe it's aimed at small site solutions. Anyway, I have a project that will need to allow around 10,000 users (or less) to access at least a million documents. Each user is grouped into one of a small handful of access levels (determined by cookies). The documents are pre-existing PDFs, spreadsheet et al. I.e. they're all static. A solution along the lines of a standard cgi based bespoke application isn't particularly taxing from a programming point of view, but clearly wouldn't offer what I believe to be the potential of zope with it's prebuilt goodies. So, I'm wondering whether zope is up to the task (reliability and scalability), or whether I'm misunderstanding something. Any observations would be most welcome. Thanks, Tony

10 16