By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,490 Members | 3,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,490 IT Pros & Developers. It's quick & easy.

Getting column names from a cursor using ODBC module?

P: n/a
Is there any way to retrieve column names from a cursor using the ODBC
module? Or must I, in advance, create a dictionary of column position
and column names for a particular table before I can access column
values by column names? I'd prefer sticking with the ODBC module for
now because it comes standard in Python.

I'm using Python 2.4 at the moment.

Thanks.
Jun 27 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Jun 21, 11:58 pm, dana...@yahoo.com wrote:
Is there any way to retrieve column names from a cursor using the ODBC
module? Or must I, in advance, create a dictionary of column position
and column names for a particular table before I can access column
values by column names? I'd prefer sticking with the ODBC module for
now because it comes standard in Python.

I'm using Python 2.4 at the moment.

Thanks.
Jun 27 '08 #2

P: n/a
On Jun 21, 11:58 pm, dana...@yahoo.com wrote:
Is there any way to retrieve column names from a cursor using the ODBC
module? Or must I, in advance, create a dictionary of column position
and column names for a particular table before I can access column
values by column names? I'd prefer sticking with the ODBC module for
now because it comes standard in Python.

I'm using Python 2.4 at the moment.
Do you mean the odbc module? If so, it doesn't come standard in
Python; it's part of the win32 package.

I haven't used it for years -- my preference on Windows these days
would be mxODBC if the client would pay the licence fee, otherwise
pyodbc. Sorry I'm not answering your question ... perhaps you should
be asking a different question :)

Cheers,
John
Jun 27 '08 #3

P: n/a
On Jun 22, 12:19 am, John Machin <sjmac...@lexicon.netwrote:
On Jun 21, 11:58 pm, dana...@yahoo.com wrote:
Is there any way to retrieve column names from a cursor using the ODBC
module? Or must I, in advance, create a dictionary of column position
and column names for a particular table before I can access column
values by column names? I'd prefer sticking with the ODBC module for
now because it comes standard in Python.
I'm using Python 2.4 at the moment.

Do you mean the odbc module? If so, it doesn't come standard in
Python; it's part of the win32 package.

I haven't used it for years -- my preference on Windows these days
would be mxODBC if the client would pay the licence fee, otherwise
pyodbc. Sorry I'm not answering your question ... perhaps you should
be asking a different question :)

Cheers,
John
But to help you answer your question: if the module that you are using
supports the 2.0 version of the database API (see http://www.python.org/dev/peps/pep-0249/),
then it will support the cursor.description attribute, which gives you
not only the name but the type and 5 other bits of info about each
column. If it doesn't, I'd suggest moving on.

HTH,
John
Jun 27 '08 #4

P: n/a
On Jun 21, 3:58*pm, dana...@yahoo.com wrote:
Is there any way to retrieve column names from a cursor using the ODBC
module? Or must I, in advance, create a dictionary of column position
and column names for a particular table before I can access column
values by column names? I'd prefer sticking with the ODBC module for
now because it comes standard in Python.

I'm using Python 2.4 at the moment.

Thanks.
You should be able to do

column_names = [d[0] for d in cursor.description]
Jun 27 '08 #5

P: n/a
Thanks Chris and John. Chris, this worked perfectly with the ODBC
module that ships with Python Win32:
column_names = [d[0] for d in cursor.description]
John, I've never heard of pyodbc but I'll have to look into it.

Thanks again.

Dana

Jun 27 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.