- Zope - Zope lists

ZMySQLDA and aggregate functions on Win
by Dave Woolston 12 Jan '01

12 Jan '01

This is curious to me - I tried this on my Linux platform from mysql and it doesn't work. Perhaps I misunderstand what you are trying to do: SELECT COUNT(*) FROM mytable - returns a number - so I really don't expect it to work. I have a table - shop and a column in that table - article: mysql> select count(*) from show group by article; ERROR 1064: You have an error in your SQL syntax near 'show group by article' at line 1 Sorry if I misunderstand what you are trying to do - ================================= Dave Woolston davew(a)digicool.com Digital Creations www.digicool.com (716) 262-4715 > I have a problem with ZMySQLDA and aggregate functions in combination with > grouping on Windows. > When I say: > SELECT COUNT(*) FROM mytable GROUP BY myfield; > I get an KeyError 'Unhandeld'. > > SELECT COUNT(*) FROM mytable; > works fine, so does > SELECT myfield FROM mytable GROUP BY myfield; > but not the combination of both. > Also on a linux machine the error doesn't occur. Of course I tested the > queries from the mysql command line. > > Any help? > > Markus Kemmerling

1 0

ZServer
by Tom Deprez 12 Jan '01

12 Jan '01

Hi, Can anybody tell me what the following warning means, or where I can find documentation on this warning? ZServer warning : server accept() threw EWOULDBLOCK Thanks in advance Tom Deprez

5 7

Potential BUG "manage_addProperty" (was: [Zope] get property of type 'list') (was: [Zope] get property of type 'list')
by Dieter Maurer 12 Jan '01

12 Jan '01

Hi Andrei Andrei Belitski writes: > ... manage_addProperties(id='tok', type='tokens', value=[1,2,3,4]) ... > ... > &dtml-tok; > yields > ['[1,', '2,', '3,', '4]'] > ... I now understand what happens: You interpret "type='tokens'" in a way, that the property value is a list. And indeed, when you access such a property, you will get a list. However, "manage_addProperty" expects the value for a property with "type='tokens'" to be a *STRING*, more precisely, a string of whitespace separated tokens. It splits this string at whitespace to obtain the list (this will be a list of *STRING*, never integers). You do not meet this expectation. What "manage_addProperty" does is to convert your list into a string (this gives '[1, 2, 3, 4]') and then splits this string at whitespace. This might be considered a bug, as it is inconsistent with "PropertyManager._updateProperty" which only converts, if the value has type string. I am not sure, however. If "manage_addProperty" would behave in the same way as "_updateProperty", then you could store your list of integers. However, the first time that you change *ANY* property of this object (through the management interface), your property would be converted to "tokens" for presentation and converted into a list of *STRING*s during "manage_editProperties". Nevertheless, I do not see a reason for "manage_addProperty" and "_updateProperty" to behave differently. What you can do? Difficult to say! Currently, you can not safely use lists of integers as property values. They can very easily be converted into lists of strings. Can you live with lists of strings? Dieter

1 0

get property of type 'list'
by Andrei Belitski 12 Jan '01

12 Jan '01

Hi! I add a list property to a DTML document of type 'tokens' (e.g. '[1, 2, 3]') wenn i try to retrieve it with _.getitem i get '[1,' '2,' '3]' instead of '1' '2' '3' How can I get Zope to interpret my property like a list not a string or whatever else? Thank you in advance!

2 1

How do I get the size of an item ?
by Dimitris Andrakakis 12 Jan '01

12 Jan '01

...anyone ? Say I have these folders: / /news /news/files What I need is, from a dtml method in /news, to get the size of an object (a file, say /news/files/file01.pdf) in /news/files. Thanks in advance, Dimitris

2 2

Fwd: [Zope-dev] How to delete ZServer's zombie channel?
by J�lio Dinis Silva 12 Jan '01

12 Jan '01

Hi, some times I see in my /Control_Panel/DebugInfo/manage, channels opened longer than 48378.26s. How can I kill/delete a specific zombie channel/request? Thanx, Júlio Dinis Silva _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

Fwd: [Zope-dev] Zope max script execution time?
by J�lio Dinis Silva 12 Jan '01

12 Jan '01

Hi Is there a way to define a timeout or max script execution time for zserver requests? Thanx, Júlio Silva _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

ZCatalog uniqueValuesFor
by aZaZel 12 Jan '01

12 Jan '01

Hi, I have developed a web site for a customer where he add some ZClass instances that are zcatalog-aware. Everytime he edits the instances i do a reindex_object after the commit of the changes. I'm using the uniqueValuesFor () method do get the values of a field index on some forms but i found a quite strange behaviour. When he adds an instance , the value of the instace's indexed property is added (if the value is new) to the list that uniqueValuesFor returns....fine...it's correct . But when he deletes that instance, the uniqueValuesFor method still returns that value even if it should not be on the index. I think there is a problem of index referesh, but i have to do a full reindex to return the right list (e.g. without "dead" values). Im using Zope 2.2.0 and the catalog is running with subtransaction disabled . I have tried it on Zope 2.2.4 as well with the same results. Has anyone a workaround for that problem? I'm doing something bad? please help me! Alberto

1 0

RE: [Zope] way to cleanup form input text?
by sean.upton＠uniontrib.com 12 Jan '01

12 Jan '01

Write an external method in python that uses regsub.sub or regsub.gsub functions. This allows you to do regular expression substitutions. regsub.sub does a replace on the first match only regsub.gsub does a replace on all matches Ex: import regsub def process_a_string(self): """Processes a string, where string is passed as self""" result=regsub.gsub('[ \t][ \t]+', ' ', self) #Filters all duplicate spaces and return result #tabs down to one space char where somestring is our example attribute call this in dtml: <dtml-var expr="process_a_string(somestring)"> is somemethod is a method returning a string: <dtml-var expr="process_a_string(somemethod())"> Sean -----Original Message----- From: Chris Beaumont [mailto:cbeaumon@msri.org] Sent: Thursday, January 11, 2001 3:43 PM To: zope(a)zope.org Subject: [Zope] way to cleanup form input text? Is there a simple way to clean up text that's input to HTML forms in Zope? I have a situation where one of my users is copying text from her web browser and pasting it into Zope. I'm sure this is a common problem.. The input text ends up having runs of whitespace characters in it that I'd like to prune down to one each..and I think it's also been the source of some non-standard, unwanted characters that cause problems if they end up getting into our database.. I'm sure someone else has encountered this problem before..what's the best way to fix it? The string module doesn't seem to have what I want.. (or at least I couldn't find it..) The worst problems seems to be long strings of spaces or tabs that I'd like to turn into single spaces..(each) Thanks! Chris cbeaumon(a)msri.org _______________________________________________ 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

cross-reference tool
by Ragnar Beer 12 Jan '01

12 Jan '01

Hi Zopistas! The more variables I have in my external methods the greater the danger becomes that a typo slips through my alert eyes ;) and the more I wish I had a cross reference tool to check variable occurences. Is there such a tool for python? (I've never heard of one.) What are you using for debugging Zope stuff? Ragnar

2 1