August 2000 - Zope - Zope lists

Re: [Zope] Substracting value from variable?
by Arjan Scherpenisse 01 Aug '00

01 Aug '00

Jonathan <listsmurf(a)ur.nl> wrote: > Hi all, Is there a way to have a ZSQL Method select the four highest > values from a list of values in a database? Example: > select distinct year from table > returns the following results > 1975 1980 1985 1990 1995 2000 > from which I want to select the latest four years: > 1985 1990 1995 2000 > Possible? Can't seem to find anything in the docs :( This can be achieved with plain SQL, just alter your query like this: select distinct year from table order by year limit 4 that will do the trick. Maybe you need 'order by year desc' instead of just 'order by year' to get the four highest values not the for lowest, but i'm not sure, cheers, -- Arjan Scherpenisse acscherp(a)wins.uva.nl may the source be with you === http://www.gnu.org ===

1 0

Select highest four from results?
by Jonathan 01 Aug '00

01 Aug '00

Posted with the wrong subject. Here we go again: Hi all, Is there a way to have a ZSQL Method select the four highest values from a list of values in a database? Example: select distinct year from table returns the following results 1975 1980 1985 1990 1995 2000 from which I want to select the latest four years: 1985 1990 1995 2000 Possible? Can't seem to find anything in the docs :( Thnx, Jonathan

1 0

Permissions question.
by Jeff K. Hoffman 01 Aug '00

01 Aug '00

Hello, I am having a permissions problem, and am hoping someone on the list will see the error in my ways. I have a ZClass, called a FooManager, that inherits from ObjectManager. It is responsible for creating (and managing) Foo objects. In the FooManager ZClass, I created a DTMLMethod called 'addFoo', and a form called 'fooForm'. Following the "How to Create ZClass Instances Programmatically" How-To, I modified my 'Foo_add' constructor to avoid redirecting if the request contains a noRedir parameter. In my 'addFoo' method, I have: <dtml-with "manage_addProduct['FooProduct']"> <dtml-call "Foo_add(_.None, _, noRedir=1)"> </dtml-with> and I set it's Proxy role to 'Manager'. My form, obviously, calls 'addFoo' with: <form action="addFoo" method="..."> When I submit the form, I get: Unauthorized. You are not authorized to access FooObject. 'FooObject' is the name of my ZClass. The traceback is: ... File /d1/zope/pcalc.ptec.com/lib/python/DocumentTemplate/DT_Util.py, line 331, in eval (Object: FooObject.createInObjectManager(REQUEST['id'], REQUEST)) (Info: FooObject) File /d1/zope/pcalc.ptec.com/lib/python/OFS/DTMLMethod.py, line 189, in validate (Object: addFoo) File /d1/zope/pcalc.ptec.com/lib/python/AccessControl/SecurityManager.py, line 139, in validate File /d1/zope/pcalc.ptec.com/lib/python/AccessControl/ZopeSecurityPolicy.py, line 209, in validate Unauthorized: (see above) I can fix the problem by going directly to my 'FooManager' instance and giving Anonymous permission to 'Add a Foo Object'. However, I don't want to do this on a general basis, nor do I want to have to manually adjust each instance of 'FooManager'. I ONLY want my 'addFoo' method to be able to do it. I thought the Proxy role in the ZClass's 'addFoo' method would do the trick, but it did not. Sorry if I haven't explained this well. As you can probably tell, ZClass permissions are not exactly my strong suit in Zope. Anyone have any ideas? --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:jeff.hoffman@goingv.com Going Virtual, L.L.C. http://www.goingv.com/

2 2

ZUBB / ZDiscussions Users or Examples
by J. Atwood 01 Aug '00

01 Aug '00

I have started a page (http://www.zope.org/Members/BwanaZulia/ZUBB/EXAMPLES) to list sites that are building / using ZUBB or ZDiscussions. I would love if you are using it to send me a link and you permission to add you to the list. I will also add you to a mailing list to let you know what the future looks like it. Thanks, J

2 2

page properties (part II)
by tav 01 Aug '00

01 Aug '00

apologies for the delay with the site, to anyone who was expecting it, i had some "real life" issues to deal with :/ which, i have now managed to deal with for the time being, and got back to dear zope. i worked away at it all nite, and ended up with a handful of problems, which i am hoping someone will be able to solve ;) (1) following up from last time i thought it would be more functional if the user could define the pagename and a pagetopic (section) and press enter, when the user does this, it sends the info to a dtml document, which puts the page(pagename) into managed_mode, and i would also like to now set the pagetopic as a new property... page_topic atm, the code looks like this... ------ <dtml-with "_.getitem(pagename,0)"> <dtml-call "manage_changeProperties(managed_mode=1)"> </dtml-with> ------ but, i have no idea how i would get the second pagetopic passed along, and set as a new property on whatever page, pagename is (2) sorting by two values i wa trying to sort through all the pages, and display the 10 most recently changed ones which have page_status set to approved. ------ <dtml-in "aq_parent.objectValues(spec='ZWiki Page')" size="10" sort="bobobase_modification_time" reverse> <dtml-if "page_status == 'approved'"> <a href="&dtml.url_quote-id;" class="alt"><dtml-var id></a><p> </dtml-if> </dtml-in> ------ i came close with the above code, however, it sorts out the 10 most recent pages first, and then 'filters' and displays the ones which have approved status. whereas i want 10 approved pages :( (3) search how would i create a page that allowed people to search a host of pages by specific properties, e.g. page_status or page_name? - so, user selects property from a drop-down list and types in what he is searching for into a text field, and presses search..... - perhaps even search by time? e.g. person says, only display pages created in the last [person enters value here] days - and of course, search by time when last edited. person enters start time, and end time, and all pages last edited within that time frame are shown - would it be possible for someone to search on two criteria? say page_name and time last changed? (4) these questions related to PTK (i am running the latest CVS version) - the /Members/membername section seems to be fucked ): going there directly tells me that the object cant be found. digging through the PTK-list, i found out that /Members/membername/index_html/index_html works, but that is one damned nuisance it works nicely on zope.org, so i am hoping that there is a workaround for it ;) - i would like to also limit what users can upload to 100kb. any way of doing this? (5) imo, this is the hardest of what i want to do in the root folder of the site, i have 3 "boxes" (box1, box2, box3 ;), these are all dtml documents. each of those boxes have a corresponding, simple dtml document: color1, color2, and color3 i also have a dtml document called featurepage, which looks like: ------ <tr><td bgcolor=<dtml-var color1>> <dtml-var box1> </td></tr> <tr><td bgcolor=<dtml-var color2>> <dtml-var box2> </td></tr> <tr><td bgcolor=<dtml-var color3>> <dtml-var box3> </td></tr> ------ now, what i would like to do is, when user signs up (this uses PTK's default system), featurepage is copied over to the user's directory /Members/username again, i notice that zope.org copies over a zwiki folder... so this must be possible. also, if possible, i would like to customise the user's index_html, which i dont seem to be able to do atm :/ anyways, once the featurepage is copied over, i would like to let the user do two things (1) tick which boxes they want to show (2) define which order they want the boxes they have chosen to appear... (3) define the different colors for the boxes that they have chosen letting a person do all this through a webpage "seems" to be possible, just dont know how :/ apologies in advance for such a long list of problems. i have spent many sleepless nites trying to work them all out. managed to solve half the problems, but the above are beyond me ): thanks in advance for any help -- best regards, tav ps, with PTK, is there any way to copy a certain file/fodler into the Members/username section of each member who has already registered? or does this have to be done *shudder* manually? pps, with the PTK, is there any way to change the user's roles, e.g. add Reviewer role to Member, without altering the password? thanks

1 1

Month number as string as variable
by peter be 01 Aug '00

01 Aug '00

Dear All. What I want to do is display this months Poll. I have created three Polls ( from the Poll Product ), named month_06, month_07, month_08. I understand that I will have to use the getitem() function to "show" the Poll itself, but I don't know how to create the string "month_0X" <dtml-var "ZopeTime()" fmt="%m"> ...returns (today) '08' Good! <dtml-let monthnr="ZopeTime()"> <dtml-var monthnr fmt="%m"> ...also returns (today) '08' Good! </dtml-let> But I don't want to use the fmt when I display it. I'd like to have something like this: <dtml-let monthnr=("ZopeTime()" fmt="%m")> * this is where the problem lies. <dtml-let monthPoll="'month_'+monthnr"> <dtml-var "_.getitem(monthPoll)"> </dtml-let> But this obviously, is bad syntax. (I have tried [] squared brackets as well) Best Regards, Peter

1 0

Ann: Free Zope Hosting Available Again
by Chris Withers 01 Aug '00

01 Aug '00

New Information Paradigms Ltd is happy to announce that their Free Zope Hosting Option is once again available! Furthermore, the price of the Professional Zope Hosting Option has been halved to £100 per month while still providing the same high quality service. (£100 is roughly equal to $150 or 160 Euros) NIP's hosting options are briefly described below, but please see http://www.nipltd.net for full details. - Free Zope Hosting This hosting option provides an opportunity to explore Zope and evaluate it in a reliable way. We also hope that people within the Zope community can publicly host useful Zope applications without any financial burden. - Professional Zope Hosting If you have a commercial Zope application and need somewhere secure and reliable to host it, then this is the option for you. It is based around an instance of Zope and a relational database for each customer with secure access allowing a high degree of customisation. - Enterprise Zope Hosting This option provides a totally custom combination of hardware, software and consulting that you will need if you intend to use Zope to provide an enterprise wide solution. For more information see http://www.nipltd.net/ or email us at hosting(a)zope.nipltd.com

1 0

Newbe external method question
by Gaspard, Bradley S 01 Aug '00

01 Aug '00

I have what I fear is a very basic question ... I want to write an external method that first determines all of the objects in a folder that posses a certain property. I know how to find the object ids but once I do that how do I then determine which contain the property I am searching for?? Thanks for any help. Brad

2 1

RE: [Zope] tracebacks
by Tom Deprez 01 Aug '00

01 Aug '00

>A) your SQL is wrong, you want a VARCHAR not a CHAR there. and i doubt >'NOW' is a valid value for a TIMESTAMP type in your DB. You'll be wanting a >SQL function like Date(), not a string. Probably. Look in your DB docs. >Not that I'm much of a SQL person - someone else will probably correct me. I'm using an Interbase database. You can use CHAR and VARCHAR. The last one is a variable char, while the first has a fixed length. Anyway, this was just an example out of my head to explain what I'm experiencing. 'NOW' can be used in Interbase as it will insert the current date&time when a value is not given for a record. (Although, I'm not sure it will work through Zope, I'm just curious :-) ). Anyway, '12/07/2000' should work. >B) Now why you'd get a pickling error when you've got bad SQL i don't know - >and 'cannot pickle objects' is a blantant lie. Surely that's what >pickling's all about. MY_NAME VARCHAR(20) DEFAULT 'tom', gives the same error. And yes, it's strange that I get an error with a default literal value. Could it be that Zope handles the tom in 'tom' as a python expresion or something? >Anyway you read the traceback from bottom to top. >The error occured on line 348 of Connection.py, which threw an error in >Transaction.py, blah blah, which threw an error in Publish.py, which caused >Zope to exit the publisher and print the stack trace. Thanks Seb, this is what I wanted to know about the traceback. Tom. >> -----Original Message----- >> From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Tom >> Deprez >> Sent: 01 August 2000 12:41 >> To: zope(a)zope.org >> Subject: [Zope] tracebacks >> >> >> Hi, >> >> Can somebody explain me how you can use the given tracebacks >> to find the >> possible error? For example, I get the following error and I know what >> causes it, but I don't know where I must go to find the >> code-line where the >> error starts: >> >> I get the following error when I use a table in which a field >> is defined >> with a default string value. >> >> eg : >> >> MY_NAME CHAR(20) DEFAULT 'tom' >> MY_DATE TIMESTAMP DEFAULT '6/07/2000' >> MY_DATE TIMESTAMP DEFAULT 'NOW' >> >> --- >> Zope Error >> Zope has encountered an error while publishing this resource. >> >> Error Type: cPickle.PicklingError >> Error Value: Cannot pickle objects. >> --- >> >>  >> >> >> Thanks for any advice. >> >> Tom >> >> _______________________________________________ >> 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] tracebacks
by Seb Bacon 01 Aug '00

01 Aug '00

A) your SQL is wrong, you want a VARCHAR not a CHAR there. and i doubt 'NOW' is a valid value for a TIMESTAMP type in your DB. You'll be wanting a SQL function like Date(), not a string. Probably. Look in your DB docs. Not that I'm much of a SQL person - someone else will probably correct me. B) Now why you'd get a pickling error when you've got bad SQL i don't know - and 'cannot pickle objects' is a blantant lie. Surely that's what pickling's all about. Anyway you read the traceback from bottom to top. The error occured on line 348 of Connection.py, which threw an error in Transaction.py, blah blah, which threw an error in Publish.py, which caused Zope to exit the publisher and print the stack trace. seb. > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Tom > Deprez > Sent: 01 August 2000 12:41 > To: zope(a)zope.org > Subject: [Zope] tracebacks > > > Hi, > > Can somebody explain me how you can use the given tracebacks > to find the > possible error? For example, I get the following error and I know what > causes it, but I don't know where I must go to find the > code-line where the > error starts: > > I get the following error when I use a table in which a field > is defined > with a default string value. > > eg : > > MY_NAME CHAR(20) DEFAULT 'tom' > MY_DATE TIMESTAMP DEFAULT '6/07/2000' > MY_DATE TIMESTAMP DEFAULT 'NOW' > > --- > Zope Error > Zope has encountered an error while publishing this resource. > > Error Type: cPickle.PicklingError > Error Value: Cannot pickle objects. > --- > >  > > > Thanks for any advice. > > Tom > > _______________________________________________ > 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