[Zope-dev] Cookie with dictionary as content
Hi guys, I'm developing the ZPivotTable product. For implementing the drilldown mechanism, I need to store the information about which columns and rows are open in a cookie. I thougt of storing this information in form of a dictionary, which would be stored in a cookie. The dictionary consists of several lists, containing the open columns or rows. Could you give me a tip how i can store the dictionary in the cookie. I've already tried to converting it to a string and converting the string back, when needed. Greetings Florian -- --- | Florian ReiserPGP-Key:0x5368CF3F| | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | --- PGP signature
[Zope-dev] Filling Selection Field in Input Form
Hi folks, i program an pivot table as an product. At the initialisation of the instance the user sets what SQL method he wants to use. Do you have me a tip how I can get the field names in my form, so the user can select which he wants to see? The SQL methods name is stored in a variable called _query inside the instance. How can I get the SQL method stored inside _query to execute and return its result? thanks in advance florian -- --- | Florian ReiserPGP-Key:0x5368CF3F| | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | --- PGP signature
Re: [Zope-dev] ZPivotTable doesnt save its data dictionary
jens, thank you very much for your help. Now I've only get to work out how to get the results of the query inside my Pivot table, so I can compute them. Greetings florian On Sun, May 13, 2001 at 11:22:14AM -0400, Jens Vagelpohl wrote: > florian, > > as far as i know you can call superValues from DTML. it returns a list of > objects. you could do something like this: > > > > > > > > > &dtml-title; > > > > > > > > Cannot find anything! > > > > jens > > > On 5/13/01 10:43, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > > jens, > > > > thanks for your reply. It helped me a lot. > > > > Do you have me a tip how I can get all Z SQL Methods in an selection field. > > I've found the superValues('Z SQL Method') function, but I'm having problems > > using it, because it can only be used in python. > > > > So how can I get the result returned from this function in my dtml form? > > > > thanx in advance > > > > florian > > > > > ___ > Zope-Dev maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) > > -- --- | Florian ReiserPGP-Key:0x5368CF3F| | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | --- PGP signature
Re: [Zope-dev] ZPivotTable doesnt save its data dictionary
jens, thanks for your reply. It helped me a lot. Do you have me a tip how I can get all Z SQL Methods in an selection field. I've found the superValues('Z SQL Method') function, but I'm having problems using it, because it can only be used in python. So how can I get the result returned from this function in my dtml form? thanx in advance florian On Sun, May 13, 2001 at 09:57:42AM -0400, Jens Vagelpohl wrote: > florian, > > without even looking at the code, when you use simple data types (lists, > dictionaries, etc) to store your data you have to make sure that the > persistence machinery gets tickled the right way whenever you update values. > with those simple storage datatypes it won't know things have changed unless > you specifically tell it. > > you would need to do either something like this:: > > self.my_storage_dictionary['newvalue'] = x > self._p_changed = 1 > > or you could do it like this: > > dictionary = self.my_storage_dictionary > dictionary['newvalue'] = x > self.my_storage_dictionary = dictionary > > or you could simply use one of the helper classes that come with zope, like > "PersistentMapping". it emulates a dictionary and makes sure the persistence > machinery gets told about changes. > > jens > > > > On 5/12/01 10:27, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > > Hi folks, > > > > I've started to program a pivot table. > > > > Therefore I've created three classes: > > > > ZPivotTable, Row and Cell. > > > > The ZPivotTable class contains a set of Row classes, stored in a dictionary, > > as well as the Row classes contain a set of Cell classes stored in a > > dictionary. > > > > Now I am debugging the product and can't find the reason why the table doesn't > > store the rows in its dictionary. > > > > Could you please help me finding this bug. > > > > The source is stored under the following address: > > http://www.zope.org/Members/freiser/ZPivotTable/ZPivotTable-0.0.tar.gz > > > > Thanks > > > > Florian Reiser -- --- | Florian ReiserPGP-Key:0x5368CF3F| | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | --- PGP signature
[Zope-dev] ZPivotTable doesnt save its data dictionary
Hi folks, I've started to program a pivot table. Therefore I've created three classes: ZPivotTable, Row and Cell. The ZPivotTable class contains a set of Row classes, stored in a dictionary, as well as the Row classes contain a set of Cell classes stored in a dictionary. Now I am debugging the product and can't find the reason why the table doesn't store the rows in its dictionary. Could you please help me finding this bug. The source is stored under the following address: http://www.zope.org/Members/freiser/ZPivotTable/ZPivotTable-0.0.tar.gz Thanks Florian Reiser -- --- | Florian ReiserPGP-Key:0x5368CF3F| | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | --- PGP signature
[Zope-dev] ZPivotTable
Hi guys, I want to program a pivot table similar to the one M$ Excel has. I feel there's the need for it. For the planned features see http://www.zope.org/Members/freiser/PivotTable/ I've thought that it would be best if I would create the following classes: - Cell (The table cell) - Column (The table column) - Row (The table row containing columns and cells. Columns only if one or more columns are drilled down) - Table (The table itself) Could you give me some advice if I'm on the right path, and give me alternative design ideas? Greetings Florian -- --- | Florian ReiserPGP-Key:0x5368CF3F| | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | --- PGP signature