September 2000 - Zope

Data date type returned by ZSQL method
by Stuart Foster 22 Sep '00

22 Sep '00

I am trying to format a date value that is returned by a ZSQL method but keep getting an error. I am using the same format string where I use ZopeTime <dtml-var ZopeTime fmt="%m/%d/%Y">. Yet when I try to use it for a timestamp field from PSQL I get the following error. Error Type: ValueError Error Value: unsupported format character 'm' (0x6d) It sounds like the value being returned isn't a true date type? Any clues?

2 1

GUF strange behavior
by Cesar A. K. Grossmann 22 Sep '00

22 Sep '00

Hi! I have discovered that I was fighting the wrong fight, against GUF. After making a login, I get the old, good, login page again. If I reload the page, then I get the correct index_html page, instead of the login page. What is wrong with this? I put the "pragma" "no-cache" in a META tag in the header of the docLogin method, but I still needs a reload to get the right page, instead of the login page. Is it a Netscape bug? Is it a GUF bug? Is it my mistake? I'm using Zope 2.1.6, GUF 1-2-4 in a Linux 2.2.x box. TIA -- César A. K. Grossmann ckant(a)usa.net http://members.xoom.com/ckant/ http://www.halcyon.com/sciclub/cgi-pvt/instr/instr.html

1 0

Re: [Zope] JDBC DA from Python
by Roman Milner 22 Sep '00

22 Sep '00

>>>>> "BB" == Brian Burton <Brian.Burton(a)nlynx.com> writes: BB> Has anyone come up with a way to access a JDBC driver from BB> Zope? I have since several JPython solutions but I don't see BB> a way of executing JPython from Zope. Would the best way be BB> to write a Zope/Python DA that opens sockets to a JPython or BB> Java servlet that then talks to the JDBC driver? Sounds like BB> a bit of work. I bet it would be easier than you think. There are at least 2 python DB API compliant interfaces to JDBC that I know of. So you should be able to write a generic python/jpython server that talks to a DB API and returns the results to the client. This is similar to how sqlrelay works. I think you should even be able to send pickles of the data retults over the socket - because as far as I know jpython and python use the same pickle code. I would bet that it is gonna be god awful slow. Might be good enough for small return sets though. ^Roman

1 0

Check if Image is uploaded solution
by peter bengtsson 21 Sep '00

21 Sep '00

I'll post this on Zope Tips. I've struggled with this for almost an hour soon, and since no good answer was provided in the mailinglist or the weblogs, I post it. ----- How to check if an Image has been uploaded from a file form or not. <precondition> <input type=file name=myimage> </precondition> <dtml-if "_.len(_.getattr(myimage,'filename')) > 0"> Image posted <dtml-else> No image posted </dtml-if> ----- Reflections on this? -- / Peter

2 1

nitpick
by Andy McKay 21 Sep '00

21 Sep '00

Why does an objects url have spaces in it? eg: /foo / bar / article.... If you ever copy and paste this, you then have to delete the spaces. Am I the only one who finds this annoying. Hack coming up :) -- Andy McKay, Developer. ActiveState.

2 2

JDBC DA from Python
by Brian.Burton＠nlynx.com 21 Sep '00

21 Sep '00

Has anyone come up with a way to access a JDBC driver from Zope? I have since several JPython solutions but I don't see a way of executing JPython from Zope. Would the best way be to write a Zope/Python DA that opens sockets to a JPython or Java servlet that then talks to the JDBC driver? Sounds like a bit of work. Brian

2 1

Assigning Permissions To Roles
by Kevin Howe 21 Sep '00

21 Sep '00

I am having trouble getting Roles to work via my Python Product. Creating a local role works fine: self._addRole('myRole') But how do I tell the Role what permissions it has programmatically? After looking in Role.py, I tried the following: self.manage_role('myRole', ['View management screens, View']) but this kicks up an error. Am I calling this impoperly? kh

2 1

Re: [Zope] Should I use ZODB or not ?
by Dieter Maurer 21 Sep '00

21 Sep '00

Jerome Alet writes: > Our needs are to store hundreds, and possibly thousands of MPEG2 and MPEG4 > (generally short) video movies, MP3 audio files, JPEG images, etc... > > Altough most of the files will be in the 1 Mb -> 10 Mb range, some could > be larger, e.g. some Gigabytes. > > For each file we also want to keep some data: author, subject, encoding, > description, keywords, domain, etc... > > I see 5 solutions: > > 1 - store both files and their associated datas in ZODB > 2 - store files in the filesystem and datas in ZODB > 3 - store files in the filesystem and datas in an RDBMS > (use Zope only for the presentation of files and datas) > 4 - store files in ZODB and datas in an RDBMS. > 5 - don't use Zope at all because it's not appropriate. Do not store the files in Zope or serve them with Zope. A standard web server (e.g. Apache) is at least one order of magnitude faster than Zope for static content (such as multi media files). This is essential for you large file objects. If you have up to a few thousand objects and they do not change too often, you can put them (the meta data) into the ZODB. Otherwise, put them in a RDBMS. I would use the RDBMS whenever I have one or I have more than a few hundred objects or I would need access to the data from legacy processes, too. Dieter

3 5

calling properties of ZClasses
by marwin98 21 Sep '00

21 Sep '00

Hello list, being (still) a newbie, I cannot find a solution to this: I have a folder "specialoffers", in which there are some ZClass-Objects of type "film" with properties "price" and "filmtitle". I'd like to show a list of _some_ filmtitles (defined in a property of the folder "specialoffers"). For a - probably - better understanding: () folder "specialoffers"- with property validfilms= [token] "flyci spanin" [] ZClass flyci - price = 1000 filmtitle= "Flying Circus" [] ZClass meali - price = 1300 filmtitle= "The meaning of life" [] ZClass spanin - price = 1290 filmtitle= "Spanish Inquisition" [] DTML-document "showvalids_html" Which DTML-commands do I have to use to show just the filmtitles of "flyci" and "spanin"? I've just managed to get this far: <dtml-in validfilms> <br><dtml-var sequence-item>  <dtml-var objectValues(sequence-item).filmtitle>  </dtml-in> Hoping that somebody is able to help me on this issue... BTW: Are there any tutorials with a listing of _all_ DTML-commands and functions? The .pdf "Zope Document Template Markup Language Reference" on zope.org doesn't cover all functions, I guess. Martin

2 1

How to preserve context?
by Marcin Kasperski 21 Sep '00

21 Sep '00

Within some folder I tried the following standard_html_header: ---------------------------- <dtml-with "PARENTS[1]"> <dtml-var standard_html_header> </dtml-with> ..some standard text I wanted to put on the front of all the documents... ---------------------------- (and similar method for standard_html_footer) The intent is obvious: I wanted to preserve the standard look and feel but to add something more. Unfortunately it does not work as expected: my standard_html_header uses bobobase_modification_time and it is read from the parent context, not from my document context. What can I do to solve it? -- http://www.mk.w.pl / Marcin.Kasperski | Moje prywatne strony: http://www.kasperski.prv.pl @softax.com.pl | @bigfoot.com \

4 4