Karen,
Humm. Ah. Yes. Obvious, isn't it! Thanks.
On Aug 16, 8:13 pm, Karen Tracey <kmtra...@gmail.com> wrote:
> On Sun, Aug 16, 2009 at 1:28 PM, rmschne <rmsc...@gmail.com> wrote:
>
> > I'm extracting data from a database and then cross-tabbing the data
> > (with some Python) code to create a list of dictionary data. Because
> > the key names are derived from data in the database, and the database
> > is composed of unicode text, the keys are unicode, e.g. here are three
> > records in the list of dictionaries:
>
> > 'Date': datetime.date(2009, 3, 31), (u'ORM',): 1L, (u'ORMR',): 23L},
>
> You might want to revisit how you are creating these dictionaries, because
> your 'unicode' keys are not unicode. They are single-element tuples where
> the single elements are unicode strings. Note the parens and comma in
> (u'ORM',): 1L, for example. If the key was the unicode string u'ORM' this
> would show up as simply u'ORM': 1L.
>
>
>
> > [snip]
> > The template is
> > {% for li in member_stats %}
> > {{ li.Date }} {{li.HON }} {{li.ORM }} {{li.ORMR }} {{li.CORP1 }}
> > {{li.CORP2 }} {{li.CORP3 }}
> > {% endfor %}
>
> > The Date fields come out as expected. The other fields do not.
>
> > Is it because they are Unicode? If so, how to deal with this. As
> > mentioned, these aren't hard-coded, but are coming originally from the
> > data to construct a cross tab table (sometimes called Pivot Table).
>
> From a template li.HON will translate to the dictionary lookup li[u'HON'] in
> Python. That will find a matching unicode key u'HON' but you don't have
> that, your keys are tuples. You can experiment in the shell to see what
> happens:
>
> >>> key1 = u'ORM'
> >>> key2 = (u'ORMR',)
> >>> d = {key1: 1L, key2: 23L}
> >>> d
>
> {u'ORM': 1L, (u'ORMR',): 23L}>>> d['ORM']
> 1L
> >>> d['ORMR']
>
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> KeyError: 'ORMR'
>
> >>> d[('ORMR',)]
> 23L
>
> I think you want to fix your dictionary creation step to actually create
> keys that are unicode, not single-element tuples.
>
> Karen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
