Mapping Column Names to results using DBI

Timothy Grant tjg at avalongroup.net
Thu Jan 20 02:52:07 EST 2000


Aahz Maruch wrote:

> The point is that if you are choosing the order of column names in your
> SELECT, then it doesn't matter if the underlying table changes
> structure.  It is now safe to index by ordinal position.  Moreover, if
> you want to get really fancy, you could make up a list of field names,
> string.join() it for the SELECT, then map the list to a dict to get the
> ordinal position for each field name.

Sorry for being thick as a brick on that one. Thanks for the
clarification much appreciated!

-- 
Stand Fast,
    tjg.

Chief Technology Officer              tjg at exceptionalminds.com
Red Hat Certified Engineer            www.exceptionalminds.com
Avalon Technology Group, Inc.                   (503) 246-3630
>>>>>>>>>>>>EXCEPTIONAL MINDS, INNOVATIVE PRODUCTS<<<<<<<<<<<<




More information about the Python-list mailing list