- Zope - Zope lists

Re: [Zope] Using SQL aggregate functions
by Tres Seaver 29 Feb '00

29 Feb '00

John Williams wrote: > > >>>>> "Tres" == Tres Seaver <tseaver(a)palladion.com> writes: > > Tres> John Williams <J.A.R.Williams(a)aston.ac.uk> asked: > >> Date: 28 Feb 2000 08:17:42 +0000 > >> > >> I have been trying to use SQL aggregate functions in SQL > >> Methods to calculate some statistics e.g. something like > >> > >> SELECT id,count(id) from data group by field > >> > >> I am using MySQL, and the query works if entered directly from > >> another client, however Zopes SQL method returns an error. Is > >> this a known problem. Is there a known workaround or patch? > > Tres> I believe that the aggregate column has a "name" which the > Tres> DA doesn't like. Try aliasing it (the syntax for this > Tres> depends on your RDBMS):: > > Tres> SELECT id,count(id) as count_id from data group by field > > I was in fact using an alias, and this isn't cure the problem. I have > since looked in a bit more detail and the problem appears to occur > only when I use a join in the query, so it is a bit more subtle than I > originally thought. I saw another post with a patch for mySQL to cope with a column whose type was coming back "unhandled". Perhaps it would shed some light? Also, the SQL you posted looks a little odd: the non-aggregate column 'id' is not one of the 'group by' columns, which will cause Oracle at least to barf on the statement. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

is dtml-in doing a dtml-with? How do I turn off that behaviour?
by Kevin Meinert 29 Feb '00

29 Feb '00

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thinking more about my problem I mailed before... Maybe dtml-in is actually doing a dtml-with on each of the "objectValues(['DTML Method'])". In that case any dtml-with that came after (even within one of those DTML Methods), would be screwed up, since you can't really descend into a method like you can a folder. ............... 2 Questions: ............... * Is there any way to turn off this dtml-with behaviour in dtml-in? * Or maybe my assumption is plain wrong? Seems like this behaviour should not be default. Like, if you really wanted a dtml-with, then you should explicitly call dtml-with right after the dtml-in. I wonder why it would be implemented this way? ............... 3rd Question: ............... Is there a reference manual out there that gives _real_ documentation of structured dtml? All I've found is sketchy examples. I want a very thourough/rigorus examination of every feature and every parameter of every dtml tag (namly dtml-in for now). You find this quality of documentation in some software API's. I can't seem to find anything even close for Zope. Kevin -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com> iQA/AwUBOLhJ4DlszdAdzf4MEQLAdwCg0tYnNfFDmETvHifhRZXH9eOedkkAoMOj /pBpJgPWdbcCfRV0L7rzZk5E =VErH -----END PGP SIGNATURE-----

4 4

GUF vs. UserDb
by Lucas Vogel 29 Feb '00

29 Feb '00

What is the difference between these two objects? My first impression of UserDb is that it is the GUF implemented as the Database HOWTO suggests, except that it handles all logins/permissions for the Zope level and not the application level. -- Lucas Vogel lucas7(a)home.com ICQ: 44697169

2 1

GUF permissions and executing methods
by Lucas Vogel 29 Feb '00

29 Feb '00

I have set up a proxy user in my GUF that proxies the objects listed in the HOWTO in the GUF w/SQL Database. When I go to use the docLogin form, enter a username and password and press OK, it activates docLoginSuccess. Here is the line: <FORM ACTION="<dtml-var "docLoginSuccess">" method=post> But when I press the OK button I get an error because it passes docLoginSuccess into the URL line by line. Is it my syntax or a permissions issue? Thanks -- Lucas Vogel lucas7(a)home.com ICQ: 44697169

2 3

Newbie: Why doesn't this work?
by Michiel Toneman 29 Feb '00

29 Feb '00

Hi All, After struggling with Zope for two weeks now, I still can't figure some things out... From the namespaces HOWTO: --------------------------------------------------------------- Example: The Let Tag The Let tag let's you initialize and push a new name space onto the name space stack. The arguments to the Let Tag are evaluated and placed into the top most name space. For example: <dtml-let x=5 y=7> <dtml-var x><dtml-var y> </dtml-let> The let tag creates a new name space, enters the integers x and y into the new name space, and pushes the name space onto the stack. ---------------------------------------------------------------- Well, it just doesn't work! I get: Error Type: KeyError Error Value: 5 I've also tried <dtml-let x=5 y=7> <dtml-var x><dtml-var y> </dtml-let> just to be sure... Also from the namespaces howto: ---------------------------------------------------------------------- Example: The In Tag A common sight in DTML is iterating over the contents of a Folder. Create a folder called MyFolder and a DTML Method called MyMethod containing the following: <dtml-in objectValues> <dtml-var id> </dtml-in> Before entering the block, id was bound to MyFolder. When the block is entered, a new name space is popped onto the name space stack. The new name space contains the name space of the sequence-item in the tag. Because new name spaces override old ones, the new 'sequence-item's id attribute is printed in our example instead of MyFolder. DTML tags push and pop name spaces onto the stack. Some DTML tags, like and , do not change the name space at all, but , and modify the name space stack in their own way. The tag pushes the current sequence-item onto the name space stack and then pops it off the stack when the end of the tag is reached. In each iteration through the sequence objectValues, the id of each item in the sequence is rendered ---------------------------------------------------------------------- This doesn't give me anything (yes, there are things in a folder below) So what am I doing wrong, am i a user=id10t or is something seriously screwy with Zope? I can get a lot of stuff to work, but it's all slow trial and error, because I can't figure out the logic (and apparently neither could the namespaces HOWTO author :( ) Please help, Michiel Toneman -- >From a Sun Microsystems bug report (#4102680): "Workaround: don't pound on the mouse like a wild monkey."

2 1

RE: [Zope] Newbie: Why doesn't this work?
by Marcus Collins 29 Feb '00

29 Feb '00

What follows the = in the dtml-let tag must be either the name of a variable visible in the current namespace, or a python expression. In your <dtml-let x=5>, Zope is trying to find a variable named 5 and assign its value to x. Zope can't find a variable named 5, hence the KeyError. You need to use <dtml-let x="5"> so that the python expression 5 (an integer) is assigned to x. Likewise for y. Note too that, when you assign a string to a variable using dtml-let, you need to use two sets of quotes, e.g. <dtml-let foo="'bar'">, so that the python expression returns 'bar' (a string). -- Marcus > -----Original Message----- > From: Michiel Toneman [mailto:toneman@phil.uu.nl] > Sent: 29 February 2000 11:44 > To: zope(a)zope.org > Subject: [Zope] Newbie: Why doesn't this work? > > > > > Hi All, > > After struggling with Zope for two weeks now, I > still can't figure some things out... From the > namespaces HOWTO: > > --------------------------------------------------------------- > Example: The Let Tag > > The Let tag let's you initialize and push a new name space onto > the name space stack. The arguments to the Let Tag are evaluated > and placed into the top most name space. For example: > > <dtml-let x=5 y=7> > <dtml-var x><dtml-var y> > </dtml-let> > > The let tag creates a new name space, enters the integers x and y > into the new name space, and pushes the name space onto the stack. > ---------------------------------------------------------------- > > Well, it just doesn't work! I get: > > Error Type: KeyError > Error Value: 5 > > I've also tried > > <dtml-let x=5 > y=7> > <dtml-var x><dtml-var y> > </dtml-let> > > just to be sure... > > > Also from the namespaces howto: > > ---------------------------------------------------------------------- > Example: The In Tag > > A common sight in DTML is iterating over the contents of a > Folder. Create a folder called MyFolder and a DTML Method called > MyMethod containing the following: > > <dtml-in objectValues> > <dtml-var id> > </dtml-in> > > Before entering the block, id was bound to MyFolder. When the block > is entered, a new name space is popped onto the name space stack. The > new name space contains the name space of the sequence-item > in the tag. Because new name spaces override old ones, the new > 'sequence-item's id attribute is printed in our example instead > of MyFolder. > > DTML tags push and pop name spaces onto the stack. Some DTML tags, > like and , do not change the name space at all, but , and modify > the name space stack in their own way. > > The tag pushes the current sequence-item onto the name space stack > and then pops it off the stack when the end of the tag is reached. In > each iteration through the sequence objectValues, the id of each > item in the sequence is rendered > ---------------------------------------------------------------------- > > This doesn't give me anything (yes, there are things in a > folder below) > > So what am I doing wrong, am i a user=id10t or is something seriously > screwy with Zope? I can get a lot of stuff to work, but it's all slow > trial and error, because I can't figure out the logic (and apparently > neither could the namespaces HOWTO author :( ) > > Please help, > > Michiel Toneman > > -- > From a Sun Microsystems bug report (#4102680): > "Workaround: don't pound on the mouse like a wild monkey." > > > _______________________________________________ > 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

Re: [Zope] DESPERATION: ZCatalog search madness
by Hung Jung Lu 29 Feb '00

29 Feb '00

darran edmundson <dee12-(a)rsphy1.anu.edu.au> wrote: > 3 object are indexed in Year (integer, FieldIndex) 3 object are >indexed in Journal (string, FieldIndex) 3 object are indexed in >Authors (string, TextIndex) I am shooting in the dark, but here is one thing that seems not right: your 'Year' index is integer. I think ZCatalog only deals with strings. You may need to change the integer to string. If 'Year' is a property created inside Zope, try to use a string type instead of integer type. >Whereas this one returns an empty result: > ><dtml-in "publicationCatalog(Authors='Kivshar',sort_on='Journal')"> > >and this one causes a key error: > ><dtml-in "publicationCatalog(Authors='Kivshar',sort_on='Year')"> I'll do some more experiments later, but first, change the integer to string and see whether this fixes the problem on the 'Year'. Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

2 1

Re: [Zope] Install behind iPlanet with SSL
by Michel Pelletier 29 Feb '00

29 Feb '00

Nicola Larosa wrote: > > Thanks for your answer, Michel. > _USER REQUEST variable or the > >> AUTHENTICATED_USER one? > > > Unless you can patch the server or compile a special server module, > > or use a better protocol such as FastCGI, you stuck with REMOTE_USER > > which is not ideal at all. > > Yes, it is not ideal , but it could be workable for our needs (no content delegation and such). Also there is a old NSAPI module somewhere in Zope land (look on the zope site, search for NSAPI) This might be workable. > > >> 3) I already installed the iPlanet server and Zope on a Sun. How do > >> i go configuring the iPlanet server in order to activate Zope? > > > I've not heard of anyone running Zope with iPlanet. > > Hey, come on, I am sure I saw someone on this list saying that they installed Zope behind Netscape Enterprise Server, and that's the same beast. oh yeah... I was thinking of something else... -Michel

1 0

docLogin HOWTO for GUF
by Lucas Vogel 29 Feb '00

29 Feb '00

I have done all of the steps in the How-To: How To: Use GenericUserFolder with an SQL database document. However I feel that I am stuck, and the place I am stuck is with the docLogin object. Whenever I try to access this object I get this traceback below the form: Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 151, in publish File /usr/local/zope/lib/python/Products/SiteAccess/ChangeBehaviors.py, line 224, in traverse File /usr/local/zope/lib/python/Products/GenericUserFolder/GenericUserFolder.py, line 530, in validate (Object: ElementWithAttributes) File /usr/local/zope/lib/python/Products/GenericUserFolder/GenericUserFolder.py, line 453, in _cookie_validate (Object: ElementWithAttributes) File /usr/local/zope/lib/python/Products/GenericUserFolder/GenericUserFolder.py, line 364, in _recurse_validate (Object: ElementWithAttributes) File lib/python/Products/UserDb/UserDb.py, line 289, in validate (Object: RoleManager) File lib/python/Products/UserDb/UserDb.py, line 284, in cookie_validate (Object: RoleManager) LoginRequired: (see above) --------------------------------------------- I think it has something to do with the _gufauth_dest variable in the object that holds QUERY_NAME, PATH_INFO, and QUERY_STRING. Do I need to have this page accessed as a result of input being passed to it first? -- Lucas Vogel lucas7(a)home.com ICQ: 44697169

2 1

Re: [Zope] Install behind iPlanet with SSL
by Nicola Larosa 29 Feb '00

29 Feb '00

>> 1) Does installing PCGI within the iPlanet server guarantees a full >> one-to-one mapping between iPlanet threads and ZServer threads? > Not at all. I kind of expected this, but it should not be critical in this first phase. >> 2) Will I be using the REMOTE_USER REQUEST variable or the >> AUTHENTICATED_USER one? > Unless you can patch the server or compile a special server module, > or use a better protocol such as FastCGI, you stuck with REMOTE_USER > which is not ideal at all. Yes, it is not ideal , but it could be workable for our needs (no content delegation and such). Thanks for your answer, Michel. >> 3) I already installed the iPlanet server and Zope on a Sun. How do >> i go configuring the iPlanet server in order to activate Zope? > I've not heard of anyone running Zope with iPlanet. Hey, come on, I am sure I saw someone on this list saying that they installed Zope behind Netscape Enterprise Server, and that's the same beast. >> Those of you who already accomplished this (and I know you're out >> there), please speak up! > I HIGHLY suggest you look at FastCGI. I definitely will, but I guess it will take a little while, so I am postponing it to the second phase of the project. So, doesn't anyone have a nice, step-by-step instruction for setting up the iPlanet (Netscape) server in PCGI mode, or in any other one?

1 0