[Zope-dev] Cookie with dictionary as content

2001-06-09 Thread florian_reiser

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

2001-05-15 Thread florian_reiser

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


[Zope-dev] ZPivotTable doesnt save its data dictionary

2001-05-13 Thread florian_reiser

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


Re: [Zope-dev] ZPivotTable doesnt save its data dictionary

2001-05-13 Thread florian_reiser

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


Re: [Zope-dev] ZPivotTable doesnt save its data dictionary

2001-05-13 Thread florian_reiser

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-in expr=folder_name.superValues(['Meta Type 1', 'Meta Type 2'])
 
   dtml-if name=sequence-start
 select name=my_select_list
   /dtml-if
 
   dtml-with sequence-item only
 option value=dtml-getId;dtml-title;/option
   /dtml-with
 
   dtml-if name=sequence-end
 /select
   /dtml-if
 
 dtml-else
   pbCannot find anything!/b/p
 
 /dtml-in
 
 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


[Zope-dev] ZPivotTable

2001-04-24 Thread florian_reiser

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