October 2003 - Zope - Zope lists

RE: [Zope] DTML Document ids
by Giuseppe Bonelli 16 Oct '03

16 Oct '03

> -----Original Message----- > From: Andreas Jung [mailto:andreas@andreas-jung.com] > Sent: giovedi 16 ottobre 2003 13.12 > To: giuseppe.bonelli(a)tiscali.it; zope(a)zope.org > Subject: Re: [Zope] DTML Document ids > > > > > --On Donnerstag, 16. Oktober 2003 13:04 Uhr +0200 Giuseppe Bonelli > <giuseppe.bonelli(a)tiscali.it> wrote: > > > Can someone explain to me why in the following code the > line starting > > with * outputs a null string and the line starting with ** > outputs the > > correct id of the DTMLDocument object ? > > > > <dtml-var standard_html_header> > > <dtml-in expr="objectItems('DTML Document')" prefix="sequence"> > > *<dtml-var "sequence_item.id"><br/> > > maybe because you haven't understand what the underscore > namespace is about. > maybe, but.. > Use <dtml-var "_['sequence-item'].id" > ... if I use the above I get an error (id does not exists as attribute of the DTML Document istance) ... > > And btw. *never* access the ID of an object why with 'id'. > You should *ever* > use obj.getId(). ... and if I use: <dtml-var "sequence_item.getId()"><br/> I get the expected id. Now, can you please elaborate a bit (or point me to some doc) on why I should use the getId() method instead of the id attribute? It happens that I have exactly this bad habit and I have quite a lot of code where I use id attributes :-( Thank for the reply, __peppo

1 0

DTML Document ids
by Giuseppe Bonelli 16 Oct '03

16 Oct '03

Can someone explain to me why in the following code the line starting with * outputs a null string and the line starting with ** outputs the correct id of the DTMLDocument object ? <dtml-var standard_html_header> <dtml-in expr="objectItems('DTML Document')" prefix="sequence"> *<dtml-var "sequence_item.id"><br/> **<dtml-var id><br/> </dtml-in> <dtml-var standard_html_footer> TIA __peppo

4 3

Re: [Zope] External method and image
by Alexis Roda 16 Oct '03

16 Oct '03

Michel Pottier wrote: > Le jeu 16/10/2003 à 08:37, Alexis Roda a écrit : > >>Michel Pottier wrote: >> >> >>>and in dtml page i have try: >>>" >>> <dtml-var standard_html_header> >>> ..... >>> <dtml-var "creGraph(REQUEST)"> >>>or <img src="<dtml-var "creGraph(REQUEST)">"> or .. >> >>try with >> >><img src="creGraph"> > > thank you for your help but <img src="creGraph" alt="toto"> > gives me my html page with "toto" (not the image) Does the external method need some parameter? What happens if you try: http://yourserver/yourpath/creGraph if this shows the image <img src="creGraph"> shoud work too. If the external method needs some parameter replace creGraph with creGraph?param1=value1&param2=value2 ... Just curious, resultat is a french word? HTH -- //// (@ @) ---------------------------oOO----(_)----OOo------------------------ Los pecados de los tres mundos desapareceran conmigo. Alexis Roda - Universitat Rovira i Virgili - Reus, Tarragona (Spain) --------------------------------------------------------------------

1 0

External method and image
by Michel Pottier 16 Oct '03

16 Oct '03

Hi I have one external method which create jpeg file. I shall want to be able to display these images in html page. I have tried different methods to do that, but either I get the image (only the image) or I get the html page ( without image). How this can be done? In external method i have something like: (stin,stout) = os.popen2(commande) stin.close() resultat = stout.read() stout.close() REQUEST.RESPONSE.setHeader('Content-type','image/jpeg') REQUEST.RESPONSE.write(resultat) and in dtml page i have try: " <dtml-var standard_html_header> ..... <dtml-var "creGraph(REQUEST)"> or <img src="<dtml-var "creGraph(REQUEST)">"> or .. <dtml-var standard_html_footer> " where creGraph is the external method Thank you for your help -- Michel Pottier METEO-FRANCE INTERNATIONAL Park Avenue 9 rue Michel Labrousse 31100 TOULOUSE Tel: +335 6143 2969 Fax: +335 6143 2969

3 2

DCOracle2 with Oracle 9i Rel2
by Satish 16 Oct '03

16 Oct '03

Dear all, Iam using DCOracle2 for Oracle9i Rel2 database. I create a stored procedure in the database, which is like : CREATE OR REPLACE PROCEDURE Testproc( p_username IN VARCHAR, RESULT OUT VARCHAR ) AS BEGIN SELECT username INTO RESULT FROM USERS WHERE username = p_username; END Testproc; Now, when i create a ZOracle Stored Procedure in Zope for this stored procedure it always gives an error "Testproc is not a valid stored procedure". Can someone pl. help on this. Is it because : DCOracle2 is mainly meant for OCI8 (oracle8) and hence doesnt work very well with oracle9, or is it someother problem. TAI Satish ITpreneurs.com

1 0

Using builtin "type" function in a Python FS product
by Gilles Lenfant 16 Oct '03

16 Oct '03

Is there changes in this usual Python builtin ? import types # somewhere in a method... if type(x) == types.UnicodeType: Raises... Error Type: UnboundLocalError Error Value: local variable 'type' referenced before assignment What did I miss ? Thanks by advance. --Gilles

5 6

Newbie Zope/Formulator/Namespace Difficulties:
by Sajec, Mike TQO 16 Oct '03

16 Oct '03

Hello, First off, I'm new to zope and formulator, and am having trouble understanding how namespaces are passed around. I would like to use a formulator-form to pass it's parameters to a python script, which will then call a zsql method. I created a formulator-form which collects the following data: orig_lot_id (string) system (string) start_date (datetime) finish_date (datetime) The formulator setting "action" is set to my python script pyProcessForm (see below) When I submit the form, I get the following error: Error Type: AttributeError Error Value: sql_display_recently_tested_lots Any help is very much appreciated. Thank you in advance, Mike ======================= pyProcessForm ======================= from Products.Formulator.Form import FormValidationError req = context.REQUEST error = '' try: container.form_query_recent.validate_all_to_request(req) except FormValidationError, e: for i in e.errors: title = i.field.get_value('title') text = i.error_text error = error + '<b>' + title + '</b>' + ' ' + text + '<p>' error_html = "<b>The following errors were found in the form:</b>\ <p>\ <blockquote style=\"color: red; font-size: 13px\">" + error + "</blockquote></p>" return error_html else: rec = context.sql_display_recently_tested_lots(part_code = formulator_field_part_code, start_date = formulator_field_start_date, finish_date = formulator_field_finish_date, system = formulator_field_system) print "fields: ", rec.names(), "\n" return printed =========================================================== sql_get_test_results( part_code, start_date, finish_date, system) ***This works*** =========================================================== SELECT ft_header.orig_lot_id, ft_header.start_date, ft_header.finish_date, ft_header.system, ft_header.serial_hi, ft_header.n_pass, ft_header.n_fail, ft_header.n_sites FROM ft_header WHERE ft_header.part_code = <dtml-sqlvar part_code type=string> AND ft_header.start_date >= <dtml-sqlvar start_date type=string> AND ft_header.finish_date <= <dtml-sqlvar finish_date type=string> AND ft_header.system = <dtml-sqlvar system type=string> ORDER BY ft_header.start_date DESC

1 0

Connecting to Zope with a Thick Client
by Etienne Labuschagne 16 Oct '03

16 Oct '03

We have created quite a few web-based solutions using Zope. We are now looking at using Zope for a project requiring an application server but with thick clients connecting to it. We will probably use Zope as the application server and connect to it with Python-based wxWindows clients (we MAY add a web interface later on, so Zope seems perfect). Since we would require "callback" abilities to the clients, XML-RPC would not be quite the perfect solution for client to Zope communications. The only way I can think of doing "callbacks" to a client with XML-RPC, is if the client polls the server for callbacks - not exactly a pure callback! We are thinking of using something like OSE to handle client to Zope connections and will have to plug OSE into Zope (or at least incorporate OSE abilities into the classes of our application). The first prize will be if we can plug OSE into Zope in much the same seamless way as XML-RPC is incorporated into Zope. Does this solution sound feasible or are there other better solutions? Any comments, suggestions would be appreciated! Etienne

3 2

Working with sqlvar type=float
by Mike Doanh Tran 15 Oct '03

15 Oct '03

I used the ZPublisher to convert a variable into a type float(see input field below). I passed the variable "balance" to a ZSQL method where balance was set as type=float. I keep getting an "invalid floating point type error" when i called the updateBal ZSQ method. I even tried to convert balance with _.float(balance) but still get the same error. The mysql db field for balance is set as type float. Can someone help me please? <input type="text" name="rec.balance:float:ignore_empty:records" value=""> --------------------------------- <dtml-in rec mapping> <dtml-call "updateBal(balance=balance,Cust_ID=Cust_ID)"> </dtml-in> -------------------------------- ZSQL Method: updateBal UPDATE customers SET balance=<dtml-sqlvar balance type=float> WHERE Cust_ID=<dtml-sqlvar Cust_ID type=nb> -------------------------------- Thanks, Mike

1 0

accessing REQUEST variable
by Mike Doanh Tran 15 Oct '03

15 Oct '03

What am i doing wrong here? I am trying to access a variable passed from a form. I named the input field current_delivery plus a Cust_ID(see below). The variable that i am tried to accessed is part a string and a variable. I've tried to contatenate the "string + variable" with the let tag and used that to access the REQUEST variable. <input type=text name="current_delivery<dtml-var Cust_ID>" value=""> <input type=hidden name="rec.Cust_ID:records"> ---------------------------------------------------------------------- <dtml-in rec mapping> <dtml-let delivery="'current_delivery'+Cust_ID"> <dtml-var "REQUEST['delivery']"> </dtml-let delivery> </dtml-in rec mapping> Basically, i am just trying to access the first input field from above: <dtml-var expr="'current_delivery'+Cust_ID"> Can someone help me with the syntax please? Appreciate any suggestions. Thanks, Mike

2 2