need to print the column names of results from a query automatically

Trounccrito

New Member
\[code\]strUserQuery = request.querystring("UserQuery")strQueryToBeExecuted = "Select * from (" & strUserQuery & ") where rownum < 501"\[/code\]How do I print the headings for the table automatically when the query runs? I tried printing off the first line but the query result does not have column names in it.I also tried using desc (table name), but that didn't work either. I'd be very thankful if someone could guide me.
 
Back
Top