[Zope] Obtaining column names when using ZSQL method

[Nerlich, Andrew]

Yeah, thanks, I'm using Oracle on Linux (for which I can interrogate the
USER_TABLES or ALL_TABLES as well as DESCRIBE - from memory), and ODBC on
WIN32. AFAIK there's no counterpart to DESCRIBE for ODBC but you have to
rely on lower level ODBC functions to obtain column names, descriptions,
etc.

This info should be available to Zope and I'd prefer to get it from there if
at all possible, for purposes of RDBMS independence and portability. I also
require transactions, which AFAIK puts mySQL out of the picture.

AN

-----Original Message-----
From: darryl@igor.penguinpowered.com
[mailto:darryl@igor.penguinpowered.com]
Sent: Wednesday, 12 January 2000 4:55
To: Nerlich, Andrew
Subject: Re: [Zope] Obtaining column names when using ZSQL method


You should be able to get that columns and col types in you SQL Method.

I am using mysql and this works:

	describe tablename

-D