[egenix-users] db2 related question

M.-A. Lemburg mal at egenix.com
Thu Feb 25 17:35:55 CET 2010

Fernando wrote:
> Actually I spoke too soon. The main problem is in the existing Python
> references in the Zope frontend. DB2 returns everything in capitals and
> something in python like record["BuildCode"] will not work...


You'd have to use all lower or all upper case letters for
the dictionary access - or use positional access to avoid any
such issues.

Unfortunately, the Zope Results and Record classes (see
Shared/DC/ZRDB/Results.py and the Zope Record package)
don't support case-insensitive field access.

Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Feb 25 2010)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/ 
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611

> Regards,
> Fernando
> On Feb 25, 2010 14:49 "Fernando" <fernando at cmartins.nl> wrote:
>> On Feb 25, 2010 11:25 "M.-A. Lemburg" <mal at egenix.com> wrote:
>>> For the above to work, you have to create the tables, views,
>>> etc. without using quoted identifiers.
>> All right! Just tested and it works! How objects were created makes
>> all the difference on how they are treated afterwards.
>> Many thanks!
>> Fernando

More information about the egenix-users mailing list