[egenix-users] column names ?

[stuff at mailzilla.net]

Thanks for the quick reply.  That did the trick.  Funny, I was printing 
the entire description tuple and missing the column name entirely and just 
assumed it wasn't in there.  My bad.

Thanks again,

Phil

On Mon, 4 Aug 2003, j vickroy wrote:

> Hello Phil,
> 
> After a query retrieval (e.g., cursor.fetchall()) look at the
> cursor.description attribute.  In particular, element zero of  each tuple,
> that is cursor.description, should contain the column name.
> 
> 
> 
> ----- Original Message ----- 
> From: <stuff at mailzilla.net>
> To: <egenix-users at lists.egenix.com>
> Sent: Monday, 04 August, 2003 14:59
> Subject: [egenix-users] column names ?
> 
> 
> >
> > Is there a way, via mxODBC to obtain the column names for a particular
> > query.  For example,
> >
> > c = db.cursor()
> >
> > sql = "SELECT * FROM foo"
> > c.execute(sql)
> >
> >
> > I've tried c.columns()  (before and after a fetchone()) but that always
> > yields -1 (at least when connected to SQL Server).
> >
> > c.colcount seems to return the correct number of columns, so that could be
> > useful.  Is there a way to map the column name to a column number.  That
> > is, if I have a colcount of 10, how can I determine the name of column 4?
> >
> > I suspect the answer is "no" considering that the pretty_print mx.ODBC
> > method seems to be unaware of the column names (at least according to the
> > mxODBC examples on the web site).
> >
> > Thanks for any info,
> >
> > Phil
> >
> >
> >
> > _______________________________________________________________________
> > eGenix.com User Mailing List                     http://www.egenix.com/
> > http://lists.egenix.com/mailman/listinfo/egenix-users
>