- Zope - Zope lists

Managing Users with Postgresql.
by Fernando Lujan 24 May '05

24 May '05

Hi, First let me describe my environment. I have a Postgresql database that stores all users, and booleans which describe permissions. The users log on in my application using a WebForm, I run a ZSQL Method and set all permissions in the Session. I manage the security using Session calls, checking each permission and then allow or deny access to the object. I know that it isn't the best solution, and now I want to change it! :) Which is the best solution to solve my problem? I found pgUserFolder. But I'm not so sure if this will be the best solution. Thanks... Fernando Lujan

3 2

strftime
by Luiz Fernando B. Ribeiro 24 May '05

24 May '05

Hello, I'm displaying dates retrieved from a MySQL database using: <span tal:content="python: news['Date'].strftime('%d/%m/%Y')">Date</span> In a strange behaviour using strftime is displaying dates with 1 day past, example 10/05/2005 is being show as 09/05/2005. If i change the code to show the date as it comes from MySQL it is correct and if I change the code to not use strftime and manually retrieve .month() .day() .year() it is also correct. My locale in Zope is set to BRT and in console everything works. Zope 2.7 and Pthin 2.3 from debian sarge. Thanks, -- Luiz Fernando B. Ribeiro Engenho Soluções para a Internet +55 11 6959-7610

2 1

How do I delete acl_users using DTML??
by Allen Huang 24 May '05

24 May '05

How do I delete acl_users using DTML code?? --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone.

3 2

what are the dtml for logout and deleting a existing user??
by Allen Huang 24 May '05

24 May '05

what are the dtml for logout of an account and deleting a existing user?? --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone.

5 4

Create a list using DTML.
by Fernando Lujan 24 May '05

24 May '05

Hi, I have a array data type in my DB wich have the following format : {1,2,3} ( ids_test ). Now in my web application, I have a multiple select wich options must be marked as selected if the number is in the array described above. How can I make the above format be converted to a list of elements? For instance: <html> <body> <dtml-in searchIdsTest> <dtml-call "REQUEST.set('ids_test', '['+ids_test[1:-1]+']')"> </dtml-in> <form> <select name="id_test" multiple="true"> <dtml-in serch_id_test> <option value="&dtml-id_test;" <dtml-if id_test in ids_test> selected="true"</dtml-if>></option> </dtml-in> </select> </form> </body> </html> Thanks. Fernando Lujan

2 3

How to import win32com in external method
by Wei He 24 May '05

24 May '05

Hi, I tried to import win32com in external method, but it always displays Error Type: ImportError Error Value: No module named win32com It's ok in python command line but never works in external method. Is there a way to do this? Thanks. Wei He

2 1

Generatiing Lists with DTML.
by Fernando Lujan 24 May '05

24 May '05

Hi, I have a array data type in my DB wich have the following format : {1,2,3} ( ids_test ). Now in my web application, I have a multiple select wich options must be marked as selected if the number is in the array described above. How can I make the above format be converted to a list of elements? For instance: <html> <body> <dtml-in searchIdsTest> <dtml-call "REQUEST.set('ids_test', '['+ids_test[1:-1]+']')"> </dtml-in> <form> <select name="id_test" multiple="true"> <dtml-in serch_id_test> <option value="&dtml-id_test;" <dtml-if id_test in ids_test> selected="true"</dtml-if>></option> </dtml-in> </select> </form> </body> </html> Thanks. Fernando Lujan

1 0

RE: [Zope] Underscoring Inaugural Address
by Dan Pozmanter 24 May '05

24 May '05

Is sort of do, since the final object is a wrapper around a unique path. What about messing aroound with the url? Is there a way to have it show: http://foo.com/__init__.py But really point to http://foo.com/supercoolfileat__init__.py ? -----Original Message----- From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On Behalf Of Paul Winkler Sent: Wednesday, May 11, 2005 3:56 PM To: zope(a)zope.org Subject: Re: [Zope] Underscoring Inaugural Address On Wed, May 11, 2005 at 03:50:00PM -0400, Dan Pozmanter wrote: > Ugh. I suppose I could ignore the '_' bit (and override > BaseRequest.traverse), but the problems are: > 1. Keeping this thing synced with Zope. > 2. Accessing the object being traversed to to ensure it is of the > correct type. > > There is no other way to do this? Do you have to use URL traversal to reach the final object? There's no such restriction on query parameters. http://foo.com/get_file?name=__init__.py -- Paul Winkler http://www.slinkp.com _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

3 2

"Save Changes" executes Python script
by Bert Vanderbauwhede 24 May '05

24 May '05

Hi, We have written a Python script that sends a mail. Everytime we modify this script with Firefox 1.0.4 in Windows and click "Save Changes", the script is saved and executed. So everytime we receive a mail. This does not happen when we modify the script with Internet Explorer or Firefox 1.0.4 in Linux. Does anyone know about this problem? Bert...

3 3

Re: how to accumulate data using ZPT
by prabuddha ray 24 May '05

24 May '05

ok this is again freaky on my part. my problem still remains intact .as i've told earlier, in my ZPT I needed to find a way to sum up column values if they are present and print the total at the last row. I tried this as a Deepak pal tipped : <span tal:condition="not:penaltylen" tal:content="python:penalty[0].unit_cost"/> <span tal:define="global sum python:sum+penalty[0].unit_cost"/> <tr><td>Total <td><b tal:content="sum"></b></td></tr> but what happens is obvious , for reports where even one row has the unitcost missing followiing error comes up: "tuple indx out of range" when i changed tghe span tgs alike this : <span tal:condition="not:penaltylen" tal:content="python:penalty[0].unit_cost"> <span tal:define="global sum python:sum+penalty[0].unit_cost"/> </span> no error was there but the total remained 0. No ZSQLmethod can be used to get the sum coz its pretty complex. so plz rethink the code I'm also trying hard. hope for a reply soon > On 5/20/05, Deepak <dgangadhar(a)zeomega.com> wrote: > > > > Hi Prabuddha, > > > > check this ... > > > > <span tal:define="global sum python:0"/> > > <span tal:repeat="item python:here.somesql()"> > > <span tal:condition="item/var" tal:define="global sum > > python:sum+item.var"/> > > </span> > > <span tal:content="sum"/> > > > > thanks, > > > > Deepak > > > > prabuddha ray wrote: > > > > >sorry for delay, > > > but the options you gave are ruled out. > > >actually not all the rows in the column have the values. > > >further the total i'm looking for will result in a very complex query > > >that i dont want to do onsidering the no. of rows are high. > > > > > > I just need something like a var in my ZPT which can just sum up the > > >values if they are present. > > >value's prsence i'm checking using tal:condition but how to add the > > >value repeatedly in the sum var. > > > > > >kindly help. > > > > > > > > > > > >On 5/20/05, Tino Wildenhain <tino(a)wildenhain.de> wrote: > > > > > > > > >>Am Freitag, den 20.05.2005, 10:36 +0100 schrieb Hugo Ramos: > > >> > > >> > > >>>On 5/20/05, Tino Wildenhain <tino(a)wildenhain.de> wrote: > > >>> > > >>> > > >>>>Am Freitag, den 20.05.2005, 09:52 +0100 schrieb Hugo Ramos: > > >>>> > > >>>> > > >>>>>Yellow, > > >>>>> > > >>>>>What DBMS are you using??? MySQL??? > > >>>>>If so just have a sql method do this: > > >>>>>========== > > >>>>>SELECT COUNT( '*' ) AS total > > >>>>>FROM yourtable > > >>>>>========== > > >>>>> > > >>>>> > > >>>>Are you sure about the ' '? looks strange. > > >>>> > > >>>> > > >>>It works both ways... With or without the ' ' ! > > >>> > > >>> > > >>> > > >>well. another reason to avoid mysql I guess ;) > > >> > > >> > > >> > > >> > > >> > > >> > > > > > > > > > > > > > > > > > > > -- Share the vision of difference with ME

3 3