[IronPython] MySQL and Iron Python

[Ian Hobson]

While not the most efficent (or pythonic) approach, this works.

query = "SELECT ..... " # select one row
c.execute(query)
db = c.fetchmany(1)
rec = db[0]
def field(name):
     i = 0
     for d in c.description:
         if d[0] == name:
              return str(rec[i])
         i+= 1

rt.FindName("customerKey").Text = field("customerKey")

Regards

Ian


On 20/07/2010 21:47, Vernon Cole wrote:
> Field name access is the next development step. The API calls for 
> position (field number) access. Field name access is an extension. I 
> personally think that it is the obvious thing to do, but the movers 
> and shakers of the database API don't see it the same way.  My big 
> goal is to add that feature. I implemented name access for (input) 
> parameters in the last revision.
> (paramstyle='named').  So for today, you must use column position to 
> read the data.
> --
> Vernon