January 2004 - Zope - Zope lists

Re: [Zope] Problem inserting <dtml-var sequence-item> using ZSQL method in a dtml-in tag
by Gabriela LÃ³pez Ruiz 14 Jan '04

14 Jan '04

Yes, I also tried in that way but I get the following error. This site encountered an error trying to fulfill your request. The errors were: Error Type KeyError Error Value sequence_item I think that this is because is requiring with the form _[sequence_item] the definition of this variable in the REQUEST object, but in fact this variable doesn't depend on REQUEST object. Its on current Dtml method. >From: v.schnabel(a)aperto.de (Veiko Schnabel) >Reply-To: v.schnabel(a)aperto.de >To: Gabriela LÃ³pez Ruiz <glopezruiz(a)msn.com> >Subject: Re: [Zope] Problem inserting <dtml-var sequence-item> using ZSQL >method in a dtml-in tag >Date: Wed, 14 Jan 2004 16:53:31 +0100 > > > <dtml-call "updateStatementValues( > checklist_id=_['checklist_id'], > statement_template_id=_['sequence-item'])"> > > >On Wednesday 14 January 2004 16:24, Gabriela LÃ³pez Ruiz wrote: > > Hi all, > > I'm here again. > > Now I have a problem trying to insert a group of records in a relational > > table. I'm using ZSQL and the fact is that in the second column > > (statement_template_id) I need to insert the actual value of the > > sequence-item. But I can't use it in the dtml-call tag. When I print it >in > > the HTML table, the value is ok but I need to insert that value in the > > statement_template_id. > > How can I get the sequence_item value to insert it in the table? > > > > <dtml-in actual_boolean_value> > > <td><tr> > > <dtml-var actual_boolean_value><dtml-var sequence-item> > > </td></tr> > > <dtml-call "updateStatementValues( > > checklist_id=_['checklist_id'], > > statement_template_id=<dtml-var sequence-item>)"> > > </dtml-in> > > Thanks a lot for your suggestions. > > Gabriela. > > > > _________________________________________________________________ > > Charla con tus amigos en línea mediante MSN Messenger: > > http://messenger.latam.msn.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 ) > >-- >Aperto AG - In der Pianofabrik >Veiko Schnabel, Technology >Email mailto:v.schnabel@aperto.de >Chausseestraße 5, D-10115 Berlin-Mitte > >Phone +49 (0)30 28 39 21-306 oder O >Fax +49 (0)30 28 39 21-29 >Web http://www.aperto.de > _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.latam.msn.com/

1 0

ZSQL statement pass variables.
by RI Dunfey 14 Jan '04

14 Jan '04

Hi Everyone, I want to run a zsql select statement from a python script. I want to specify the column headings to include in the SQL statement in the python script before executing the script. I have tried using <dtml-sqlvar my_column_headings type="string"> but this puts quotes around them. ZSQL: select <my_column_headings> from applicant In my python I want to specify the headings as a variable, eg. my_column_headings = title, surname The variable is passed to the ZSQL and executed as: select title, surname from applicant. Do you see what I mean, is thgis possible? If so could someone point me in the right direction. Kind Regards, Rob

2 1

security (edit) problem for ttwtypes
by vogel＠glue.ch 14 Jan '04

14 Jan '04

I discovered a security problem in my plone/zope installation for every ttw-type. environment: - plone version 1.0.5 - os: windows 2000 - installed products: ttwtype, zopexmlmethods - created ttwtype 'ttwTypnamesFoo' in folder /myPloneFolder 1) at the root folder of my plone instance, I created a role A with permissions: a) Access session data und b) Access Transient Objects 2) I created user 01 with role A - correct: the user 01 never gets to see the tab with the edit-action - that's why on points 3) and 4) the access to the edit-form is done by typing the url directly in the url-field of the browser. 3) correct: - if user 01 wants to edit an object of type document (e.g. /Plone/index_html), the edit-form will be shown, but the user cannot save it. (-> msg: you are not allowed....) - url was: http://........../Plone/index_html/portal_form/document_edit_form 4) problem: - if user 01 wants to edit an object of a ttwtype (e.g. /myPloneFolderttwTypnamesFoo), the edit-form will be shown, and the user is ALLOWED to save it!! - url was: http://......./myPloneFolder/ttwTypnamesFoo/portal_form/ttw_edit_form any ideas how I can restrict the edit-and-save-access to my ttwtype objects? thanks for every input, david.

2 1

aq_parent in Netscape 4
by David Sumner 14 Jan '04

14 Jan '04

Hello, Has anyone had any issues using aq_parent to build bread crumbs. I have a breadcrumbs script that works pretty well in newer browsers. But using Netscape 4 seems to break it. It does not return anything. Does anyone know of a well implemented breadcrumbs script? Thanks

3 2

ZPT: nesting ul inside p
by Lee Harr 14 Jan '04

14 Jan '04

Hi; I understand (somewhat) why this does not work in a ZPT ...  <p> <ul><li>foo</li></ul> </p> (The p tag is being implicitly closed so that the ul tag can be started) But, should I not be able to have a list in a paragraph? _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus

2 1

ZODB A storage error occured during transaction abort.
by Dennis Allison 14 Jan '04

14 Jan '04

This is new in code that has been running for ages. The impact is significant--it brings the system to a halt, restarting is the only option. The database appears to have been left unsullied. QLOG is a ZSQL method that saves some data in the database. It references an external method that generates a string that's guaranteed to be unique. It keeps its persistent state in the local file system and uses file locking--all outside of the usual Zope context. The database method references a Zope python script method which computes a portion of the SQL query. There's nothing unusual about the script but for the fact that it embeds a sub-procedure. I read Dieter's lucid description of the source of this error in the mailing list archives, but I am at a loss to identify the method that registers the surrogate and does not have an _p_oid instance. This is all running on Zope 2.6.2b3, Python 2.3.1, RH7.3. I know there was a bug in 2.6.1 of this sort, but I believe it was expunged. >From the error log: 2004-01-13T17:15:21 ERROR(200) ZODB A storage error occured during transaction abort. This shouldn't happen. Traceback (innermost last): File /home/zopesys/lib/python/ZODB/Transaction.py, line 262, in commit File /home/zopesys/lib/python/ZODB/Transaction.py, line 393, in _commit_error AttributeError: Surrogate instance has no attribute '_p_oid' ------ 2004-01-13T17:15:21 INFO(0) ZODB conflict error at /lms/QLOG (2 conflicts since startup at 2004-01-13T12:24:00) ------ 2004-01-13T17:29:07 INFO(0) Z2 Caught signal SIGTERM ------ 2004-01-13T17:29:07 INFO(0) Z2 Closing all open ZODB databases ------ Any help tracking this one down appreciated.

1 0

RE: survey: zope 2.7 syntax errors with TAL statments over multiple lines
by Gerry Kirk 13 Jan '04

13 Jan '04

Maybe, but I've found this problem in a number of products, including CMFPlone and PloneCalendar, files that didn't produce errors in 2.6. There is definitely a difference in the way 2.7 is handling TAL statements spanning multiple lines vs. 2.6.2. Gerry > -----Original Message----- > From: Tres Seaver [mailto:tseaver@zope.com] > Sent: January 9, 2004 10:35 AM > To: Gerry Kirk > Cc: plone-users(a)lists.sourceforge.net; zope(a)zope.org > Subject: Re: survey: zope 2.7 syntax errors with TAL > statments over multiple lines > > > That smells like a line-ending problem; could the original > epoz_toolbox.pt have ^N characters embedded in it? > > Tres. > -- > =============================================================== > Tres Seaver tseaver(a)zope.com > Zope Corporation "Zope Dealers" http://www.zope.com >

2 1

ZODB error --
by Dennis Allison 13 Jan '04

13 Jan '04

I am getting this error which seems to be related to some XMLRPC actions. Can someone who knows more than I do about the ZOOB explain what's happening and suggest a fix? -d 2004-01-13T11:44:27 ERROR(200) ZODB A storage error occured during transaction abort. This shouldn't happen. Traceback (innermost last): File /lulu/zope/software_home/lib/python/ZODB/Transaction.py, line 262, in commit File /lulu/zope/software_home/lib/python/ZODB/Transaction.py, line 393, in _commit_error AttributeError: Surrogate instance has no attribute '_p_oid' ------

1 0

RE: [Zope] xml possibilities
by Passin, Tom 13 Jan '04

13 Jan '04

[garry saddington] > > On Tuesday 13 January 2004 19:20, Andreas Jung wrote: > > what is your *real* problem? > > > > http upload is fairly easy > > creating a dtml method with the content is trivial > > using zsql is trivial > > The real problem is taking an xml document with about 50 data > items and > inserting the data items (not the whole file) into Postgresql > via the web > using zope. There will be many such files each with the same > data items but > with different values. Then I would like to be able to export > an xml document > in the same format as the one above from the database via the > web using zope. You seem to be talking about converting an xml file into an sql statement that inserts the data into a database (or updates it, but of course you need to know which it is). To do this, you should use XML processing techniques, not text or regular expression handling. I would try to use an xslt stylesheet to convert from xml to sql. I have done that in the past with good results. You can get help on xslt stylesheets from the Mulberrry xslt list - read the xslt FAQs and query the archive first, though. Otherwise, you should probably use SAX to process the xml, for row-oriented data like yours (though there are other possibilities). However you do it, you will need to create an external method that can hand off the xml to the external Python code, and return the sql string. Once you work out how to do the xml processing, the rest need not be too hard. There are several xml and xslt libraries for Python, plus you could always execute a command line program from the Python code. Cheers, Tom P

2 1

RE: [Zope] xml possibilities
by Wilson, Derek 13 Jan '04

13 Jan '04

Generally the way this mailing list works is, you would try something, then ask for help when you encounter a problem. Instead, you said what you needed to do and expected someone to show you how. If you would like that service, I'm sure there are people who provide that service for a fee (zope.com) Otherwise, give it a try and let us know when you run into a snag. Thanks, Derek Wilson -----Original Message----- From: garry saddington [mailto:garry@joydiv.fsnet.co.uk] Sent: Tuesday, January 13, 2004 11:33 AM To: Andreas Jung; zope(a)zope.org Subject: Re: [Zope] xml possibilities On Tuesday 13 January 2004 19:44, Andreas Jung wrote: > write a script that that splits the xml file (check the python docs > for the xml processing possibilities) and then insert the stuff using > zsql metho calls.....trivial ......for you maybe, for a zope incompetent probably a week's work. Thanks for your help, i now know the direction to point my nose in! regards garry > > -aj > > --On Dienstag, 13. Januar 2004 18:22 Uhr +0000 garry saddington > > <garry(a)joydiv.fsnet.co.uk> wrote: > > On Tuesday 13 January 2004 19:20, Andreas Jung wrote: > >> what is your *real* problem? > >> > >> http upload is fairly easy > >> creating a dtml method with the content is trivial > >> using zsql is trivial > > > > The real problem is taking an xml document with about 50 data items > > and inserting the data items (not the whole file) into Postgresql > > via the web using zope. There will be many such files each with the > > same data items but with different values. Then I would like to be > > able to export an xml document in the same format as the one above > > from the database via the web using zope. regards garry > > _______________________________________________ > 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 ) _______________________________________________ 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 1