My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 382: Get SQLite data by column names instead of column ids
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by a.navarr...@gmail.com, Aug 26, 2014
What steps will reproduce the problem?
1. Exec a select against SQLite database
2. Try to read the content of a column, by name
3. Attribute does not exist in "row", so you can access the value only using column id.

What is the expected output? What do you see instead?
The expected output is the content of the column, but I get "AttributeError: 'pyodbc.Row' object has no attribute 'COLNAME'", where "COLNAME" is the column name and "Row" is an object made by "row = DBCursor.fetchone()"

What version of the product are you using? On what operating system?
Python 3.3.1 + pyodbc 3.0.7

Thanks!

Powered by Google Project Hosting