Re: KeyError: self._index[x]

[tango ward <tangoward15@xxxxxxxxx>]

Sorry, accidentally pressed send.

cur_p = conn_pr(cursor_factory=psycopg2.extras.DictCursor)
cur_t = conn_t.cursor(cursor_factory=psycopg2.extras.DictCursor)


cur_t.execute("""
                SELECT TRANSLATE(snumber, ' ', '')
                FROM sprofile """)

# This will result in KeyError

for row in cur_t:

print row['snumber']

# This works fine

for row in cur_t:

print row[0]

Sorry again.

I would really appreciate any suggestions.

Thanks,

J