- Zope - Zope lists

RE: [Zope] Populating a form
by McDonnell, Larry 26 Apr '02

26 Apr '02

Hi Ian, Thanks for the reply. I know it is early there and a Friday/Saturday and this can wait until Monday. I see that I need to call the record from an http address and this assumes the users have something between their ears. I need this query to appear on the screen for the users to enter. The project I am piloting is to move to web based forms for our factory employees to input data and if someone wants to review it pull up an existing record by entering for example "doc_number". The user will enter this and hit a submit button. The form outline is what they are familiar to and I need to work on this premise. I created the input form using dreamweaver. I added the dtml statements and sql methods. I can populate the database. I know this is old time stuff using a different environment. I am trying to move to a thin client out on the factory floor and eliminate buying software for each workstation. If I use my z sql query, the data is displayed in a table/record generate by "manage_test" form. I guess my question is do I need to script the query to return the record I am looking for and make a dtml call from the form? If that is the case, does anyone have a script talking to a database so I can see an example. -----Original Message----- From: icottee(a)localhost.localdomain [mailto:icottee@localhost.localdomain]On Behalf Of Ian J Cottee Sent: Friday, April 26, 2002 1:14 PM To: McDonnell, Larry Cc: 'zope(a)zope.org' Subject: Re: [Zope] Populating a form Hi Larry "McDonnell, Larry" <lmcdonnell(a)protonenergy.com> writes: > I am new to the Zope environment but I have been successful. I have been > able to add odbc database connection and through a form input information to > this database. Now I would like to view this information. I have set up z > sql methods and I can see the info under the manage_test format. I would > like to be able to re-populate my output form (its a copy of the input form > but without the submit). I have gone through the zope book but maybe I > missed something. Any examples or pointer I can use, thanks. If I understand you correctly, you want to have a form that displays just one record on the screen? A very basic method would be to create one ZSQL method to get your item and one DTML Document to display it. So your SQL Method would look something like this <params>pk</params> SELECT CODE, DESCRIPTION, PRICE FROM MYFILE WHERE ID = <dtml-sqlvar pk type=int> Lets say that simple method is called sqlSelect Now create a form in the same folder and it will look something like this (untested) <dtml-var standard_html_header> <dtml-in sqlSelect> My Code Is: <dtml-var CODE null=""><br> My Description Is: <dtml-var DESCRIPTION null=""><br> My Price is: <dtml-var PRICE fmt="%3.2f" null="0.00"> </dtml-in> <dtml-var standard_html_footer> If that form was called view_data you can call it with something like http://my.web.server:8080/view_data?pk=1 Which would display the data for the record with an ID of 1. You won't get may design awards for the interface though ;-) If you are putting the data back into the input fields you'd have just have stuff like <input type="text" name="iDescription" value="<dtml-var DESCRIPTION null="">"> hth Ian PS It's 2am here so forgive me for any mistakes above but that should drive you in the right direction.

3 2

syntax or namespace problem
by notices 26 Apr '02

26 Apr '02

Hi. I'm having a wonderful time with zope for the most part, but here is my snag. I can't seem to access a variable in the request called badsearch from DTML. I have a script named getCatalogpy that returns search results in a catalog, and if the number of results is too small, it sets a flag like so- (first) request = container.REQUEST request.set("badsearch","false") (then later on) found = container.np.phone.phoneCatalog() if len(found)>= mingoodsearch: return found request.set("badsearch","true") I can get badsearch from my Page Template for Results, like so. <body tal:define="results here/getCatalogpy; start request/start|python:0; searchby request/searchby; searchtext request/searchtext; badsearch request/badsearch; batch python:modules['ZTUtils'].Batch(results, size=10, start=start); previous python:batch.previous; next python:batch.next"> then it's used here: <span tal:condition="python:(badsearch=='true')">We find no matches. Here is the entire list.<br></span> so far, so good. But I also have a results page for WAP/WML browsers that uses the same script. It's done in DTML because a Page Template has to be good HTML, which WML is not. I want something like <dtml-if "badsearch == 'true'"> We find no matches. Here is the entire list.<br /> </dtml-if> but Zope can't find badsearch. It must be in the request, because the Page Template can find it after the script. I tried request/badsearch and a number of syntax variations. Thank you very much for your assistance, Annie

2 1

Advice for performance checking/tuning
by Hannu Krosing 26 Apr '02

26 Apr '02

Hi We are investigating use of Zope for a portal that will have about ~500.000 users. However our test shows that zope is only capable of delivering about 4 request/sec of medium complexity page on dual PIII 833 which seems way too low. We did our tests to straight Zope 2.3.4 (no apache or squid in front of it). Even when told to use 10 thread only 4 were active in top (others were there but were idle) and load average was never over 30%. Where/what should I start investigating ? Where do I find some docs on what makes zope extremely slow (I have found that <dtml-if xxx> where xxx is missing or overly complex authorization schemes can do it, but what else) ? -------------- Hannu

3 2

Searching for FieldIndex for objects that don't containg a certain value
by Clint Brubakken 26 Apr '02

26 Apr '02

I have a ZCatalog, and I have a field index called category, and I want all results where category != 'foo' , is this done easily? Or do I have to filter all results and reject those where category='foo'?

2 1

Virtual hosting question.
by Tony Schonfeld 26 Apr '02

26 Apr '02

hello everybody , I need to use virtual hosting with a Zope server and dymanic Ip. The most know method is with a apache front end server but can i use zope without apache by example with VHM and Dyn Ip ? many thanks for all comments and examples. Best Regards , Tony -- Tony Schonfeld * F5GIT * Phone: +33 675 236 530 Email: tony(a)schonfeld.eu.org - WWW: http://www.schonfeld.eu.org

3 2

No id with manage_addFile()
by Roger Ineichen 26 Apr '02

26 Apr '02

Knows sombody why the id is '' (empty) and the funktion not work? I send a file with a form: ----------------------------- <form action="addFile" method="post" enctype="multipart/form-data"> <input type="file" name="file"> <input type="submit" value="upload"> </form> To the python method: --------------------- def addFile(self,file): "This method adds a file" # create the file self.manage_addProduct['OFSP'].manage_addFile(id='', title='', file=file) # redirect to main page return self.REQUEST.RESPONSE.redirect(index_html, url_quote(message))) The error is: ------------- The id "" contains characters illegal in URLs. Mit freundlichen Grüssen Roger Ineichen ___________________________ Projekt01 GmbH www.projekt01.ch Langackerstrasse 8 6330 Cham phone +41 (0)41 781 01 78 mobile +41 (0)79 340 52 32 fax +41 (0)41 781 00 78 email r.ineichen(a)projekt01.ch ___________________________ END OF MESSAGE

3 4

Dreamweaver ftp
by David Kyte 26 Apr '02

26 Apr '02

Hi Trying to use ZPT from dreamwever 4. Is it possible to change the ftp port defined in dreamweaver. Also trying to use webdave. Have defined the -W port to 9800. Connects thru ok, but when I try to pick up orders.html I get unable to authenticate with webdav server. Please enlighten me Thanks Dave

2 1

Re: Java Integration
by Thomas Mathes 26 Apr '02

26 Apr '02

Hello, >Since Chris is teasing a little, I'll tell you how he does it :) >http://jpe.sourceforge.net >Download that, it has everything that you need to get it done. >hth > >Phil Thank you for the information. I only want to know, if this is the ONLY POSSIBILITY for integrating Java into Zope

2 1

FTP Hang after PWD (desperate)
by Roel Van den Bergh 26 Apr '02

26 Apr '02

Problem: FTP client hangs after issueing PWD command. We are behind a firewall and the Zope server is behind a firewall I have access to ours but the people who are hosting the server are not very cooperative :-( Searching the message list I find this is due to a NAT problem For testing purposes I allowed every incoming port from the external server to go trough every port here wich I'm not very happy with. Still the ftp connection hangs. Does the Zope FTP server uses other ports then the initialy set 8021 port to communicate? The ftp client is set to passive mode. Running Zope 2.5.1 on RedHat 7.0 with Apache 1.312 Every tip would be very much appreciated TIA Roel

3 2

Non-zope website -> Zope guide ?
by Stephen Collyer 26 Apr '02

26 Apr '02

Anyone know of any guides showing how to convert a CGI based website to a Zope based one - I'm interested in anything on this, no matter how basic. Steve Collyer --------------------------------------------- Stephen Collyer Netspinner Ltd 01722 336125

2 1