March 2000 - Zope - Zope lists

sqlsession and postgresql
by Shortie Lo 23 Mar '00

23 Mar '00

(sorry for asking this question again. i do need some help... ^_^) my table schema: create sequence sessions_session_seq; create tale sessions ( session varchar(255), primary key (session) ); create table session_data ( session varchar(255), name varchar(255), value varchar(255) ); i have changed sqlSessionCreate SQL method: insert into sessions ( session ) value ( nextval('sessions_session_seq') :: varchar ) i wrote some tests in dtml method: <dtml-comment> things work </dtml-comment> <dtml-call Session> <dtml-call "SESSION.set('attribute1', formField1'"> <dtml-call "SESSION['attribute1']"> <dtml-in "SESSION.keys()"> <dtml-var sequence-item> = "<dtml-var "SESSION[_['sequence-item']]">"<br> </dtml-in> <dtml-comment> things don't work <dtml-call "SESSION.clear()"> </dtml-comment> if i uncommented "things don't work" block, i will get traceback: Traceback (innermost last): File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: SESSION.clear()) (Info: SESSION) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py, line 172, in clear File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line 408, in __call__ (Object: sqlDeleteValue) File /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 186, in _argdata (Object: sqlDeleteValue) Bad Request: (see above) -- 'Life is like boxes of chocolate, Forrest. You never know what you're gonna get.' -- Forrest Gump (1994) Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ ICQ#27118251 Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe

1 0

Use of Zope for data entry intensive app re-write
by Jim Beckstrom 23 Mar '00

23 Mar '00

I have an application (Windows/DOS) that I want to re-write for the web. It is a data entry intensive application, with approx. 200 screens for adding and updating a number of tables. I am currently looking at using PostgreSQL for the database. Is this application appropriate for Zope? Jim Beckstrom

2 1

Re: [Zope] Casting to a list
by Hung Jung Lu 23 Mar '00

23 Mar '00

>From: Ken Kinder <kkinder(a)MessageMedia.com> >That didn't seem to work. Am I doing this right? >... ><dtml-let assignment:list=assignment> > <dtml-in assignment:list> >  > </dtml-in> ></dtml-let> Arghh... I should have been more clear, hopefully someone else already has told you in the meantime, but if not, the colons should be in the HTML FORM fields, not inside the target DTML method. That is, if you have check boxes or multiple select form-input-elements, you would use something like: <input type=checkbox name="mychoices:list" value="myvalue1"> ... <select name="mychoices:list" multiple> <option> ... Inside DTML, you would just use the name "mychoices" without the colon. Something like: <dtml-in mychoices> <dtml-call "qryCAssign(user_id=_['sequence-item'], client_id=client_id)"> </dtml-in> If qryCAssign() is a DTML method instead of an external method, generally you would need to prepend (_.None, _,... ) to the argument list. That is, qryCAssign(_.None, _, user_id=.......) regards, Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

RE: SiteAccess breaks ZDConfera
by Alexander Staubo 22 Mar '00

22 Mar '00

Please send me the patch. The problem does not seem to have anything to do with URLs, but rather the objects indexed by the topic -- but I could be wrong here. Is there a way to modify ZDConfera/ZDiscussions to fix the problem, without patching ZPublisher? I wouldn't want to break something else in the process. -- Alexander Staubo http://alex.mop.no/ The difference between theory and practice is that, in theory, there is no difference between theory and practice. > -----Original Message----- > From: Evan Simpson [mailto:evan@digicool.com] > Sent: Wednesday, March 22, 2000 10:35 PM > To: Alexander Staubo; zope(a)zope.org > Cc: mike(a)digicool.com > Subject: Re: SiteAccess breaks ZDConfera > > > ----- Original Message ----- > From: Alexander Staubo <alex(a)mop.no> > > Adding a SiteRoot object to some folder upward from a > ZDConfera topic > > ("Confera Topic" object) will break the topic. > > I strongly suspect that this is a symptom of a known (to me) > incompatibility > between SiteAccess and ZCatalog. If ZDConfera uses a > ZCatalog to track > topics, it will not be able to retrieve them correctly. I > have a patch to > ZCatalog to fix this, but it hasn't been tested by anyone but > me. It just > replaces the resolve_url method of ZCatalog with one that > doesn't reenter > ZPublisher. If you're willing to test it, I'd be happy to send it. > > Cheers, > > Evan @ digicool & 4-am >

3 2

Re: [Zope] ANN: ZEO goes Open Source
by julio dinis 22 Mar '00

22 Mar '00

First God, then Zope, now this! How can I be a tester? Best regards, Júlio ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Can Zope extract an image (BLOB) from an RDB ?
by chas 22 Mar '00

22 Mar '00

I've got 8000 photos (jpeg format) stored in an Oracle database. The table that contains the photos has these columns which are of interest : PICTURE LONG RAW PICTURE_LENGTH NOT NULL NUMBER(14) My goals in order of progression are : 1. Extract the image from the database using ZSQL methods 2. Serve that image up directly to the web browser 3. Save the image to the filesystem or, even better, create a Zope Image Object Unfortunately, I'm stuck at step 1. Doing a request on the database with ZSQL methods is returning : Error, oci.error: (911, 'ORA-00911: invalid character\012') Is there any way for Zope to handle this or is this going to involve python-DCOracle scripts instead and then uploading into Zope ? Thank you very much in advance, chas

3 3

RE: [Zope] How do I get the owner of a document?
by Alexander Staubo 22 Mar '00

22 Mar '00

If the object inherits from CatalogAware, you get a bonus method called owner(), which you can call like so: <p>The owner of this document is <dtml-var owner>.</p> If not, you can use the get_local_roles() method. You need to iterate it -- best with an External Method. Like so: def GetOwner(self): for Role in self.get_local_roles(): if 'Owner' in Role[1]: return Role[0] return 'Zope' Add this External Method at top-level. Then, thanks to Acquisiton, you can access the value in any document thus: <p>The owner of this document is <dtml-var GetOwner>.</p> Hope this helps. -- Alexander Staubo http://alex.mop.no/ The difference between theory and practice is that, in theory, there is no difference between theory and practice. > -----Original Message----- > From: Oliver Andrich [mailto:oli@rz-online.net] > Sent: Wednesday, March 22, 2000 10:42 PM > To: zope(a)zope.org > Subject: [Zope] How do I get the owner of a document? > > > Hi, > > may be I am just to dumb or something like that, but Zope has > to now who is > the owner of a certain document. This is for sure, but how > can I get the owner > of a document from DTML or an external method? I read through > the sources and > maybe I am just to dumb or so to find it, but I can't find > any manage_* call, > that tells me how to do this? > > I have to write a small DTML method, that finds all > documents, that are > located in a givben hierachie which are owned by a certain user. > > Bye and many thanks, > > OLiver > > P.S.: Don't frustrated that I ask these things again and > again, but now I have > to deal with things in Zope, that I haven't dealt with before. ;-)))) > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) >

1 0

PHP vs Zope
by Nikolai Vladychevski 22 Mar '00

22 Mar '00

Hello, I recently started to work with php (+ Apache), and now I found Zope. At the first sight, Zope seems to be faster than php, but I don't know if it's my php application that is not so complex than Zopes objects. So I would like to ask, is there a benchmarks or articles or any sources that discuss about performance and developing PHP versus Zope? Also, i am cuirious, was Zope developed to replace PHP in the future? And what if PHP comes up with an interface like Zope, so what would be better? Many questions, isn't it .... Any comments are welcome. Thanks. Nikolai

5 5

ZopeTime inconsistency.
by Chad Streck 22 Mar '00

22 Mar '00

Yes, I'm a zope newbie, but could someone enlighten me on the following senario. I use the following dtml to get a date time field.... <dtml-var ZopeTime> <input type='hidden' name='dateposted' value='<dtml-var ZopeTime fmt="%Y%m%d%H%M%S">' size=14> ... and it produces the following html source.... 2000/03/22 15:34:29.4534 Us/Central <input type='hidden' name='dateposted' value='20000322213429' size=14> As you can see, the plain ZopeTime products the proper out put of 3:34 (15:34) where the formated one to bring it down to what I want to store in the system is showing 9:34 (2134) which is the time zone offset of the time zone I am in (CST6CDT). Has anyone seen this before or is there a known cause/fix? I looked on the zope site and the archives for this list, but didn't find anything on it. I saw a lot of hits on Google for ZopeTime about not returning proper values and other 'weirdness'. Any help would be appreciated. chad

1 0

Re: [Zope] img src (newbie)
by Tres Seaver 22 Mar '00

22 Mar '00

jessica lee tishmack <jlt29707(a)sci.tamucc.edu> > > > > > Say, for example, you uploaded an image called foo_jpg (Zope does not > > allow dots in object names). You could reference it from any object in > > the same folder as the image or nested folders using dtml-var > > > > <dtml-var foo_jpg> > > Thank you for your input..I think I need to explain myself a little > better, however. I have no trouble with a static image...the trouble I am > having is with images created on the fly. > > For example, I have a cgi program (which I would like to continue residing > in my linux structure.....static pages I would like to be in > my Zope structure). This program will generate a graph based > on the time units, and whatever particular data sets I pass as parameters > to the program. So, the image can't be stored on Zope, since the image > may be different each time it is brought up...for example, I have the > ability to pass the word "today" as a parameter...this means that > everyday, the graph generated will be different. Is there a way for > Zope to respond to a cgi program that's being called as "img src" value? I think maybe the issue got clouded by the phrase, "server-side includes". What you are asking for is not a server-side include: you want to generate a tag in Zope, something like: <img src="build_graph?units=hours&series_a=hit_count&series_b=load_factor"> This isn't SSI because the browser makes a separate request for the image, after/while loading the page containing the tag; SSI is massaged by the server before the browser ever sees the text. That said, it *is* feasible to build a parameterized image link, using exactly this kind of syntax. There are a couple of contributed products which do on-the-fly image generation: * "gdchart":http://www.zope.org/Members/teyc/ZGDChart "draws charts using data from your ZSQLMethod" * "TTImage":http://www.zope.org/Members/RainDog/TTImage Converts text strings into a GIF/PNG/JPEG images using TrueType fonts. I may have even missed one -- check out the "Zope Products":http://www.zope.org/Products page. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0