- Zope - Zope lists

Simple ZSQL question -- variable expansion in dtml-if?
by J C Lawrence 11 Jan '00

11 Jan '00

I'm attempting to write a ZSQL method which has the following behaviour (the exact case below is a little more detailed): When the passed X parameter is 1 it issues the following SQL: SELECT * FROM table WHERE col=1 When X parameter is 0: SELECT * FROM table And when X is -1: SELECT * FROM table WHERE col=0 My attempted ZSQL is below (a little more complicated that the above). CatParent and Approved are passed in arguments to the method: SELECT * FROM Categories <dtml-sqlgroup where> <dtml-sqltest CatParent type=int> <dtml-and> <dtml-if expr="Approved == 1"> <dtml-sqltest Approved type=int> </dtml-if> <dtml-if "Approved == -1"> Approved=0 </dtml-if> </dtml-sqlgroup> ORDER BY CatName The problem is that the "Approved" variable in the dtml-if clauses does not appear to be getting expanded to its value. It doesn't improve if I replace it with "_['Approved']". What am I missing? While I'm new to Zope I *think* that should work per what I've read. Instead for all values of Approved I get: SELECT * FROM Categories WHERE CatParent=### ORDER BY CATNAME and Approved never gets mentioned. Is there a way to accomplish the above within a single ZSQL method, or must I break it out? -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

2 1

Rif: RE: [Zope] JScript objects
by cesare＠planningsrl.it 11 Jan '00

11 Jan '00

>Including JScript/JavaScript code in DTML documents/methods works. What >does the script look like and what is the surrounding HTML/DTML? Sorry for the delay in the answer but I have been out few days. The script look like this: <script language=JavaScript> function ds_onChange() { var ga; var flag; // Cycle through action lists for the select this.actionManager.executeActions(this.currentList, this.options[this.selectedIndex].text); // loop through all groups for(var g in dsm.groups) { ga = dsm.groups[g].split(","); flag = false for(var i=0; i < ga.length; i++) { if(ga[i] == this.alias) flag = true; else if(flag) { var s = dsm.dynamicSelects[ga[i]]; s.actionManager.executeActions(s.currentList, s.options[s.selectedIndex].text); } } } } .....some other jscript functions...... </script> I declared a dtml-method CreaJScriptInserimentoAnnuncio wich contains the jscript code. Then i called the <dtml-call CreaJScriptInserimentoAnnuncio> in my dtml-method containing some othe dtml and html code. What made I wrong? Thank you, Cesare Cesare Raoss Planning srl Via Bolzano 45 38014 Gardolo (TN) cesare(a)planningsrl.it http://www.planningsrl.it

2 1

RE: [Zope] Zope capabilities
by Rob Page 11 Jan '00

11 Jan '00

Hi Bill: Bill Barnes wrote: > My plan for my manufacturing client of 10-20 nodes was to > use Linux as a server to Applixware clients coupled to Sybase. > Am I to understand that I can use Zope to put an extensive library of > applications (accounting, order entry, inventory, etc) > on my website that will be available to my client's enterprise, and, > better yet, available to other clients, as well. Yes.. of course, you'll have to develop these applications! :^) If I read this correctly it sounds like you want to be a mini-ASP (Application Service Provider). There is a lot of activity (marketing and real :^) in this area now! > What about performance? Will the database be on my client's hardware > or on my website? Reviewing the installations list, I didn't see anything that > approached enterprise class operations. Is the system that robust? The client need only be a web browser. The database (ZODB) is colocated with the Zope server process. It's likely in a manufacturing scenario that you'll be integrating relational data as well (e.g., from Oracle/Sybase). The RDBMS server can run on any machine -- though for obvious reasons it should be topologically close to the Zope server. Performance is a hard thing to measure because of all of the variance in testing methodologies. So, take the following with a grain of salt. "Moderately" complicated Zope apps can do ~1M hits per day on garden variety hardware (P3 450). More hardware usually means more hits. With respect to enterprise class applications -- we (Digital Creations) have developed an app for a customer that they use to publish inventory and backorder levels from a 9TB (yes, TB) Oracle inventory and parts database worldwide. It's been up for over two years. However, there are a lot of folks on this list that are running their entire businesses on Zope. Regards, --Rob

1 0

ZDP ANNOUNCEMENT
by Tom Deprez 11 Jan '00

11 Jan '00

Weekly news at ZDP updated.

1 0

RE: [Zope] Anyone using Zope Mail Host with MS Exchange ?
by Rob Page 11 Jan '00

11 Jan '00

> I have a client reporting that mail sent from Zope > using a MS Exchange box as their Zope Mail Host > never arrives. The forms themselves are known not > to be at fault since we have previously tested them > using a Zope Mail Host defined on a unix box (running > QMail). I can test the forms from remote as an end > user and they seem to submit properly - so the mail > host is accepting the messages - but they never > arrive anywhere (not even in their postmaster a/c) > > Since they are doing this from behind a firewall and > refuse to open it for ssh access, I thought I'd first > check if this is a known issue before I take a flight > there to sort it out. <guess> Maybe their exchange server is demanding that users authenticate before sending (this is configured with a checkbox somewhere in the Exchange Admin labyrinth, iirc). I don't know why this would cause a noticeable exception tho... </guess> Can you telnet to the smtp server and manually submit a message that gets delivered correctly? --Rob

1 0

Re: [Zope] Adding another base class to an existing ZClass
by Alexandre Ratti 11 Jan '00

11 Jan '00

Hello, Well, I did use the unsupported method several times (though I'm not brave, just lazy ;-). The process is described here: <http://lists.zope.org/pipermail/zope-dev/1999-August/001288.html> Make sure you backup your database before using it. One never knows. Alexandre At 12:00 10/01/2000 -0800, you wrote: >From: "Kevin Dangoor" <kid(a)kendermedia.com> >To: "Chris McDonough" <chrism(a)digicool.com>, "Gregor" <vorlon(a)iglou.com> >Cc: <zope(a)zope.org>, <stevej(a)parlant.com> >Subject: Re: [Zope] Adding another base class to an existing ZClass >Date: Mon, 10 Jan 2000 09:52:52 -0500 >charset="iso-8859-1" > > >I have not tried the wildly unsupported method... I'm not brave enough. I >have, however, used the method that Gregor describes. It is a little >tedious, but it works just fine. Broken down step-by-step, I think this is >what I've done: > >1) Rename the old classes and their metatypes to something like MyClass2, >MyType2 >2) Create a new ZClass with the proper base classes. >3) Start copying and pasting your methods and such... rebuild your >propertysheets. This is the tedious part. It's probably a good idea to make >sure you look at every tab in the management interface to make sure you >don't miss something. >4) Copy your original ZClass' class ID to the clipboard. Then change the >class ID to something else. (I typically just add an extra = on the end) >5) Change the new ZClass' class ID to the one on the clipboard. > >Voila! New ZClass. > >I think Chris' suggestion from his next message (creating a Python base >class) sounds really dandy. But, you'll probably want to use the above steps >to get that base class into your existing ZClasses... > >Kevin

1 0

using cvswrapper filters? (tangentially related to zope...)
by Anthony Baxter 11 Jan '00

11 Jan '00

(sorry for the only-tangentially related message - but I figure it's probably of some use to other Zope users. if you disagree, please flame me in private, rather than cluttering up the list even more than I already am :) I'm (finally) getting things set up at work to store Zope releases (our code, on top of the DC code) into a local CVS server. For completeness, I'd like to store the Data.fs file in CVS as well, but preferably gzipped - looking at the CVSROOT/cvswrappers file, I see: -f from cvs filter value: path to filter -t to cvs filter value: path to filter This isn't documented in the red-bean CVS book, or in the normal online docs... has anyone played with this? Will it allow me to store Data.fs gzipped in the repository? thanks, Anthony

1 0

UPDATE: Apache + ZServer complete solution
by anser 11 Jan '00

11 Jan '00

Thanks to Evan Simpson (author of SiteAccess), I now have a complete working solution for embedding ZServer behind Apache, allowing all or part of a website to run with fast, multithreaded Zope content while other legacy content and configurations are unaffected. http://www.zope.org/Members/anser/apache_zserver/ Enjoy, and as always I welcome suggestions and comments.

5 8

Re: Using MySQL DA - Great HOWTO
by Glenn Williams 11 Jan '00

11 Jan '00

Great writeup on installing ZMySQLDA. I used the How-To and indeed it took less than 10 minutes to get the thing working! As a little bit of additional info: I am running SuSE Linux 6.3, and vanilla version of Python they provide works fine with no modifications. That is, I didn't have to rebuild Python to get it to work... Regards and thanks again, Glenn Advanced Decisions Inc. Running S.u.S.E. Linux 6.2 with KDE ____________________________________________________________________ Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com.

1 0

Re: Photo Product fix/question/suggestion
by Andrew Lahser 11 Jan '00

11 Jan '00

> > This should work: > > <dtml-var "blah(REQUEST, class='fooimage', alt='[Can't use dtml tags inside > > dtml tags]', pdcookie='1')"> > > Zope spits out the following: > > Expression (Python) Syntax error: > invalid syntax > > , for tag <dtml-var "blah(REQUEST, class='fooimage', alt='[Can't use dtml tags > inside dtml tags]', pdcookie='1')">, on line 6 of index_html > > It gives the same error if I use the other version. I hope that you did not take my example literaly. I included an extra apostrophe (') in the example that would give a syntax error. Here is a simplier example. <dtml-var "blah(REQUEST, alt='your text', pdcookie='1')"> Add all the additional tags that you would want. Remember that blah needs to be photo object, not an attribute with the name of the photo > > Let me know right away if this doesn't work for you. > > The *major* problem I am suffering is that I don't know what "blah" is in my > method, so the above doesn't work. > > The ZClass FooImage has a property "image". > Inside the image property for a given instance, I stick the ID of the proper > photo object. > My DTML is in the index_html method of FooImage. > > I don't know how to tell DTML to grab the object referred to by "image" (as > opposed to the string CONTENTS of the "image" property, which is what it does > right now, I assume). If I just plug in the Property name as in > "image(REQUEST", then it gives a "call of non-function" error. > If I understand your problem correctly, you should be able to do this. <dtml-with blah> # blah is an attribute of the index_html document <dtml-var "tag(REQUEST, pdcookie='1', alt='your text')"> </dtml-with> Also, you could loop through all the Photos in a container as follows. <dtml-in "objectValues('Photo')"> <dtml-var "tag(REQUEST, pdcookie='1', alt='your text')"> </dtml-in> > > > Alternately, figuring out how to use this "pdcookie" feature from a normal > > > <img> tag would work too. The pdcookie feature is nothing more than a switch to spit out some html. Feel free to copy that anywhere you need. The trick is to set the cookie in the user's browser.

2 3