Python - Get value from field in Sql Server Statement

Question

I have a table animal in a SQLSERVER database with two fields: id and name.

I'm trying to do this:

cnxn = pyodbc.connect(
    'Trusted_Connection=yes;DRIVER={SQL Server};SERVER=localhost; DATABASE=TEST;UID=sa;PWD=123456'
)

id = 1

cursor = cnxn.cursor()

cursor.execute('SELECT id, name FROM animal WHERE id=?', (id,))

for row in cursor.fetchall():
    print row.name

But for some reason it gives me the next error:

Traceback (most recent call last):

AttributeError: 'Row' object has no attribute 'name'

Can anyone help me to get the value from the field and save it in a variable?

CyborgNinja23 · Accepted Answer · 2016-03-04 16:43:59Z

1

Instead of print row.name use print row[1]. The fetchall() returns a list of tuples in the form [(1234, 'Alice Cooper'), ...]

edited Mar 4, 2016 at 16:43

CyborgNinja23

2991 gold badge12 silver badges35 bronze badges

answered Mar 4, 2016 at 16:21

leancz

6885 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python - Get value from field in Sql Server Statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related