- Zope - Zope lists

calling Z SQL methods specified by strings
by blu_frisbee＠web.de 20 Apr '03

20 Apr '03

http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/AppendixB.stx objectItems() gives a list of tuples (name, object) of folder content. convert this to a dictionary d = { name:value, ... } (see python dictionaries for this) and <dtml-in generatedemails> <dtml-var expr="d[name]"> will call the resp. objects. ______________________________________________________________________________ UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101

1 0

ZopeLDAP and unicode problem
by Adam Szpakowski 20 Apr '03

20 Apr '03

Hi, I have strange problem in combination of Zope, LDAP server and ZopeLDAP product. In LDAP the entries are held in unicode (utf8). And those entries using some PHP script can be converted to iso8859-2. So on server side everything is ok. But when I'm querying those entries in Zope the result is buggy. The national characters (polish in my case) are converted to something strange. I'm working on linux, Zope 2.6.1 and dummy codecs.lookup set to 'iso-8859-2' in z2.py. I've also tried something like this: <dtml-in usersShow_proceed> <tr> <td><dtml-var expr="_.unicode(givenName)"></td> <td><dtml-var _.unicode(sn)"></td> <td><dtml-var expr="_.unicode(cn)"></td> </tr> </dtml-in> Effect is the same. When tryin something like this: <dtml-var expr="_.unicode(givenName,'iso8859-2')"> I've got: Error Type: TypeError Error Value: coercing to Unicode: need string or buffer, instance found Has anybody idea what is wrong in my procedure? Bests Regards -- Adam Szpakowski Silesian University of Technology - Institute of Physics Department of Optoelectronic e-mail: worf(a)optics.polsl.gliwice.pl

1 1

ldapDC
by Adam Szpakowski 19 Apr '03

19 Apr '03

Hi, Aim looking for somthing (mayby a product) which will allow me to query LDAP serwer. I'm not asking for authentication against LDAP serwer (i'm alrady doing this using LDAPUserFolder) but for a method which allows mi to query and manipulate objects in LDAP serwer from ZOPE (exactly from TAL using fe. some python scripts). The closest thing capable of doing this job is in my opinion the script LDAPUser.py and LDAPDelegate.py from LDAPUserFolder. Is there any other option more similar in use to the tandem of Z SQL Method and z MySQLDC? Thanks in advance -- Adam Szpakowski Silesian University of Technology - Institute of Physics Department of Optoelectronic e-mail: worf(a)optics.polsl.gliwice.pl

2 2

Re: Sorting on 2 or more properties
by Josef Meile 19 Apr '03

19 Apr '03

> I would like to sort first on the professor_name, then course_number, > and then finally student_name. I have googled and can only find examples > for sorting on one property at a time. I don't know if at the present you can do such things without extra programming, but when I asked it long, long time ago (when I was starting with zope), the answer was to create a third index with the concatenated values of my keys. In your case: professor_name, course_number, and student_name. Of couse, you will have to limit the size of those fields and add white spaces at the end. Regards, Josef

2 1

help with dtml and sql---counting database rows with sql method
by Kelley, Sean 19 Apr '03

19 Apr '03

Hi, I am trying to count database rows in a table by using the following call to the sql method: <dtml-call counter> In my counter zsql method I pass in no parameters. My sql script is: SELECT count(*) FROM IWPLNCHK This query works outside of zope but returns an error that no column name is assigned to the value. So I name to the resultant column: SELECT count(*) as p2_count FROM IWPLNCHK which work in an sql test in zope but still does not output the count value to the calling page. How do I pass this value back and display it? thanks, Sean

3 2

Illegal character in content
by Ed Colmar 19 Apr '03

19 Apr '03

I've been struggling with this error that I assumed was an illegal character in xml-rpc, but I went through the process of removing all the non-alphanumeric characters I could find... No Luck. I'm hoping someone else has seen this, and that I've just done something dumb. Any help would be greatly appreciated. Here's the error + trace: Error Type: Error Error Value: Syntax error at line 3397: illegal character in content Traceback (innermost last): File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/www/Zope/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: connections) File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/www/Zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manual_update) File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manual_update) File /usr/local/www/Zope/lib/python/OFS/DTMLMethod.py, line 127, in __call__ (Object: manual_update) File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: manual_update) File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_With.py, line 76, in render (Object: skins) File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_With.py, line 76, in render (Object: _[skinname]) File /usr/local/www/Zope/lib/python/DocumentTemplate/DT_Util.py, line 159, in eval (Object: update_performer_list(server)) (Info: update_performer_list) File <string>, line 2, in f File /usr/local/www/Zope/lib/python/Products/StarRaveClient/StarRaveClient.py, line 140, in update_performer_list (Object: sf) File /usr/local/www/Zope/lib/python/xmlrpclib.py, line 547, in __call__ File /usr/local/www/Zope/lib/python/xmlrpclib.py, line 630, in __request File /usr/local/www/Zope/lib/python/xmlrpclib.py, line 585, in request File /usr/local/www/Zope/lib/python/xmlrpclib.py, line 596, in parse_response File /usr/local/lib/python2.1/xmllib.py, line 168, in feed File /usr/local/lib/python2.1/xmllib.py, line 264, in goahead File /usr/local/lib/python2.1/xmllib.py, line 794, in syntax_error Error: (see above) Then here is the "update performer list" call.. The indents are getting wacked but is there anything obviously worng? def update_performer_list(self, server): """ get all performers from the server """ print "[connecting to]" print server addcount = 0 updatecount = 0 starRaveMasterServer = Server(server) # try: serverPerformers = starRaveMasterServer.get_all_performers() # except: # print "could not connect" # serverPerformers = [] # print serverPerformers self.SQL_remove_current_flags() if len(serverPerformers) > 0: for performer in serverPerformers: # print performer country = performer['country'] state = performer['state'] city = performer['city'] performertitle = performer['performertitle'] description = performer['description'] performerurl = performer['performerurl'] exists = self.SQL_get_serverperformer_count(performerurl=performerurl) if exists[0]['count'] == 0: addcount = addcount + 1 # print "[New, Adding]" self.SQL_add_serverperformer(performerurl=performerurl, performertitle=p erformertitle, city=city, state=state, country=country, description=description) else: # print "[Exists, Updating]" updatecount = updatecount + 1 self.SQL_update_serverperformer(performerurl=performerurl, performertitl e=performertitle, city=city, state=state, country=country, description=description) self.SQL_delete_noncurrent_records() return addcount + updatecount -- Green Graphics ::: Print and Web Design ::: 510.923.0000

1 0

zope 2.6.x, zcatalog and keyerrors
by Bakhtiar A Hamid 19 Apr '03

19 Apr '03

hi to all i have sites that's running on zope2.6 (cvs 2.6 branch) on linux and py2.1.3 and we have these errors[1] many times in the day. sometimes, the error is caused by adding stuff, sometimes while searching the catalog. updating the catalog clears the problem that arose from the searching of ZCatalog, but not while adding or modifying objects (that are CatalogAware. this is a ZClass that's been working from 2.1.6 up till 2.5.1) the only difference is that on previous incarnation, we did not use ZCTextIndex. is that where the problem may be? or is it Catalog? or me? thanks for any help --error Exception Type KeyError Exception Value -318038923 Traceback (innermost last): * Module ZPublisher.Publish, line 98, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module OFS.DTMLMethod, line 126, in __call__ * Module DocumentTemplate.DT_String, line 474, in __call__ * Module Products.ZCatalog.CatalogAwareness, line 125, in reindex_object * Module Products.ZCatalog.CatalogAwareness, line 121, in unindex_object * Module Products.ZCatalog.ZCatalog, line 530, in uncatalog_object * Module Products.ZCatalog.Catalog, line 395, in uncatalogObject * Module Products.ZCTextIndex.ZCTextIndex, line 166, in unindex_object * Module Products.ZCTextIndex.OkapiIndex, line 66, in unindex_doc * Module Products.ZCTextIndex.BaseIndex, line 165, in unindex_doc * Module Products.ZCTextIndex.BaseIndex, line 288, in _del_wordinfo

5 8

clear only one session var
by AM 19 Apr '03

19 Apr '03

Hi, This might be avery silly ques.. but how do I clear only one specific session variable?? Tried the followwing which didnt work: 1. REQUEST.SESSION.clear('var') 2. _.del REQUEST.SESSION['var'] 3. _.del REQUEST.SESSION.var 4. _.del( REQUEST.SESSION['var'] ) 5. _.del( REQUEST.SESSION.var ) Simply setting it to None wont work for me. I need to remove it from the session dict. TIA AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================

2 1

Passing back from a Python script
by Lalo Castro 18 Apr '03

18 Apr '03

Hi, What I'm trying to do is create a list of email addresses to send to based on entries in a form. My problem(s) are appending information to a dtml array, and passing back information from a python script. What I've been doing so far is: <dtml-if "User=='Bob'"><dtml-var "REQUEST.set('userlist',User)"></dtml-if>, but this has a serious limitation. The <dtml-var "REQUEST.set('this', that)"> sets the variable, but it overwrites what it is setting, so that I can't, say, add Bob based on one criteria and then add Bill based on another criteria. I'd like to be able to add the users (i.e. append another element onto the end of the userlist array), rather than set them, but I don't know if the code to do that exists. If anyone does, can you let me know? As an alternative to appending, I've been looking into getting a Python script to do a string.find and pass back the userlist information, but I'm unclear on how to pass the information back into the dtml-document. The dtml document has: <dtml-call expr="REQUEST.set('newvalue', string_find(User=User, username='Bob'))"> The python script has return string.find(username, User) I keep getting this error: Error Type: TypeError Error Value: expected a character buffer object Can anyone tell me what I'm doing wrong? Or how to pass back the information? Thanks in advance, -- Lalo Castro Programmer/Analyst McHenry Library (831) 459-5208

2 1

ZODB Cache Parameters
by Marc Burgauer 18 Apr '03

18 Apr '03

Hi How do I determine the best settings for the database Cache Parameters of a Zope installation. I operate a server receiving around 10 million hits per month, traffic is increasing by about 5% per month for a year now. I have noticed that performance is getting a bit slower lately and look into ways to optimise. I use Webalizer for stats and can provide more detail. Zope 2.3 Solaris 8 2 CPU Intel P2 about 450Mhz 1 GB of RAM Plenty of disk space Cheers Marc

2 1