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
_______________________________________________
Users mailing list
Users@lists.ironpython.com
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
