- Zope - Zope lists

TAL/SQL Problem
by Phil Beardmore 07 Apr '05

07 Apr '05

Hi, hope you can help. We are currently linking a webpage to an SQL database and are pulling in information via the tal:replace function. This is working extremely well however one of our SQL fields is comma deliminated, and we want it to appear as a list. We have accomplished this by using the following code: <h1>Interests</h1> <tal:x define="test2 result/interests" repeat="id python:interests.split(',')"> <p><a href="" tal:attributes="href string:detail_html?id=$id" tal:content="result/interests" >Interests goes here</a></p> </tal:x> This works well, and each item of text is displayed as a list item. Only problem we have, is we want to be able to display the SQL text as the link name, but instead each link has the same link text which is the whole of the SQL string. E.g. The text in the interests field is: Swimming,Badminton,Ice Hockey <detail_html?id=Swimming> The code seperates the text via the comma, and displays a list item for each activity. Only problem is, the link text for each activity is the same (Swimming,Badminton,Ice Hockey <detail_html?id=Swimming>). Anyone got any ideas? Hope you can understand what I am after. An example page is at: http://lash.sunderland.ac.uk/business/organisationandstaff/test/detail_html… Thanks Phil

3 2

Re: [Zope] Product creation difficulty
by Chris Withers 07 Apr '05

07 Apr '05

(keep replies on the list, more people can help that way) Pete Taylor wrote: > thanks man. doing it that way has cleared up the security problem. i've > run into others trying to access xml-rpc methods remotely (zope keeps > passing the __roles__ checks back to the xmlrpc server, which says "i don't > know what you're talking about", etc) You'd have to give us more information if you want help with that, it sounds like something bizarre is happening that shouldn't ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 0

browsing server filesystem
by Fabio Marcone 07 Apr '05

07 Apr '05

Hi! I need to browse (from a client) server file system. Does exist a zope object to do that? or, how can I do it? (I think external method in python, isn't it?) Thanks, Fabio

2 1

how to store ZSQL query results in a python var
by prabuddha ray 07 Apr '05

07 Apr '05

from a newbie, i've this ZSQLmethod returning me a string only. how do i store it a var in my python script. eg., userlevel = container.getUserLevel(uname=user) when i print it using html_quote as : print "(%s)" % html_quote(userlevel) return printed output is : (<Shared.DC.ZRDB.Results.Results instance at 0x41dd966c>) please help. -- Share the vision of difference with ME

3 2

how to add pages to a new tab in plone
by prabuddha ray 07 Apr '05

07 Apr '05

hope i get this through !!! In my plone site I've added a portal_tab through portal_actions. i've made a subfolder in my plone site root folder for it. I gave the path in the action value field of the tabs as : string:$portal_url/consumables now the problem is that when i click on my tab the index_html zpt opens seperately as a new page unlike the home tab's index page which opens inside the plone site . i want the pages in my tab to added as the plone site's content, not seperately. how do i do it. -- Share the vision of difference with ME

1 0

Does anyone care whether we deprecate ZClasses?
by Jim Fulton 07 Apr '05

07 Apr '05

ZClasses are a feature that support through-the-web development. Many people have found them useful in the past, but they have some significant deficiencies, including: - They can't be managed with file-system tools, especially revision control systems like CVS and subversion. - They don't work well with Python development tools, like profilers and debugger. - They aren't being actively maintained. Most serious Zope developers stopped using them a long time ago and are frustrated that we still expend resources keeping them around. For example, the release of Zope 2.8 has been delayed by the requirement of getting ZClasses working with Zope 2.8. We could choose to deprecate ZClasses. If we deprecated them in Zope 2.8, they would still work in Zope 2.8 and Zope 2.9, but their support would be removed in Zope 2.10. Would anyone be upset if this happened? Jim -- Jim Fulton mailto:jim@zope.com Python Powered! CTO (540) 361-1714 http://www.python.org Zope Corporation http://www.zope.com http://www.zope.org

20 32

request forward technique
by prabuddha ray 07 Apr '05

07 Apr '05

>From my login page I'm calling a python script for redirecting it to seperate pages. there if login fails i the login page is to be redirected along with setting a hidden form field 'invalid' by '1'. For this I've to set the request/form.invalid value so that it is available to thelogin page. is it possible to set the request values from a page and return them back to the same page? -- Share the vision of difference with ME

1 0

Re: RES: [Zope] login system discussion
by prabuddha ray 07 Apr '05

07 Apr '05

Ok i get it, please tell me the way to set a request form var in a python script On Wed, 6 Apr 2005 12:55:33 -0300, Jose Henrique dos Reis <jhreis(a)senado.gov.br> wrote: > Your request.set puts 'invalid' in request/other, not in request/form. > > Zenrique > -- Share the vision of difference with ME

1 0

Re: login page problem
by prabuddha ray 07 Apr '05

07 Apr '05

HI Cliff, I was hoping another reply eagerly. hope you dint give up on me. I've got some clarifications given below. On Mon, 04 Apr 2005 16:08:50 +0100, Cliff Ford <Cliff.Ford(a)ed.ac.uk> wrote: > I am abstracting bits of your email below in case anyone else wants to > join in. > > If you are going to use Plone I can't offer advice - I have looked at > Plone on three separate occasions, and recently read The Definitive > Guide to Plone, and have stil decided not to use it. I only say this to > make it clear that many applications are built without CMS and Plone. > I had no idea about this. i knew that zope acts as a app server and plone is the front end tool. In fact I'm building the store's site as a plone site in zope. As a matter of fact i've not done much specific in plone . just built 2 tabpanes. I configured the exUserFolder using the mysql database and as expected it built up a seperate login system. so i believe it'll work on itself without plone. One problem that concerns next query is that it took only one table for user details whereas i had one more table for district. > > Two separate tables with User information is awkward! The user folders I > know of expect user information to come from one source. So you either > have to create two folders, each with its own acl_users (provided by one > of the User Folder Products), or you have to hack the User Folder > product to put in a Union select statement in place of a simple Select. > d quarters. let me explain the login page flow. a dropdown list of districts is available on load. on selecting a district the page reloads and the available users are listed in 2nd dropdown list. after selecting the user the password is to be given. So that way i need both the 'district' and the 'userdetail' table. actually the district table has district code ,name and other stores related nfo. userdetail table is linked using this district code. > > You have not said whether the people in the different districts do > completely different things with different forms, or identical things > but specifying the district. If the former then it is no big deal to > create the folders manually, although it can be done programmtically. > You could set a Local Role equal to the district name and get that role > for users from the database. That way, users can only enter their own > district folder. If the latter, then you could retrieve the Username and > District from the User object for use in the forms (include the District > as a role). > users are of different level like store-in-charge, sys mgmt group, vendors and normal users. they are in all the districts. so depending on the user level diffrent set of menu page are to be generated ie. users of same level in diferent districts do same thing. In earlier ASP version I handled this in the login page handler ASP page and wanted to use the same logic here. district shouldn't be the user role , 'userlevel' will act as user role here. but the folders would be districtwise, I suppose. honestly I'm little bogged out by the exuserFolder feature, its using Dtml all the way and I'm sticking to ZPTs and script pythons. > Try working on the rest of your application to build up ZPT and Python > experience. As I said, managing users is tricky. Also, be aware that > Zope experts advise developers to produce file system based Products. > There are lots of simple Products that you can use and browse the code > to see how they work. > > Cliff > I completely understand this. but the problem remains the same . how do i customise these products acccording to my needs. hope this helps you in helping me. waiting for your reply. -- Share the vision of difference with ME

2 3

Problem with Z Psycopg
by Jason Leach 06 Apr '05

06 Apr '05

I'm having a problem with Z Psycopg. From time to time (quite often) it looses the connection with the database and I get: Site Error An error was encountered while publishing this resource. Error Type: OperationalError Error Value: no connection to the server Then I have to login then close and open the connection. It then works for a while before bailing again. Does anyone know what would be causing this? Zope Version (Zope 2.7.3-0, python 2.3.4, linux2) Python Version 2.3.4 (#1, Oct 13 2004, 21:44:19) [GCC 2.95.4 20011002 (Debian prerelease)] And ZPsycopg is version 1.11 Thanks, Jason.

6 10