Re: getting list of columns from a query

On 08/22/2010 05:27 PM, c k wrote:
> As I am using MS Access for a long time, many tools like ms access
> provides a way to get the list of columns from a query. (using filed
> list in combo boxes in ms access). But is it possible to get such list
> of columns from a query where it is not known to the user, that which
> columns are defined in the base 'SELECT' statement? How? I dynamically
> created SQL statements many times this situation occurs where the
> columns are not fixed and we have to get the list of columns from such
> a query.

What language are you using, and what technique in that language are you
using?  (ex. Java and JDBC, C# and ADO.NET, PHP and PDO, or PHP and
PostgreSQL native)  Most of these provide a way to get to the column
names, but they're language- and technique-dependent.