- Zope - Zope lists

external method database connection
by Mark Twiddy 06 Oct '00

06 Oct '00

Hi ya Another newbe question sorry. How do I get a zope database connection from an enternal method? Thanks Mark

4 6

ZSQL returns integer only
by wmiller＠mediaone.net 06 Oct '00

06 Oct '00

The Oracle8i recordset I'm retrieving includes a few columns which are NUMBER(10,0) format which are milliseconds. I would like to divide each by 1000 and use the ROUND function to return a result with one decimal place, e.g. ROUND(column1/1000, 1). This works as expected in SQL*Plus. It returns the results as a number formated to one decimal place. ZSQL however returns only an integer. Any suggestions on how to get the decimal places to show?

1 0

FCGI or PCGI for Zope behind Stronghold for SSL, which way to go?
by Brad Clements 06 Oct '00

06 Oct '00

Can anyone offer their suggestion as to which method will be better, both in terms of speed and reliability? I do not need virtual hosting, just SSL. Thanks for comments.. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

1 0

Problems with animated GIFs
by Lars Heber 06 Oct '00

06 Oct '00

Hi there, I've got a strange problem with animated GIFs: They work fine in any browser. Uploading to Zope, viewing it. Animation goes up to the last frame, but instead of looping indefinitely, it stops at the last frame. Downloading that file from Zope, viewing it in any browser outside Zope, works perfectly! What's going on here??? Any ideas? P.S.: The content_type is image/gif. Do animGifs have another one? Just an idea... Have a nice weekend :-) Lars

1 0

Animated GIFs
by Lars Heber 06 Oct '00

06 Oct '00

Hi there, I've got a strange problem. I want to upload an animated GIF to my Zope, but when I want to view it, animation stops at the last frame instead of looping indefinitely. When not uploaded to Zope, the animation works fine, also, when I download the GIF by rightclick from a Zope site and view it again outside Zope, it works perfectly! What's going on here??? Any ideas? PS.: The content_type is image/gif. Do animGifs have another one? Just an idea... Have a nice weekend :-) Lars

1 0

Fwd: [Zope] LDAP won't work - yes I've applied the patch
by zope 06 Oct '00

06 Oct '00

Hi. In deed, I have the same problem. As an example, my LDAP Method consists of the following filter: uid=* With the following DTML-method, I'm getting data from my LDAP server. <dtml-in searchPerson> <dtml-let counter=sequence-index> <dtml-var bla>: <dtml-var "searchPerson[counter]"> </dtml-let> </dtml-in> The result contains the attributes with their value from the LDAPserver. When I'm trying to get the value of an attribute directly (i.e. with <dtml-var uid>), I'm getting the key error. Any idea? Marc LUDWIG >From: Roman Milner <roman(a)speeder.org> >Date: 05 Oct 2000 00:35:53 -0500 >Lines: 30 >User-Agent: Gnus/5.0807 (Gnus v5.8.7) XEmacs/21.1 (Capitol Reef) >Sender: zope-admin(a)zope.org >X-Mailman-Version: 1.0b8 >List-Id: Users of the Z Object Publishing Environment <zope.zope.org> >X-BeenThere: zope(a)zope.org > >I'm trying to get ldap methods to work with 2.2.2. I can access the >attributes of the objects returned from an ldap method with a python >extension fine, but dtml-in'ing the returned list doesn't work. I keep >getting an error (traceback below). > >Any ideas? > >Thanks, >^Roman > > >Your action caused an unknown error to occur. ><!-- >Error Type: KeyError > > >Traceback: >Traceback (innermost last): > File /home/ThePoint/lib/python/ZPublisher/Publish.py, line 171, in publish > File /home/ThePoint/lib/python/ZPublisher/mapply.py, line 160, in mapply > (Object: ltest) > File /home/ThePoint/lib/python/ZPublisher/Publish.py, line 112, in > call_object > (Object: ltest) > File /home/ThePoint/lib/python/OFS/DTMLMethod.py, line 172, in __call__ > (Object: ltest) > File /home/ThePoint/lib/python/DocumentTemplate/DT_String.py, line 528, > in __call__ > (Object: ltest) > File /home/ThePoint/lib/python/DocumentTemplate/DT_In.py, line 691, in > renderwob > (Object: ldap_user(uid='rmilner')) >KeyError: cn

2 1

Passing lists to zsql methods
by steve smith 06 Oct '00

06 Oct '00

I have a form comprising two selection lists, each supporting multiple selection. I want the inputs to become parameters to a zsql method. I find the input works if the user selects at least one item from each list, but fails with a 'bad object id' message if either list is left unselected. I have tried providing a default list value, no luck. Any ideas out there? The form looks like: <dtml-var standard_html_header> <p><font face="Arial">Use this form to specify the parameters for your query or submission <p>All fields are optional <p>Multiple selection is supported - hold down the CONTROL key</font> </p> <FORM action="dtSubmitRumour"> <SELECT name="Operators:list" multiple> <dtml-in dbRetrieveAllOperators> <OPTION VALUE='<dtml-var OperatorID>'> <dtml-var FullName null="None in particular"> </OPTION> </dtml-in> </SELECT> <SELECT name="Classes:list" multiple> <dtml-in dbRetrieveAllClasses> <OPTION VALUE='<dtml-var OperatorClassID>'> <dtml-var "FullName + OperatorClass + ' Class'"> </OPTION> </dtml-in> </SELECT> <input type="submit" value="Submit" name="B1"></p> </FORM> and the zsql method reads: use thetable BEGIN transaction INSERT INTO rumours (Description) VALUES (<dtml-sqlvar Description type=nb optional>) DECLARE @rumourid int SELECT @rumourid = MAX(rumourid) FROM rumours COMMIT <dtml-if Operators> <dtml-in Operators> INSERT INTO roperators(rumourid, OperatorID) VALUES (@rumourid, <dtml-sqlvar sequence-item type=int>) </dtml-in> </dtml-if> <dtml-if Classes> <dtml-in Classes> INSERT INTO rclasses(rumourid, ClassID) VALUES (@rumourid, <dtml-sqlvar sequence-item type=int>) </dtml-in> </dtml-if>

1 0

Migrating from 2.1.6 to 2.2.2
by James Howe 06 Oct '00

06 Oct '00

I have a Zope based web site running under 2.1.6. I want to move it to a different machine which will be running 2.2.2. Can someone identify the steps I need to take to make this move? What things do I need to be aware of in moving between these versions? Do I just need to copy the data.fs along with any required product files, or do I need move/configure other things. Thanks.

2 1

XMLDocument create attributes problem
by matt 06 Oct '00

06 Oct '00

Hi, I'm trying to make an external method create and set some attributes of nodes in an XML document. The following is a fragment of the code, and the error. I can't even get a valid attribute created, let alone set. Does anyone have some examples? Please could you reply to me as well as the list, regards Matt from Products.XMLDocument.XMLDocument import Document def add(self, id, title): ob=Document() ob.title=title ob.id=id id=self._setObject(id, ob) log_node = ob.createElement('log') an_at = ob.createAttribute('attribute1') Zope Error Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: too many arguments; expected 3, got 4 Traceback (innermost last): File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: CreateNewsItem) File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: CreateNewsItem) File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: CreateNewsItem) File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: CreateNewsItem) File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval (Object: addxmldoc('test', 'some_title_test')) (Info: addxmldoc) File <string>, line 0, in ? File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 270, in __call__ (Object: addxmldoc) (Info: (('test', 'some_title_test'), {}, None)) File /usr/local/zope/Zope-2.2.0-linux2-x86/Extensions/addxmldoc.py, line 11, in add (Object: Traversable) File /usr/local/zope/Zope-2.2.0-linux2-x86/lib/python/Products/XMLDocument/XMLDocument.py, line 283, in createAttribute (Object: Manageable) TypeError: (see above)

1 0

redirect to user's folder not working
by Erik Myllymaki 06 Oct '00

06 Oct '00

I am using this line in my index_html DTML method in the base root folder to redirect users to their proper folder so content can be specialized for each of them: <dtml-call "RESPONSE.redirect(URL1 + '/' + AUTHENTICATED_USER)"> I get an error: Error Type: TypeError Error Value: illegal argument type for built-in operation It works fine like hard-coded like this: <dtml-call "RESPONSE.redirect(URL1 + '/' + 'username')"> I can use <dtml-var AUTHENTICATED_USER> on the page and get the appropriate username though?! Any help appreciated. -- Erik Myllymaki erik(a)pacific-shores.com

4 3