- Zope - Zope lists

lists, not strings in database
by Greg Fischer 03 Sep '02

03 Sep '02

I need help with saving a select box value. When multiple items are selected in my form, and then inserted into a SQL server, it is saved as a string that looks like a list. I have tried to specify the data type in name value, none of which change the stored value in the database. This may not be a problem if I only knew how to display the list from the returned database value. _________________________________________ Here is the form object(it is generated dynamically from a dtml method so the size changes): <select name="PeopleInvolved" multiple> <option>aperson</option> <option>bperson</option> <option>cperson</option> <option>dperson</option> </select> _________________________________________ In the database field( a text data type in sql 8) it saves like so: Insert into table (PeopleInvolved) values (<dtml-sqlvar PeopleInvolved type="string">) ['aperson','bperson','cperson'] _________________________________________ When I do a select statement in a zsql method it returns the same value: select * from table ['aperson','bperson','cperson'] _________________________________________ And to display the results in html is do this: <table> <dtml-in sqlMethod> <dtml-in expr="_.string.split(PeopleInvolved)"> <tr><td><dtml-var sequence-item></td></tr> </dtml-in> </dtml-in> </table> __________________________________________ Which show like so: ['aperson', 'bperson', 'cperson'] __________________________________________ If I just use <dtml-in PeopleInvolved> I get an error about not using strings in an "in" tag. So my question is, How do I save it? OR How do I display it? Without having the brackets and quotes? Thanks for any help you have! Greg Fischer sysman(a)tecghroupinc.com

2 1

Cookies for banishing users
by Chetan Kumar 03 Sep '02

03 Sep '02

Hi all The situation 1. The user logs in and the cookie is set. 2. The user requests a page with a form and submit button 3. The page contains a request to a python script 4. The python script adds data to a SQL table 5. User is redirected to a "thanks" page. The address bar refers to the script (not the "thanks" page) 6. The user logs out (The cookie should expire here) 7. The user clicks on "back" button to come back to "thanks" page. 8. The user reloads. At this stage another entry is made in the SQL table. I want to put an end to this behaviour of the site. The user should not be able to insert data by just reload. My question is: Can cookies be of any use here. The problem is that unless the user closes the browser this is not unset. The user is not able to see other pages but can activate the script !! TIA Chetan

4 5

dtml-in totals...
by Michael Fox 03 Sep '02

03 Sep '02

Hi *, I have a dtml-in occurance, which returns several columns from a table, all of which are numeric values, but strings. Each is a different quantity of something, and I want to be able to display the total for each column. What I'm trying to get at is this... <dtml-in myZSQLMethod> <td> </td> <td><dtml-var qty1></td> <td><dtml-var qty2></td> <td><dtml-var qty3></td> <dtml-if sequence-end> <td>Total</td> <td>total for qty1</td> <td>total for qty2</td> <td>total for qty3</td> </dtml-if sequence-end> <dtml-in> My question is what logic do I use to calculate these totals? Cheers, Michael

3 2

2 problems - dtml-tree and python scripting
by Sebastian Kors 03 Sep '02

03 Sep '02

Hello out there, I have two problems: The first is about dtml-tree Tag. With the following code i have the problem that when i click on the last leaf in the tree, the whole tree closes itself. [code] <dtml-tree demo branches_expr="objectValues(['Folder'])" sort="id" single="1"> <dtml-if "_.SecurityCheckPermission('View', this())"> <img src="<dtml-var icon>" > <a href="<dtml-var tree-item-url>"> <dtml-var getId></a> </dtml-if> </dtml-tree> [/code] Result is e.g. / | +--folder1 | +--folder2 +----subfolder1 +-------subsubfolder1 | +--folder3 When i click on subsubfolder1, the expanded tree collapses. How can i have the tree expanded when clicking on the last item? My second problem is this: In a python-based script i try to call a external Method in a different context. The problem is that the place where the method is called is stored in a variable. Take this(the given variable is "folder"): [code] links=[] for parent in context.REQUEST.PARENTS[1:]: links.insert(0, """%s""" % (parent.getId())) abs_folder = "/".join(links) + "/" + context.getId() context.myexternalMethod(abs_folder,folder) thumb_folder = abs_folder + "/thumbs" context.folder.myexternalMethod(thumb_folder,"thumbs") <--- here is the problem. retval = "Ordner " + folder + " in " + abs_folder + " erstellt." return retval [/code] How can i call the external Method in context.myVariable.myexternalMethod? I've tried many things, like the module string(which is not available in Python-based scripts) and others... Regards, Sebastian Kors.

2 1

zeo : use cases
by Mark McEahern 03 Sep '02

03 Sep '02

Suppose I start out with a single, standalone Zope server, and later realize I want to utilize the scaling capacity of ZEO. Here's how I would naively assume this would work: 1. Setup ZEO on another server (I know theoretically I can have ZEO on the same server). 2. Start ZEO. 3. Stop Zope on ths standalone server. 4. Backup Data.fs, place a copy on the ZEO server. 5. Place a custom_zodb.py in the INSTANCE_HOME folder of the standalone Zope server; the custom_zodb.py points to the ZEO server. 6. Start Zope on the previously standalone server. Is that all there is to it? I'd be able to answer this question myself if I could get ZEO running. In the meantime, I'd very much appreciate any insights into this seemingly common use case. Thanks, // mark -

2 1

How do I implement Strip-o-gram or other solution?
by Chris Abraham 03 Sep '02

03 Sep '02

Hi all: I have an application that end up mailing a newly-created News Item to a mailing list upon it being submitted. The body text of this email is stored in HTML; I need to strip the HTML tags from the content and render it as PLAINTEXT before sending it to the MailHost and then off to the Mailing List. I intalled the Strip-o-Gram product but cannot get it to work at all in the way I expected it to work. So, what I did was to create an External Method called html_to_text which I set up like Module Name: stripogram.html_to_text and Function Name html_to_text. Then, in my DTML Method that does the mailing, I have it set up so that it is as follows: << <dtml-with object_published> <dtml-sendmail mailhost="MailHost"> To: email(a)address.com From: <dtml-var from_user null="Some User <nobody(a)here.org>"> Subject: <dtml-var title> <html> <body> <dtml-var "html_to_text(getHTMLBody)"> </body> </html> </dtml-sendmail> </dtml-with> >> If you were doing this simple thing, which is to say, taking the html tags off of a tagged tract of text, rendering it as plaintext for an email, what process or procedure would you use? Cheers in advance, Chris

1 0

Link to a script from ZPT
by Borislav 03 Sep '02

03 Sep '02

Hi, I am having the following problem: In a ZPT I have a HTML link that points to a python script. I want to pass a parameter to the script. What is the right TAL expression to call the script passing it a parameter? I tried <a tal:attributes="href python:here.myscript('arg')">Link</a> but it replaces the href attribute with the output from the script, not what I had in mind... I would appreciate your help. Regards, Borislav

2 1

Re: [Zope] manage_clone ( pageTemplate, id )
by Dieter Maurer 03 Sep '02

03 Sep '02

Drew Nichols writes: > Could u tell me how to create a zpt on the fly. > I try context.manage_addPageTemplate (from the zope add method), but i get > an attribute error for the method. I find it hard to get details on page > templates. You need to read the Zope book or <http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html> To reduce the risk of name clashes, object creation uses two levels: product followed by constructor. Therefore, object creation usually takes the form: destination.manage_addProduct[product_name].constructor(constructor_arguments) Only a few object types (those that use old style initialization) are exceptional. Dieter PS: Please stay on the list.

1 0

RE: [Zope] Fwd: Re: Sept 11 2001 Anniv Bush Dollar. 1 Week.
by Keith J. Farmer 03 Sep '02

03 Sep '02

Folks In Charge: cleanup on aisle 5. Someone just got ill. -----Original Message----- From: Colonial Mint [mailto:alert@dianalist.com] Sent: September 03, 2002 02:39 Subject: [Zope] Fwd: Re: Sept 11 2001 Anniv Bush Dollar. 1 Week. > P.S.: All Americans should get one. Forward > this message to all your friends.

1 0

RE: [Zope] zope vs php-nuke
by Gerardo Amaya 03 Sep '02

03 Sep '02

>Does anybody in the list know a comparison between zope and php-nuke? >Could you post the reference? I don't think is fair to compare php-nuke with zope. First of all php-nuke is a built portal in php. You have administrative pages when you add delete Remove, from news, polls to articles etc. Zope is a completely different thing, look at it as a development tool not as a python built portal, you have to develop and program. Yes I know there Are a variety of products in Zope, but they only assist you. Simplifies some Common tasks, but they do not do the job for you. Look at php-nuke as php product, that helps you with tools to maintain a portal, but in the end, is a lot of php code. If you need to build you portal fast, php-nuke is the way, but if you are Asking for a development environment take a look at zope HTH sorry to send this with other mail but the one I subscribe is having some trouble Gerardo Amaya __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com

1 0