Can I use Recordset in ADO to get the names of various fields in the database?

kodkok

rt
If a SQL statement is used to query a database from a database, is it possible to obtain the table header in this two-dimensional result set from this Recordset, that is, the field name of the corresponding data in the database table?

Please enlighten me heroes!
Greatful!

zqlove8395

Don't be so troublesome,
If you use it at the front desk: it can be used like this

select 1 as first column, 2 as second column
from tb

fanfan1980

<%
for i=0 to rs.Fields.Count-1
   response.write rs.fields(i).name
next
%>