How do I get the column names from a row returned from an adodbapi query?

Question

Suppose I query a database like this :

import adodbapi
conn = adodbapi.connect(connStr)
tablename = "[salesLT].[Customer]"

cur = conn.cursor()

sql = "select * from %s" % tablename
cur.execute(sql)

result = cur.fetchall()

The result is, I think, a sequence of SQLrow objects.

How can I get a list or sequence of the column names returned by the query?

I think it is something like this:

    row = result[0]
    for k in row.keys():
        print(k)

...but .keys() is not it.

nor .columnNames()

score 21 · Accepted Answer · answered Mar 17 '12 at 18:10

cur.description is a read-only attribute containing 7-tuples that look like:

(name, 
type_code, 
display_size,
internal_size, 
precision, 
scale, 
null_ok)

So for column names you might do:

col_names = [i[0] for i in cur.description]

Reference: http://www.python.org/dev/peps/pep-0249/

score 0 · Answer 2 · answered Feb 02 '21 at 16:33

0

q=conn.execute("SELECT * FROM YOUR_TABLE") pd.DataFrame.from_records(q.fetchall(),columns=q.keys())

answered Feb 02 '21 at 16:33

Mesum Raza Hemani

47
1
3

Can you clarify how this answers the question? This looks like you're using Pandas (which wasn't part of the original question) and also unclear how your answer satisfies what the OP (from 8+ years ago) was looking for. – Foon Feb 02 '21 at 20:05

score 0 · Answer 3 · answered Mar 17 '12 at 19:53

0

There is a columnNames property on the collection of SQLrow objects.

So,

for k in result.columnNames:
    print(k)

answered Mar 17 '12 at 19:53

Cheeso

189,189
101
473
713

How do I get the column names from a row returned from an adodbapi query?

3 Answers3

Linked