Presenting a set with unknown number of columns (a
I've got a database with a variable amount of columns and column names. Is there a way to extract the number of columns and their corresponding column headings (column_names)? Please, help me. Any input is valuable.
...that you get from reading the schema.<BR><BR>Do you want an ADO answer, as well?<BR><BR>If so:<BR><BR><%<BR>Response.Write "<TR>"<BR>Set RS = yourConnection.Execute( "SELECT * FROM tablename" )<BR>For fldnum = 0 To RS.Fields.Count-1<BR> Response.Write "<TH>" & RS.Fields(fldnum).Name & "</TH>" & vbNewLine<BR>Next<BR>Response.Write "</TR>"<BR>%><BR>