[DB-SIG] Re: May we get an actual ANSWER to the F.A.Q...How c an I construct a dictionary???

Jon Franz jfranz at neurokode.com
Thu Sep 25 12:12:34 EDT 2003

> How odd! I had assumed that this would be an error. On the
> other hand, I don't really see why anyone would like to do
> that, and I could accept that a tuple -> dict tool would
> fail silently on something like this. I haven't tried this
> with db_row etc...

I know from experience that ADO silently fails on this - the 
last column with a particular name prevents access to the 
other same-name columns, except by index.   This sort 
of thing can happen unexpectedly when you select * from 
multiple tables with some common column names - but 
that is bad practice anyway.

I think a silent failure is a Bad Idea(TM) - but which 
method would be acceptable to the community: 
- throw an exception
- allow access to the other same-name columns via a 
suffix/renaming scheme ('A:1', 'A:2', ...)

At first blush, I like throwing an exception.  The second 
option is semi-useful, but the name mangling would need 
to be Well documented and standardized.  Unless a user 
had read deep into the docs, mangling would be unexpected 
and possibly painful.

~Jon Franz
NeuroKode Labs, LLC

More information about the DB-SIG mailing list