- Zope - Zope lists

Re: [Zope] Arrg! dtml-in can't handle lists of pairs!
by Cary O'Brien 05 Jul '00

05 Jul '00

> "Cary O'Brien" <cobrien(a)Radix.Net> writes: > > It seems as if dtml-in handles lists of pairs specially. > It does, and it is documented. Where? I even looked through the code in DT_In.py and couldn't figure out where it handled this special case. This seems to me like a pretty big gotcha. I did find out that a list of two items was not handled the same way as a tuple of two items. Unfortunately I couldn't figure out how to invoke list(). > > For pairs, the first component becomes "sequence-key" and > the second "sequence-item". > > > Not a good thing. Can I supress this behavior? > Not that I know. Well, the only solution I came up with was to iterate with an index over the size of the thing. -- cary

2 1

International characters / search / objects / viewing ..
by Jørgen Skogstad 05 Jul '00

05 Jul '00

Kindest! Have anyone seen problems with international characters in ZClasses / searches? The problem only arise after the object is inserted into the object database.. and when viewed after the search.. when it is inserted into the object database all seems ok and looks just fine on the screen. "'Heisann .. dette er kun en liten test annonse for \345 vise at kontakt annonse biten omsider fungerer. Den er ikke optimal og det er en del punkter som b\370r gj\370res" .. the codes above are for norwegian characters.. and I was wondering how I fix this problem? Could this have something to say with "-L" option for starting Zope? .. or is this simply the object database cannot cope with characters other than the "normal english" alhpabet? Any input? Would be very happy! .. and have a real nice day! Kindest, Jørgen Skogstad

1 0

two stupid, non-technical questions.
by Jon Franz 05 Jul '00

05 Jul '00

Please excuse these questions, they are not my average question fodder... A) Are there Zope t-shirts available, or downloadable artwork to make your own Zope t-shirts? - this question was actually posed by a co-worker who seems to get his entire wardrobe from copyleft and software companies promoting their products... would a copyleft shirt be appropo? B) Has anyone modified their apache installation (if using the apache pass through to Zope) to return the server as being a Zope server? I ask because if we do not do this, then we (the Zope community) will only appear in the netcraft server surveys when using the stand-alone ZServer...

1 0

too many open files
by Ragnar Beer 05 Jul '00

05 Jul '00

Help! Zope 2.1.6 refuses to work in the middle of an external method on my i386 running under OpenBSD 2.7. Is says: ---------------------------------------------------- OSError [Errno 24] Too many open files: '/var/tmp/(a)6067.265' ---------------------------------------------------- I've never ever seen this problem before and this external method used to work well until some minutes ago. Now the error keeps reappearing even after rebooting and also other external methods that used to run well now deliver the same message. Does anybody have suggestions how to diagnose/cure this problem? --Ragnar

5 9

Reportlab and Zope
by Jorge Magalhaes 05 Jul '00

05 Jul '00

Hi: I try to use Reportlab lib's with my zope. In my DTML method i call the python file (External Method) with: <dtml-call "makereport"> All run OK, but i don't find the *pdf file. Where is my pdf file? ##########################3 # makereport.py ##########################3 import string from reportlab.pdfgen.canvas import Canvas from reportlab.lib.pagesizes import A3, landscape from reportlab.pdfgen.textobject import PDFTextObject from types import * import MySQL x=y=100 turmaa = 'Michael' DBH = MySQL.connect("localhost","aa","bb") DBH.selectdb("school") query= ("select score from exam where name= %s") % repr(turmaa) STH1= DBH.query(query) Scores= STH1.fetchrows(-1) c = Canvas("score.pdf", pagesize=landscape(A3), bottomup=0) c.setFont("Times-Bold", 12.0, leading=10.0) for scor in range(len(Scores)): c.drawString(x, y, Scores[scor][0]) y = y + 15 c.showPage() c.save() DBH.close() thanks in advance have a nice day Jorge

1 0

CorruptTransactionError (Bad news for production site!)
by Richard Taylor 05 Jul '00

05 Jul '00

Today I had to role back two days of transactions from my production site because when I packed the database I was informed of a CorruptTransactionError. We are using Zope for an internal knowledge management application where anyone in the organization can add objects. So I have no way of know what was added after the fateful transaction and no way of getting any of it back. Bummer! I think this raises a few questions about ZDB: 1) We need some tools for selectively removing bad transactions rather than just truncating Data.fs back to the last good one and loosing everything that comes after it. 2) We could do with a tools that can verify the ZODB offline. This could then be run at regular intervals (maybe once an hour from cron) so that corruptions can be picked up earlier. 3) Some way to find out what was added after a corrupt transaction is needed so that at least I could see who I need to ask to re-add their stuff. I love Zope I think it the best web application framework I have use (and I have used many), but this incident has shaken my confidence in the ZODB. I can live with the occasional error and I don't object to having to do some work to recover things. But, this appears to be an error from which I can not recover my data even though I have backups. Richard PS. Is there anyone offering commercial support for Zope in the UK. The more I am relying on Zope the more I think I need someone to provide guaranteed backup.

2 1

How to present a download button...
by Andreas Elvers 05 Jul '00

05 Jul '00

Hi, I am having trouble with a non standard download method. I want to provide a download link to a file, but not the standard one, because I would get the id as the filename. The id is a random value and thus not suitable for the customer. The real filename is saved in the title property. So I created a dtml method "download" like this one: <dtml-call "RESPONSE.setHeader('Content-Type', content_type)"> <dtml-call "RESPONSE.setHeader('Content-Disposition', 'inline;filename='+title)"> <dtml-var please_give_me_the_raw_data> And the link is: HREF="/some/where/my_file/download" Everything works fine with the filename. But how do I spill out the raw data to the browser? Any ideas ? Thanks for your help... - Andreas

1 0

(no subject)
by Andreas Elvers 05 Jul '00

05 Jul '00

Hi, I am having trouble with a non standard download method. I want to provide a download link to a file, but not the standard one, because I would get the id as the filename. The id is a random value and thus not suitable for the customer. The real filename is saved in the title property. So I created a dtml method "download" like this one: <dtml-call "RESPONSE.setHeader('Content-Type', content_type)"> <dtml-call "RESPONSE.setHeader('Content-Disposition', 'inline;filename='+title)"> <dtml-var please_give_me_the_raw_data> And the link is: HREF="/some/where/my_file/download" Everything works fine with the filename. But how do I spill out the raw data to the browser? Any ideas ? Thanks for your help... - Andreas

1 0

How do I call a parameter from inside of the same form?
by Sean G Richards 05 Jul '00

05 Jul '00

Hello, I am trying to build an SQL statement in a form, and then pass the statement onto a Z SQL method, for execution. something like < form action="search_results" method="get"> <input type="text" name="select_statement" value="SELECT name, phone_number, address FROM black_book WHERE" size=20> <select name="where_statement" size=3> <option value=" name = 'jennifer' ">Jennifer <option value=" name='anne' " > Anne <option value=" name='alice' ">Alice </select> <input type="hidden" name="cat_both_previous_statements" value="<dtml-sqlvar select_statement type=string> <dtml-sqlvar where_statement type=string>"> <input type="SUBMIT" name="SUBMIT" value="SUBMIT"> </form> I understand that this isn't the correct way to do this, I am just trying to convey what I want to do, and maybe someone can help me! Also, what would I do if the <select> box was multiple, where I could select more than one option? Well, if this is possible in Zope please let me know. Thank you and have a nice day! Sean Richards

2 1

RE: [Zope] Database Adaptors and security and query()
by Brian Lloyd 05 Jul '00

05 Jul '00

> Couple of things came up trying to use the current PostgreSQL da > and zope 2.2b3. I am working on a ZClass that lets you define > and create tables in a database, so I needed to execute some > generated sql [1]. > > 1) I couldn't access the query() method of the connection unless > I added our friend > > __allow_access_to_unprotected_subobjects__=1 > > to the DB class defined in ZPyGreSQLDA/db.py > > Is this ok? No - at least I highly doubt that your DBA will think so :) By adding that assertion, you have now made the query() method accessible to anyone who can write DTML on your site and they can now run arbitrary SQL on your database. You may also have made it possible for random joes to call the query method of the connection through the web with whatever query they want :( > > 2) Re calling query(). The query method only returns a tuple used > to create a Results object (which dtml-in would like). So I > added a method to return a real live Results object > > def query_result(self,query_string, max_rows=9999999): > return Results(self.query(query_string, max_rows)) > > Which does what I want. Is this ok? Is this a good idea? No, for the same reason as 1 > > 3) I went down several wrong paths until I realized that it seems > as if dtml-methods can't return anything but strings. Is this > right? If you are calling the dtml method, you will get a string (the rendered document) unless you use something like the 'return' tag: <dtml-return "('foo', 'bar')">. If you are going to this much trouble, you probably want to use an external method or something more suited to the task. > > > 4) Grumble. I had a lot of trouble with the interaction between > Results returning data as tuples, and dtml-in handling tuples > of 2 differently than everything else. Create a table with > 3 columns, everything works. Create a table with two columns, > things dont work. Is there access to list() anywhere? Not in DTML. > [1] I know, I can hear you saying "Use ZSQLMethods" but 1) > You can't subclass > them, and b) You can't put one inside a ZClass without a dummy > connection. "Use ZSQLMethods" :^) Seriously, it would be better to deal with the two problems above directly than to use workarounds that put security at risk. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0