- Zope - Zope lists

How manage error with zsql
by Miguel Beltran R. 11 Dec '08

11 Dec '08

I tried to insert data using an zsql, insert fine How manage error with zsql. Before <dtml-try> <dtml-call insert_data> Data inserted!!! <dtml-except> Error type:<dtml-var error_type> Error type:<dtml-var error_value> </dtml-try> Now (All files are ZPT) [index_html] ... <form action="proyecto_alta.html"> <input type="text" name="field1" id="field1" /> ... <input type="text" name="field2" id="field2" /> </form> [proyecto_alta.html] <div tal:on-error="structure here/error_insertar"> tal:condition="context/insert_data.zsql" tal:content="string: Data inserted!!!"> </div> [error_insertar] error=_['error'] if error.type==ZeroDivisionError: return "<p>Can't divide by zero.</p>" else: return """<p>An error ocurred.</p> <p>Error type: %s</p> <p>Error value: %s</p>""" % (error.type, error.value) But say Tipo Unauthorized Valor You are not allowed to access 'type' in this context TraceBack Traceback (innermost last): - Module ZPublisher.Publish, line 119, in publish - Module ZPublisher.mapply, line 88, in mapply - Module ZPublisher.Publish, line 42, in call_object - Module Shared.DC.Scripts.Bindings, line 313, in __call__ - Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec - Module Products.PageTemplates.ZopePageTemplate, line 330, in _exec - Module Products.PageTemplates.ZopePageTemplate, line 427, in pt_render - Module Products.PageTemplates.PageTemplate, line 96, in pt_render - Module zope.pagetemplate.pagetemplate, line 115, in pt_render - Module zope.tal.talinterpreter, line 271, in __call__ - Module zope.tal.talinterpreter, line 346, in interpret - Module zope.tal.talinterpreter, line 981, in do_onError_tal - Module zope.tal.talinterpreter, line 346, in interpret - Module zope.tal.talinterpreter, line 745, in do_insertStructure_tal - Module Products.PageTemplates.Expressions, line 199, in evaluateStructure - Module zope.tales.tales, line 696, in evaluate *URL: /ceed/finanza/proyecto/proyecto_alta.html* *Line 1, Column 0* *Expression: <PathExpr standard:u'here/error_insertar'>* *Names:* {'container': <Folder at /ceed/finanza/proyecto>, 'context': <Folder at /ceed/finanza/proyecto>, 'default': <object object at 0x0075A528>, 'here': <Folder at /ceed/finanza/proyecto>, 'loop': {}, 'nothing': None, 'options': {'args': ()}, 'repeat': <Products.PageTemplates.Expressions.SafeMapping object at 0x02382828>, 'request': <HTTPRequest, URL=http://sic/finanza/proyecto/proyecto_alta.html>, 'root': <Application at >, 'template': <ZopePageTemplate at /ceed/finanza/proyecto/proyecto_alta.html>, 'traverse_subpath': [], 'user': <User 'admin'>} - Module zope.tales.expressions, line 217, in __call__ - Module Products.PageTemplates.Expressions, line 139, in _eval - Module Products.PageTemplates.Expressions, line 91, in render - Module Products.PageTemplates.ZRPythonExpr, line 79, in call_with_ns - Module Shared.DC.Scripts.Bindings, line 327, in __render_with_namespace__ - Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec - Module Products.PythonScripts.PythonScript, line 327, in _exec - Module None, line 2, in error_insertar *<PythonScript at /ceed/finanza/proyecto/error_insertar>* *Line 2* Unauthorized: You are not allowed to access 'type' in this context (Example taked from http://www.plope.com/Books/2_7Edition/AppendixC.stx#2-28<http://www.plope.com/Books/2_7Edition/AppendixC.stx#2-28> ) -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

4 7

Re: [Zope] Problem using dtml-in in ZSQL method
by Jaroslav Lukesh 11 Dec '08

11 Dec '08

first, convert mylist to string before calling ZSQL method: <dtml-call "REQUEST.set('strmylist', _.str(mylist))"> And then call the ZSQL method: <params> strmylist:string="[0]" </params> SELECT * FROM MyTable WHERE id in (<dtml-var "strmylist[1:-1]" sql_quote>) ----- Original Message ----- From: Françoise CONIL To: zope(a)zope.org Sent: Thursday, December 11, 2008 11:21 AM Subject: [Zope] Problem using dtml-in in ZSQL method Hello, My ZSQL method receive a *mylist* parameter that should be an integer list : [21,35] The following code does not work : SELECT * FROM MyTable WHERE id in (<dtml-in mylist> <dtml-sqlvar sequence-item type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Type de l'erreur* NameError *Valeur de l'erreur* 'client' may not be used as an argument name in this context This other code does not work better : SELECT * FROM MyTable WHERE id in (<dtml-in mylist prefix="myid"> <dtml-sqlvar expr="myid_item" type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Same error* However, if I use a dictionary list of this type [{'id':21},{'id':35}] with the following code, it works (but it's heavy) SELECT * FROM MyTable WHERE id in (<dtml-in mylist mapping> <dtml-sqlvar id type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) The python script that calls my ZSQL method has already build the integer list and I would like to use it as is. Thanks for your help _______________________________________________ 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 )

2 2

Problem using dtml-in in ZSQL method
by Françoise CONIL 11 Dec '08

11 Dec '08

*Hello, *My ZSQL method receive a *mylist* parameter that should be an integer list : [21,35] The following code does not work : SELECT * FROM MyTable WHERE id in (<dtml-in mylist> <dtml-sqlvar sequence-item type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Type de l'erreur* NameError *Valeur de l'erreur* 'client' may not be used as an argument name in this context This other code does not work better : SELECT * FROM MyTable WHERE id in (<dtml-in mylist prefix="myid"> <dtml-sqlvar expr="myid_item" type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Same error* However, if I use a dictionary list of this type [{'id':21},{'id':35}] with the following code, it works (but it's heavy) SELECT * FROM MyTable WHERE id in (<dtml-in mylist mapping> <dtml-sqlvar id type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) The python script that calls my ZSQL method has already build the integer list and I would like to use it as is. Thanks for your help

3 2

sorting ids in python
by Garry Saddington 11 Dec '08

11 Dec '08

Can anyone help me sort the following by id in a python script? for object in context.objectValues(['Folder', 'DTML Document','ZipFolder','File','Image']): Import of sequence is not authorised in my python scripts, I am presuming (probably wrongly) that sequence is needed for sort. Regards Garry

4 10

Multiple zope instances using the same storage
by Mark Gibson 08 Dec '08

08 Dec '08

I have an unusual setup. I have 4 distinct Zope instances (4 seperate Data.fs'). Each Data.fs is identical - Data is kept in a RDBMS. I have a product I need to install that stores data in the ZODB. This data is stored in one folder. Now, I *think* I can simply mount this folder in each ZODB and serve the storage through a ZEO server - however I've never done this setup, so I want to make sure this makes sense and I'm not overlooking potential problems. This is a legacy setup that I'm not responsible for, so I'm trying to keep my footprint in this setup as small as possible. Using Zope 2.7.9. Thanks, Mark

3 3

pb with attach file
by blondelle＠abes.fr 08 Dec '08

08 Dec '08

Hello, Few months ago, I send my problem with attach file with Zope 2.6 and higher. How I have no solution, I send again my problem which is described after -------- Thanks to help me Frederique --------------- I have created a zclass with zfile as basic class. With this class, users could, via a web form, send an attached file if they want. With zope 2.5 (my previous version) if users don't attach a file, there is no problem with zope 2.10, if there is no file attached, I have an error message : 'file not specified". It seems that attach file is mandatory. Here, the complete message from the events log : Traceback (innermost last): Module ZPublisher.Publish, line 119, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 42, in call_object Module OFS.DTMLMethod, line 144, in __call__ - <DTMLMethod at /assistance/do_add> - URL: http://assistance.abes.fr/do_add/manage_main - Physical Path: /assistance/do_add Module DocumentTemplate.DT_String, line 476, in __call__ Module DocumentTemplate.DT_With, line 76, in render Module DocumentTemplate.DT_Util, line 196, in eval - __traceback_info__: _ Module <string>, line 1, in <expression> Module OFS.DTMLMethod, line 137, in __call__ - <DTMLMethod at /assistance/Quest_susvp_add> - URL: http://assistance.abes.fr/Quest_susvp_add/manage_main - Physical Path: /assistance/Quest_susvp_add Module DocumentTemplate.DT_String, line 476, in __call__ Module DocumentTemplate.DT_With, line 61, in render Module DocumentTemplate.DT_Util, line 196, in eval - __traceback_info__: REQUEST Module <string>, line 1, in <expression> Module ZClasses.ZClass, line 454, in createInObjectManager Module ZClasses.ZClass, line 485, in fromRequest Module ZPublisher.mapply, line 89, in mapply Module OFS.Image, line 120, in __init__ Module OFS.Image, line 501, in _read_data ValueError: File not specified

2 1

generic setup&workflow: how to add to binding??
by robert rottermann 08 Dec '08

08 Dec '08

Hi there, I created a workflow product. now I would like this workflow *added* to the bindings of the actual workflow settings when the product is installed. so I have something like: File (Default) chanched to File (Default) MyWorklow I this possible? If yes how? thanks robert

2 2

Guestbook example app stops working
by Bernard Devlin 06 Dec '08

06 Dec '08

Hi, I'm looking at the idea of using Zope again (a lot seems to have changed..) I'm using Zope 2.11.1, and whilst trying to remind myself of the basic machinery of Zope, I imported the Example apps, and started to fiddle around with the Guestbook example. However, after saving the index_html object of the Guestbook, Zope would no longer find any entries to display. To check it was simply the act of saving index_html that broke the Guestbook, I deleted the Examples folder and re-imported it. With a fresh Examples folder Guestbook worked; simply saving it (without even typing in the textarea) would break the Guestbook. On initial import it shows a single Guestbook entry by "Amos", but after saving index_html, it reports that the Guestbook is empty. No changes were made to the 'getEntries' script, and the Entries folder still has the entry by "Amos". I can't see any reason why that would be, and hoped someone else could explain what the problem is.

1 1

POSKeyError
by Rupesh P Raj 02 Dec '08

02 Dec '08

Hi, I am getting the following POSKeyError. Can anyone please tell me, what is the reason for this error, and how can I rectify it: 2008-12-02T03:16:11 ERROR ZODB.Connection Couldn't load state for 0x18fb01 Traceback (most recent call last): File "/opt/Zope-2.8.8/lib/python/ZODB/Connection.py", line 704, in setstate self._setstate(obj) File "/opt/Zope-2.8.8/lib/python/ZODB/Connection.py", line 740, in _setstate p, serial = self._storage.load(obj._p_oid, self._version) File "/opt/Zope-2.8.8/lib/python/ZEO/ClientStorage.py", line 746, in load return self.loadEx(oid, version)[:2] File "/opt/Zope-2.8.8/lib/python/ZEO/ClientStorage.py", line 769, in loadEx data, tid, ver = self._server.loadEx(oid, version) File "/opt/Zope-2.8.8/lib/python/ZEO/ServerStub.py", line 192, in loadEx return self.rpc.call("loadEx", oid, version) File "/opt/Zope-2.8.8/lib/python/ZEO/zrpc/connection.py", line 536, in call raise inst # error raised by server POSKeyError: 0x18fb01 Thanks Roopesh

3 2

problem with ms sql server
by Miguel Beltran R. 02 Dec '08

02 Dec '08

Hi list I have a zsql where made a UPDATE and INSERT, I need know when happen a error to show. I using pyodbc 2.0.58, zpyodbcda 1.0.6 and ms sql server 2000 [zsql with error after render: actualiza_info ] SET XACT_ABORT ON BEGIN TRANSACTION UPDATE taller SET comercial = '' where taller = 1 insert into taller_movimiento (estado, taller, fecha, asunto, observacion ) values( '14', 1, '', <--This must be not blank '', '' ) COMMIT TRANSACTION [dtml method] <dtml-try> <dtml-call actualiza_info> All Ok <dtml-except> Error, but not showed :( </dtml-if> If I test the zsql show this, but must show the error: This statement returned no results. ------------------------------ *SQL used:* SET XACT_ABORT ON BEGIN TRANSACTION UPDATE taller SET comercial = '' where taller = 1 insert into taller_movimiento (estado, taller, fecha, asunto, observacion ) values( '14', 1, '', '', '' ) COMMIT TRANSACTION -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

3 2