Retrieve column names from database

[threedim]

I plan to write a web form which accepts SQL statements and processes it and then displays the table corresponding to the SQL.

Problem is the only way I know how to output data from a row is like this:

objRecord("COLUMN_NAME&quot

Is it possible to retrieve all the column names from a table without knowing what the column names are?

 

[SrinuReddy]

Yes You can read the column names from the recordset.

Regards,
Srinu