Print pyodbc column value with variable holding column name

Question

I am trying to print the value of a column from a pyodbc query using variables so i can do some dynamic stuff.

columnName = "test1"

query = "SELECT test1,test2,test3 FROM testTable"
pyodbc.cursor.execute(query)
row = pyodbc.cursor.fetchone()

print(row.columnName)

not wanting to get column name. I am trying to call the column that i have as a variable in the print statement. — jman_pS, Jan 23 '22 at 23:05

score 1 · Answer 1 · 2022-01-24T05:19:21.290

1

You can use a variable like the one below to get the values for that column:

from pandas import DataFrame
import pyodbc

columnName = "test1"
query = "SELECT {} FROM testTable".format(columnName)
cursor.execute(query)

DF = DataFrame(cursor.fetchall())

Also you can get the columns data:

rows = cursor.fetchall()

Which is returned as a data tuple.

It is better not to take your command parameters from the user or the outside space because you may get a SQL injection attack. Cursor parameters are also used to set values so you can use the above solution and is not used for this purpose.

You can access all attribute of cursor in : https://github.com/mkleehammer/pyodbc/wiki/Cursor#attributes

edited Jan 24 '22 at 05:19

answered Jan 23 '22 at 05:50

not wanting to get column name. I am trying to call the column that i have as a variable in the print statement. – jman_pS Jan 23 '22 at 23:05
@jman_pS I changed answer to what you wanted. – Jan 24 '22 at 05:20

Print pyodbc column value with variable holding column name

1 Answers1