[egenix-users] db2 related question

[M.-A. Lemburg]

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...

True.

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.

Regards,
-- 
Marc-Andre Lemburg
eGenix.com

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
               http://www.egenix.com/company/contact/

> 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
>>